More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Database & Migration Review: Safe Schema Changes

    1

    Review schemas, indexes and slow queries, and plan zero-downtime migrations with batching, locks, verification and rollback.

    $12

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Database & Migration Review: Safe Schema Changes

    Database & Migration Review: Safe Schema Changes

    Example session with this skill installed

    PostgreSQL 15, orders table with 40M rows. I need to add a NOT NULL column "currency" with default 'EUR'. Is ALTER TABLE safe?

    • Read your context and instructions
    • Compiled the database & migration

    Summary: MEDIUM risk. Assumptions: PostgreSQL 15, rolling deploys, writes 200/s (verify on your version).\n\nPlan: 1) Expand: add currency as nullable (brief lock, set lock_timeout). 2) Deploy code that writes currency on insert. 3) Backfill in batches of 10k rows with short pauses, resumable. 4) Add a CHECK (currency IS NOT NULL) constraint as NOT VALID, then VALIDATE it. 5) Enforce NOT NULL. Rollback: drop the column until step 5.

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

    About this skill

    The migration you are about to run on Friday afternoon, reviewed first. This skill reviews your schema, indexes and queries, and turns risky database changes into a step-by-step plan you can run, verify and roll back.

    What it covers

    • Schema review: keys, foreign keys with indexes, exact money types, time zones, NOT NULL, unique and check constraints, multi-tenant keys, soft-delete traps, plain-text secrets
    • Query and index tuning: reads the plan, finds sequential scans, wrong composite index order, functions on indexed columns, leading wildcards, OFFSET pagination, N+1 patterns. Suggests the smallest index that works and tells you its write cost
    • Zero-downtime migrations with the expand and contract pattern: add, dual-write, batch backfill, switch reads, enforce, then remove later
    • Lock awareness, lock and statement timeouts, staged NOT NULL, online index builds, batching with pauses
    • A filled-in migration plan with lock level, verification query and rollback for every step, and the point of no return marked clearly

    Honest: asks for your engine and version (PostgreSQL, MySQL/MariaDB, SQL Server, SQLite, Oracle), states its assumptions, says "verify on your version" when unsure, and requires a backup and restore test before anything destructive. It never runs changes against shared or production databases.

    En español: revisa esquemas, índices y migraciones y planifica cambios sin caída. Responde en tu idioma.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.

    Advice depends on engine, version, data size and traffic, which it asks for and states as assumptions. It does not connect to or change production databases, and cannot measure real performance without the plan or data you provide.

    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 6 days ago

    Requires

    Nothing to install.

    Permissions

    No special permissions declared or detected

    Listed6 days ago

    What's inside

    Frequently Asked Questions

    PostgreSQL, MySQL/MariaDB, SQL Server, SQLite and Oracle. It asks for the engine and version because lock behavior differs, and says when to verify on your version.

    No. It reviews and plans. It never runs changes on shared or production databases.

    It adapts: small tables may not need batching, and it will say so based on the sizes you give.

    Yes, it reviews the generated or hand-written migration and flags statements that could lock or rewrite big tables.