Works with the AI tools you already use
database doctor persona
by GarphenGate
Database reliability expert for schema design, migration safety, and execution plan analysis.
Secure checkout via Stripe
See it in action
You say
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?
Your agent does
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.
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
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 today
- 30-day refund guarantee
- One-time purchase, yours forever
- Secure checkout via Stripe
Frequently Asked Questions
Popular in Data Engineering
migration-safety-pro
Production-safe database migrations with zero-downtime strategies, batch backfilling, and multi-ORM support.
Repair Search Index Drift
Repair search indexes that contain missing, stale, duplicated, or deleted records and add safe reconciliation and rebuild controls.
Database Schema & Query Review Gate
Review a database schema, queries, or migration for the mistakes that get expensive in production — bad table design, missing or wrong indexes, slow and N+1 queries, SQL injection, and migrations that lock or break prod. Engine-aware (PostgreSQL, MySQL, SQLite, SQL Server), it runs an ordered review and returns a PASS/REVIEW/BLOCK verdict with prioritized fixes. Schema mistakes are the most expensive kind — this catches them before they ship.
Data Analysis Decision Engine
Data analysis engine with 4D decision matrix, 15-min quick analysis template, statistics reference, A/B testing playbook, user behavior analysis, SQL templates.