More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    ๐Ÿ—„๏ธ SQL Migration Safety Doctor

    2

    Review DROP, TRUNCATE, type changes, NOT NULL additions, unfiltered writes, renames, indexes, constraints and mixed backfill patterns.

    $12

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    ๐Ÿ—„๏ธ SQL Migration Safety Doctor

    ๐Ÿ—„๏ธ SQL Migration Safety Doctor

    Example session with this skill installed

    Review this illustrative SQL text without executing it: CREATE INDEX idx_user_email ON users(email); Explain the potential risk and what must be verified for the target engine.

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

    Illustrative review โ€” not a database execution

    Potential finding: non-concurrent index creation. The SQL creates an index without the PostgreSQL CONCURRENTLY option. This is a static review prompt, not a measured production lock event.

    What to verify

    • Confirm the target engine and version; CONCURRENTLY is PostgreSQL-specific.
    • Review table size, expected writes, transaction context and deployment window.
    • If PostgreSQL is the target, assess whether a concurrent build is supported and appropriate.
    • Confirm failure recovery and rollback handling separately.

    Limits

    No SQL was executed, no database was connected, and no lock duration or affected-row count was measured. Do not treat this example as authorization to deploy or as a guaranteed-safe rewrite.

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

    About this skill

    What you get

    A local Python scanner for selected risky SQL patterns, with file-and-line findings and a manual review checklist. It identifies patterns to investigate, not confirmed database defects or guaranteed-safe rewrites.

    How to use it

    Provide local migration SQL files or a folder. Review DROP, TRUNCATE, type changes, NOT NULL additions, unfiltered writes, renames, indexes, constraints and mixed backfill patterns. Then check the target database engine, deployment order, rollback feasibility and actual data impact.

    Boundaries

    This is not a complete SQL parser, database connection, lock-duration estimator or deployment gate. PostgreSQL, MySQL and SQLite differ; proposed changes require engine-specific review. A WHERE clause or DEFAULT does not prove safety.

    Verified release scope

    Package v1.0.1 was retrieved through Agensi creator access and tested in Claude on Linux with Python 3.13: 30 bundled tests and the fixture check passed. All 12 captured files match the sealed release, allowing one disclosed trailing-newline normalization. This is not a paid-buyer checkout test or universal host certification. Reports omit source excerpts but retain file paths; review sensitive output locally.

    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.

    Static heuristics, not a complete SQL parser or database safety proof. No database connection, lock measurement, affected-row estimate or verified rollback. v1.0.1 omits source excerpts but reports paths. Ambiguous or incomplete inputs require review. Windows junctions and hosts beyond the documented test environment remain unverified. Creator-delivery text capture is not paid-buyer checkout or raw ZIP-byte verification.

    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 today

    Software
    Python

    Python 3.10+ and authorized local SQL files are required. Missing runtime or files means the scan is unperformed, not clean. v1.0.1 creator-delivery tests passed on Linux/Python 3.13; other hosts need verification.

    Permissions

    Terminal / Shell
    Read Files

    File Scopes

    **/migrations/**/*.sql
    **/*.sql

    Read-only inspection first. The bundled scanner reads matching .sql files and prints markdown or JSON findings. It installs nothing, transmits nothing, modifies nothing, and never connects to a database. Any write, install, deploy, or live-account action requires explicit user confirmation.

    Listed5 months ago
    Updatedtoday

    What's inside

    Frequently Asked Questions

    It flags selected destructive changes, unfiltered writes and other risky SQL-text patterns for review. Severity is heuristic. Actual locks, data impact and the safety of a proposed change require separate target-engine verification.

    It reviews selected SQL patterns relevant to PostgreSQL, MySQL and SQLite, but it is not a complete dialect parser and does not verify engine behavior. Confirm syntax and operational impact against your actual database version.

    Provide the final SQL files generated by your migration workflow. The scanner does not execute migrations or inspect every ORM source format, and it cannot ensure that the underlying commands are safe.

    By purchasing this skill, you receive the full migration auditing agent, access to the Python-based heuristic scanning logic, and any future updates or security definition improvements provided by the developer.

    Use an agent host authorized to read local SQL files and run Python 3.10+. Review findings and unavailable-input warnings. It is an advisory review step, not an automatic deployment approval or proof that a clean result is safe.

    The package provides repeatable local pattern checks and a documented review checklist. It does not establish superiority over a strong prompt, detect every issue or provide database-tested rewrites for your environment.

    New in Data & Databases