Works with the AI tools you already use

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

    Database Doctor — Persona

    1

    Database reliability expert for schema design, migration safety, and execution plan analysis.

    $59

    Secure checkout via Stripe

    30-day refund guarantee

    Converts to your local currency at checkout

    0 installsSecurity scanned
    Database Doctor — Persona

    Database Doctor — Persona

    Example session with this skill installed

    I need to add a non-null column with a default value to our 500 million row users table in Postgres 12. Here is the proposed SQL. Can you review it for downtime?

    • Read your context and instructions
    • Compiled the database doctor

    Data outlives code. In Postgres 12, adding a column with a default does not require a table rewrite, but the initial lock acquisition can still queue behind long-running queries. We will use a sub-second timeout for the DDL lock and verify the transaction log impact first.

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

    What you get

    Audit migrations for locking and downtime risks on high-volume tables.Analyze execution plans to identify missing indexes or inefficient scans.Design scalable schemas that handle 100x current data growth.Draft reversible SQL migration scripts with explicit rollback steps.

    About this skill

    The problem

    Bad schema design and untested migrations lead to production downtime and performance bottlenecks that only appear once your data scales. ORMs often hide expensive database operations, leading to silent failures that manifest as locking issues or slow queries during peak traffic.

    What it does

    • Analyzes schema changes for potential locking behavior and downtime risks across different database engines.
    • Evaluates query performance by interpreting execution plans rather than making generic assumptions.
    • Reviews data models against 100x current volume to identify future scaling bottlenecks.
    • Generates reversible migration scripts paired with verified rollback steps and backup strategies.
    • Flags unsafe practices like non-concurrent index creation or destructive DDL without verification.

    Frameworks & tools

    SQL (PostgreSQL, MySQL, SQL Server), execution planners, migration tools, and relational database management systems.

    Why this beats prompting it yourself

    Generic prompts often suggest "adding an index" without considering lock duration or table size. This skill forces an evidence-first approach, requiring execution plans and version-specific context to prevent dangerous "hallucinated" optimizations that could crash a production instance.

    Use cases

    • Reviewing a complex SQL migration for a multi-terabyte table.
    • Optimizing slow JOINs by analyzing the actual query planner output.
    • Sanitizing and refactoring legacy schemas for better long-term scalability.
    • Designing idempotent migration scripts for CI/CD pipelines.

    Known limitations

    Does not handle database licensing, product cost negotiations, or engine selection debates. Requires manual sanitization of production data before analysis.

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

    • Passed all security checks, Safe to install

    Listed28 days ago
    Updated12 days ago

    Frequently Asked Questions