More screenshots

    Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLIVVS CodeWWindsurf+15 more

    🗄️ SQL Migration Safety Doctor

    by JustHandled Labs

    2

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

    Secure checkout via Stripe

    0 installsSecurity scanned

    See it in action

    You say

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

    Your agent does

    ⚠️ 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.

    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

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    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 1 month ago

    Listed1 month ago

    Creator

    JustHandled Labs builds focused agent skills for the work nobody wants to do by hand. Each one is a single repeatable job done well: catching the security and data mistakes that quietly ship, keeping docs and tests honest, gating the commands an agent is about to run, sharpening writing, and handling the founder chores around launches, outreach, and brand setup. Not generic AI productivity. Specific workflows that are easy to run, review, and repeat. Maintained by H.J. Westerfield, with a background in communications, editing, project coordination, customer support, and practical AI systems. Tools for people who want useful automation without theatrical complexity.

    Frequently Asked Questions

    Popular in Code Review