More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    SaaS Database Migration Risk Analyzer

    1

    A senior database reliability engineer for auditing schema changes, detecting locks, and planning safe migrations.

    $34.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    SaaS Database Migration Risk Analyzer

    SaaS Database Migration Risk Analyzer

    Example session with this skill installed

    Analyze this Postgres 15 migration: adding a NOT NULL column 'user_type' with a default value to the 'accounts' table which has 5 million rows. Use an expand-migrate-contract strategy.

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

    The migration of the accounts table involves a high-risk metadata lock during the column addition and a potentially long-running data update for existing rows.

    1. Migration Overview

    This migration adds a NOT NULL column to a 5M row table in PostgreSQL 15. While Postgres 11+ handles DEFAULT values efficiently, the application compatibility during a rolling deploy requires a multi-stage approach to avoid write failures.

    2. Schema Comparison

    ObjectCurrent stateProposed stateChange typeRisk
    accounts.user_typeDoes not existVARCHAR(50) NOT NULLADDMedium (Locking)

    3. Destructive Change Detection

    • Finding: Adding NOT NULL to an existing column.
    • Severity: High (Application Compatibility).

    Impact: Old application versions will attempt to insert rows without this column, causing null value violates not-null constraint errors.

    7. Proposed Migration Script

    -- STAGE 1: Add column as nullable
    ALTER TABLE accounts ADD COLUMN user_type VARCHAR(50);
    
    -- STAGE 2: Backfill data in batches to avoid replication lag
    -- Execute via application task or background worker
    UPDATE accounts 
    SET user_type = 'standard' 
    WHERE id IN (SELECT id FROM accounts WHERE user_type IS NULL LIMIT 5000);
    
    -- STAGE 3: Add constraint after backfill is verified
    ALTER TABLE accounts ALTER COLUMN user_type SET NOT NULL;
    

    10. Deployment Runbook

    1. Preflight: Verify disk headroom for WAL growth during backfill.
    2. Execution: Apply Stage 1. Deploy code that handles null user_type.
    3. Monitoring: Track pg_stat_activity for long-held AccessExclusiveLocks.
    4. Validation: SELECT count(*) FROM accounts WHERE user_type IS NULL; must return 0 before Stage 3.

    Next steps

    • Provide the application-level query patterns to check index requirements for the new column.
    • Verify if 'standard' is the correct business logic default for all 5M historical rows.

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

    About this skill

    Database migrations are high-stakes operations where a single locking index or dropped column can cause data loss or extended outages. This skill acts as a senior database reliability engineer to audit schema changes before they hit production.

    What it does

    • Detects destructive operations such as table drops, type narrowing, or lossy casts that threaten data integrity.
    • Analyzes engine-specific locks to predict downtime risks and resource spikes based on specific database versions.
    • Evaluates application compatibility to ensure rolling deployments do not break when old code meets the new schema.
    • Generates safe migration scripts including idempotent backfills, batching strategies, and transaction boundaries.
    • Designs rollback strategies by distinguishing between fully reversible changes and those requiring compensating actions.

    How it works

    1. Scope definition: The user provides the database engine, version, current schema, and proposed migration files.
    2. Schema comparison: The agent generates a structured diff of tables, constraints, and indexes.
    3. Risk assessment: It classifies findings from Low to Critical based on locking behavior and data loss potential.
    4. Validation design: It produces a pre-deployment runbook with specific integrity checks and go/no-go criteria.

    Frameworks & tools

    Works with any major SQL engine including PostgreSQL, MySQL, SQL Server, and Oracle. It understands ORM behaviors from tools like Prisma, TypeORM, SQLAlchemy, and Django Migrations.

    Why this beats prompting it yourself

    Generic prompts often ignore the nuance of engine-specific locking or the "expand-migrate-contract" pattern needed for zero-downtime deploys. This skill enforces a 10-step reliability workflow that accounts for replication lag, WAL growth, and application version overlap.

    Use cases

    • Reviewing a complex PR that renames columns in a high-traffic production table.
    • Planning a multi-stage migration for adding a NOT NULL constraint to a million-row table.
    • Auditing third-party ORM-generated SQL for hidden ALTER TABLE locks.

    Known limitations

    Does not execute scripts or connect to live databases. Risk estimates are based on provided schema and volume data rather than real-time telemetry.

    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.

    Cannot execute SQL or connect to live DBs. Requires manual input of schema/volume metadata. Rollback scripts cannot recover data lost via DROP commands.

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

    Permissions

    Read Files
    Listed16 days ago

    What's inside

    Frequently Asked Questions

    The skill identifies high-risk operations like 'ALTER TABLE' locks or destructive column drops that often crash production environments. It provides engine-specific warnings and safe, multi-stage migration strategies to ensure zero-downtime deployments.

    It supports all major SQL engines including PostgreSQL, MySQL, and SQL Server, and understands migration patterns generated by ORMs like Prisma, TypeORM, and SQLAlchemy. Simply provide your current schema and proposed changes for a comprehensive audit.

    No, this skill is designed for safety and does not require access to your live database; it performs static analysis on your schema and migration files. You retain full control by reviewing the generated runbook before applying any changes manually.

    You receive the fully configured Database Reliability Engineer agent, including its 10-step reliability workflow and engine-specific risk assessment logic. This includes specialized modules for detecting replication lag risks and designing rollback strategies.

    While the skill cannot see your real-time traffic, it uses the schema complexity and your provided volume estimates to predict potential locking duration. It applies industry-standard heuristics for specific engine versions to flag 'Critical' risks that could cause table contention.

    New in Data & Databases