More screenshots

    Works with the AI tools you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIGitHub CopilotGitHub CopilotGemini CLIGemini CLI+20 more

    🗄️ SQL Migration Safety Doctor

    2

    The SQL Migration Safety Doctor is a specialized security and stability auditor for database migrations.

    $12

    Secure checkout via Stripe

    30-day refund guarantee

    Converts to your local currency at checkout

    0 installsSecurity scanned
    🗄️ SQL Migration Safety Doctor

    🗄️ SQL Migration Safety Doctor

    Example session with this skill installed

    Check the new migration in migrations/20231024_add_user_index.sql for any safety issues.

    • Read your context and instructions
    • Compiled the sql migration safety

    ⚠️ High Risk: Non-Concurrent Index

    • File: migrations/20231024_add_user_index.sql
    • Line: 4
    • Evidence: CREATE INDEX idx_user_email ON users(email);
    • Impact: Will lock the users table for writes.
    • Remediation: Use CREATE INDEX CONCURRENTLY in a separate transaction.

    Connects securely to your tools. The creator never sees your data.

    What you get

    Prevent production downtime caused by long-running table locksIdentify destructive DROP and TRUNCATE statements before executionDetect lossy column type changes that could lead to data corruptionEnsure all UPDATE and DELETE statements include safe WHERE clauses

    About this skill

    What it does

    The SQL Migration Safety Doctor is a specialized security and stability auditor for database migrations. It scans SQL files for destructive operations, heavy lock risks, and data integrity gaps before they ever hit your production environment. By identifying risky patterns like WHERE-less updates, lossy column changes, and non-concurrent index creation, it acts as a gatekeeper for your data layer.

    Why use this skill

    Prompting a generic AI for SQL reviews often misses subtle database-specific locking behaviors or platform-specific risks (like Postgres table locks). This skill uses a dedicated Python-based heuristic scanner combined with a rigorous audit checklist to provide evidence-based findings. It categorizes risks by severity—Critical to Info—and provides battle-tested remediation snippets to fix issues immediately.

    Supported tools and workflows

    • SQL Dialects: Optimized for Postgres, MySQL, and standard SQL patterns.
    • Framework Agnostic: Works with migrations from Rails, Django, Prisma, Flyway, Liquibase, or raw SQL files.
    • DevOps Integration: Ideal for pre-commit hooks or CI/CD pipeline simulations.

    Output format

    You receive a structured report detailing confirmed findings with file/line citations, a manual review checklist for complex logic, and specific SQL snippets to remediate the identified risks safely.

    ,sample_input:

    How to install

    Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.

    ~30 seconds
    1. 1

      Download the ZIP

      Free skills download straight away. Paid skills unlock right after purchase.

    2. 2

      Unzip into your skills folder

      Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.

    3. 3

      Ask your agent to use it

      Restart the agent if it was already running. It picks the skill up automatically - no config needed.

    Skills folder by agent

    Click the path to copy it. Create the folder if it does not exist yet.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean 3 months ago

    • Passed all security checks, Safe to install

    Listed3 months ago

    Frequently Asked Questions