Find the statements in your Rails, Django or raw SQL migrations that take a table-blocking Postgres lock - and the safe rewrite - before you deploy. Runs entirely in your browser — nothing is uploaded.
Same engine as the VS Code extension, byte for byte.
This page is the working piece. The full pack has everything below.
Names every statement in a Rails, Django or raw SQL migration that takes a table-blocking Postgres lock, and prints the non-blocking rewrite. 36 rules, PostgreSQL 12-17.
Independent Postgres consultancies bill migration and lock review at $150/hour and up; this is one review, priced once.
Buy the full version — $29It reads a migration file and names every statement that takes a lock Postgres will not share, such as ACCESS EXCLUSIVE on a table rewrite or SHARE on a plain CREATE INDEX. 36 rules, PostgreSQL 12-17. On the bundled 20-statement sample migration it returns 22 findings, 16 of them at error severity; the hand-split version of the same schema change returns 0 findings.
Rails and Django engineers who deploy to a Postgres database that has real traffic, and anyone reviewing raw .sql migrations written by an assistant. It is aimed at the person who runs the deploy and gets paged when a table stops answering, not at a greenfield project where every table is empty.
strong_migrations reads only the Rails DSL, squawk reads only raw SQL, and both run in CI after the migration is already in a pull request. Neither reads a Django operations list. This runs on the file in your editor, across all three formats, before the branch exists, and it knows which forms became safe in PostgreSQL 11 and 12.
Free: the migration file you have open, checked against all 36 rules, with the full message and the safe rewrite. No key, no limit on how often. The full version adds scope and ownership: every migration in the workspace in one pass, the review exported as Markdown or JSON for the change ticket, and an exit code for CI.
Independent Postgres consultancies bill migration and lock review at $150 an hour and up, and an incident review costs more than that once on-call time is counted. This is $29 once, with a 7-day full refund. The free tier covers the file you are editing right now at no cost at all.
One question, answered by the person who built it. Your email only if you want the answer sent.