- 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.
How to use
Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.
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
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scanned
Verified clean 4 months ago
- Passed all security checks, Safe to install