Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Migration Safety Auditor

    1

    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

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    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.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Read-only analysis; cannot see runtime data distribution. Does not support SQLite or SQL Server. Does not apply migrations.

    How to use

    1. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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

    Permissions

    Read Files
    Write Files
    Listed18 days ago

    What's inside

    Frequently Asked Questions

    The auditor detects high-risk operations like non-concurrent index builds, table-rewriting ALTER commands, and adding NOT NULL constraints without validation, all of which can lock production tables and cause downtime.

    Yes, the skill performs a dependency check by scanning your application source code to ensure that any columns or tables targeted for deletion are no longer being referenced by your Rails, Django, or Prisma models.

    The skill is optimized for PostgreSQL and MySQL; it is compatible with migrations from ActiveRecord (Rails), Django ORM, Prisma, Alembic, Flyway, and Liquibase, as well as raw SQL files.

    Upon purchase, you receive the full skill package including the specialized hazard catalog, source code analysis logic, and reporting templates to integrate into your CI/CD or PR review workflow.

    While the auditor catches structural hazards and code dependencies, it cannot see live production data distributions; we recommend a manual staging rehearsal for high-risk changes flagged by the tool.

    This skill is designed to work with any AI agent that has file-system or repository access, allowing it to scan your migration directory and application source code simultaneously.

    New in Data & Databases