Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Database Doctor (Persona)

    1

    Reviews schemas, queries, indexes and migrations for developers who want safer database changes. Includes the persona plus 4 skills: index advisor, migration guard, query optimizer, schema reviewer.

    $39

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security 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 persona

    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.

    About this skill

    Reviews schemas, queries, indexes and migrations for developers who want safer database changes.

    What is inside

    The persona plus 4 skills.

    • index advisor
    • migration guard
    • query optimizer
    • schema reviewer

    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.

    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.

    Requires specific database engine and version details for accurate advice. User must provide execution plans for performance claims. Out of scope: licensing and infrastructure costs.

    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 3 months ago

    Permissions

    No special permissions declared or detected

    Listed3 months ago
    Updated5 days ago

    What's inside

    Frequently Asked Questions

    The Database Doctor Persona analyzes your specific execution plans and schema changes to flag potential locking issues, downtime risks, and scaling bottlenecks before they reach production.

    This skill is optimized for major relational database systems including PostgreSQL, MySQL, and SQL Server, focusing on version-specific behaviors for DDL and DML operations.

    Once purchased, you can import the skill into any AI agent framework that supports custom system instructions or persona-based prompting.

    A persona and 4 skills, each a plain SKILL.md file: index advisor, migration guard, query optimizer, schema reviewer. The package has no scripts, templates or separate guides.

    For security reasons, this skill does not connect directly to your database; you should provide anonymized schema DDL or execution plan outputs for the persona to analyze.

    Standard prompts often suggest generic fixes, whereas this skill mandates an 'evidence-first' approach, analyzing actual query planner output to avoid dangerous or locking index suggestions.

    New in Data & Databases