- Home
- Skills
- Data & Databases
- sql-db-fix-expert
Sql db Fix Expert
A safe, expert-level database troubleshooter for fixing migrations, performance issues, and schema drift.
$8
Works with the AI Agents you already use
sql-db-fix-expert
Example session with this skill installed
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?
- Read your context and instructions
- Compiled the sql-db-fix-expert
ISSUE: Failed Migration (PostgreSQL)
CAUSE: Unique constraint violation on 'email' column due to duplicate records.
FIX
- Identify duplicates: SELECT email, count() FROM users GROUP BY 1 HAVING count() > 1;
- Deduplicate manual script provided.
- Rerun migration.
ROLLBACK: DROP INDEX CONCURRENTLY...
Connects securely to your tools. The creator never sees your data.
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.
- Cannot perform physical hardware/disk repairs.
- Limited to SQLite, PostgreSQL, and MongoDB.
- Requires user-provided credentials/connection for live execution.
How to use
- 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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
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 5 months ago
Permissions
No special permissions declared or detected