Lock and transaction traps
Blocking index builds, concurrent index builds inside transactions, immediate constraint validation, and missing lock timeouts.
Free client-side preflight
Catch the migration risk before merge.
Paste PostgreSQL SQL or the generated SQL from an ORM migration. Get a conservative risk tier, the three findings that deserve attention first, and the missing production facts your reviewer needs.
Your SQL stays in this tab.
This tool has no backend, analytics SDK, account form, or database connection. It does not execute SQL.
Result preview
The free report shows your three highest-risk signals.
It also names the production facts a reviewer still needs. Your SQL stays in this browser tab.
What this catches
Stop signals tied to release decisions.
The scanner prioritizes lock duration, rewrite exposure, destructive boundaries, rolling-deploy compatibility, and unbounded data changes.
Rewrite and backfill risk
Type changes, volatile defaults, large single-transaction updates, and missing batching or restart boundaries.
Compatibility and recovery
Drops, renames, NOT NULL enforcement, application rollout gaps, and facts needed before rollback can be trusted.
Field guides
Five migration patterns worth reviewing in full.
Each guide shows the dangerous shape, a staged alternative, and the evidence required before deployment.
Add NOT NULL without downtime
Expand, backfill, validate, enforce.
Build an index concurrently
Transaction boundaries, retries, validity.
Add a foreign key safely
NOT VALID, validation, both-table locks.
Change a column type
Metadata-only proof or expand-contract.
Rename or drop a column
Rolling-deploy and rollback compatibility.
Free signal, paid release artifact
The full gate answers how to ship and how to retreat.
| Free browser preflight | Full Capafy Risk Gate |
|---|---|
| GREEN, AMBER, or RED heuristic tier | PASS, REVISE, or BLOCK merge verdict |
| Three highest-risk signals | Statement-level findings with context and evidence |
| Missing production facts | Safer DDL and expand/backfill/validate/contract sequence |
| Static browser-only check | Rollback boundaries, tests, monitoring SQL, and PR comment |