Back to feed
Dev.to
Dev.to
7/22/2026
The original title is "Catch the dangerous Postgres migration at the CI step"

The original title is "Catch the dangerous Postgres migration at the CI step"

Original: Catch the dangerous Postgres migration at the CI step

Short summary

pg-migration-guard is a free, open-source tool that analyzes Postgres migration SQL files and flags operations that hold dangerous locks (e.g., CREATE INDEX without CONCURRENTLY, SET NOT NULL scanning under ACCESS EXCLUSIVE). It integrates as a GitHub Action to annotate PRs inline with safe rewrites. A paid version adds 33 rules, Liquibase support, and a Claude Code skill.

  • •Free tool flags lock-taking DDL in Postgres migrations before they reach production
  • •Integrates as a GitHub Action with inline diff annotations and safe rewrite suggestions
  • •Uses libpg_query for accurate SQL parsing; paid tier adds 33 rules and Claude Code skill

Generated with AI, which can make mistakes.

#open-source#ai-tools
Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

The Postgres migration that locks your table at 3am, and how to catch it in review
Dev.to
The original title is "Before the DDL: What a Useful Postgres Migration Rehearsal Must Show"
Dev.to
Block AI-Generated Infrastructure Mistakes in CI Before They Hit Production
Dev.to
I tried to build a DNA-inspired database. I accidentally made a Postgres index checker.
Dev.to