- Home
- Skills
- Data & Databases
- Migration Safety Auditor
Works with the AI Agents you already use
Migration Safety Auditor
This skill reads your pending migrations the way a staff engineer in review would, and tells you which ones take the site down and how to rewrite them.
$9
Migration Safety Auditor
Example session with this skill installed
audit my database migrations for production safetyaudit my database migrations for production safety
- Read your context and instructions
- Compiled the migration safety auditor
20260112_add_status.rb
🔴 will-lock-prod: ADD COLUMN status NOT NULL DEFAULT 'x' on orders (12M rows) rewrites the table under an ACCESS EXCLUSIVE lock.
Safe rewrite: add nullable → backfill in batches → add NOT NULL via ADD CONSTRAINT ... NOT VALID then VALIDATE CONSTRAINT.
🔴 will-lock-prod: CREATE INDEX index_orders_on_status blocks writes for the whole build.
Safe rewrite: CREATE INDEX CONCURRENTLY (outside a transaction).
Verdict: NO-GO. Highest priority: split the NOT NULL add.per-file 🔴/🟡/🟢 findings with the offending statement, the risk, the safe rewrite, and a go/no-go summary.
Connects securely to your tools. The creator never sees your data.
About this skill
Migration Safety Auditor
The dangerous migration looks exactly like the safe one — until it's holding an ACCESS EXCLUSIVE lock on your biggest table in production. This skill reads your pending migrations the way a staff engineer in review would, and tells you which ones take the site down and how to rewrite them.
Catches
- Full table locks on ALTER / ADD COLUMN NOT NULL
- CREATE INDEX without CONCURRENTLY
- Dropping/renaming a column still referenced in your application source
- NOT NULL / CHECK added without NOT VALID + VALIDATE
- Type changes that rewrite the table
- Backfills inside the deploy migration
- Missing lock_timeout / statement_timeout
- Un-rollbackable or non-transactional steps; unguarded destructive ops
Detects your tool: Rails, Django, Prisma, Alembic, Flyway/Liquibase, raw SQL.
Output: per migration, will-lock-prod / risky / safe — each with why it locks on a large table and the concrete safe rewrite — then a go/no-go verdict.
Read-only. Never runs, applies, or edits a migration. One caught lock pays for this many times over.
Read-only analysis; cannot see runtime data distribution. Does not support SQLite or SQL Server. Does not apply migrations.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 18 days ago