Sql db Fix Expert

    2

    A safe, expert-level database troubleshooter for fixing migrations, performance issues, and schema drift.

    Secure checkout via Stripe

    0 installsSecurity scanned

    Works with the AI tools you already use

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

    See it in action

    You say

    My Postgres migration just failed on the users table with a unique constraint error on the email field. Can you help me fix the data and finish the migration?

    Your agent does

    ISSUE: Failed Migration (PostgreSQL) CAUSE: Unique constraint violation on 'email' column due to duplicate records. FIX:

    1. Identify duplicates: SELECT email, count() FROM users GROUP BY 1 HAVING count() > 1;
    2. Deduplicate manual script provided.
    3. Rerun migration. ROLLBACK: DROP INDEX CONCURRENTLY...

    What you get

    Repair broken database migrations and resolve schema drift issuesDiagnose and resolve performance bottlenecks and query deadlocksSafely deduplicate data and fix integrity constraint violationsGenerate engine-specific recovery plans for corrupted indices or tables

    About this skill

    What it does

    SQL DB Fix Expert is a specialized database reliability skill designed to diagnose and repair incidents across SQLite, PostgreSQL, and MongoDB. It functions as an on-call DBA for your AI agent, moving beyond simple query generation to provide deep troubleshooting for broken migrations, deadlocks, schema drift, and data corruption.

    Why use this skill

    Most AI agents lack the safety guardrails required for database operations. This skill implements a strict "read-only first" diagnostic protocol and high-risk operation gating. It prevents accidental data loss by enforcing backup verification and providing explicit rollback plans before any modification is executed. It is significantly safer and more thorough than raw prompting because it follows a structured 'Evidence-Inference-Action' workflow.

    Supported Engines

    • PostgreSQL: Vacuuming, lock analysis, complex migrations, and query planning.
    • SQLite: Recovery, file integrity, and light-weight schema adjustments.
    • MongoDB: Document validation, index optimization, and aggregation repairs.

    The Output

    Every interaction produces a structured incident report containing identified root causes, read-only evidence, engine-specific repair scripts, and a concrete rollback strategy. Live execution only occurs after explicit user confirmation of the proposed commands.

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

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

    • One-time purchase, yours forever

    Listed3 months ago

    Frequently Asked Questions