- Home
- Skills
- Data & Databases
- Database Doctor — Persona
Works with the AI tools you already use
Database Doctor — Persona
Database reliability expert for schema design, migration safety, and execution plan analysis.
$59
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
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.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 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