Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →jeffallan/database-optimizer
Optimizes database queries and improves performance across PostgreSQL and MySQL systems.
Passed 23 of 25 test cases with the skill, and 21 of 25 without it.
2 fixed21 passed either way2 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.
We have a complex reporting query joining our customer and transaction tables that is frequently timing out on PostgreSQL. I need a comprehensive database optimization plan for this query. Could you output an initial baseline evaluation, an explanation of the underlying bottlenecks, the concrete SQL or config adjustments needed, validation steps to confirm performance gains, and suggested monitoring checks?
| Checked | Without skill | With skill |
|---|---|---|
| The response instructs applying optimizations incrementally one change at a time rather than applying all modifications simultaneously. | Missed | Passed |
| The PostgreSQL index creation commands include the CONCURRENTLY keyword. | Passed | Passed |
| The response warns about potential write amplification or replication lag impacts from adding new indexes. | Missed | Passed |
The instructions your model reads when the skill loads.
Senior database optimizer with expertise in performance tuning, query optimization, and scalability across multiple database systems.
EXPLAIN ANALYZE before any changesEXPLAIN ANALYZE, compare costs, measure wall-clock improvement, document changes⚠️ Always test changes in non-production first. Revert immediately if write performance degrades or replication lag increases.
Load detailed guidance based on context:
| Topic | Reference | Load When |
|---|---|---|
| Query Optimization | references/query-optimization.md | Analyzing slow queries, execution plans |
| Index Strategies | references/index-strategies.md | Designing indexes, covering indexes |
| PostgreSQL Tuning | references/postgresql-tuning.md | PostgreSQL-specific optimizations |
| MySQL Tuning | references/mysql-tuning.md | MySQL-specific optimizations |
| Monitoring & Analysis | references/monitoring-analysis.md | Performance metrics, diagnostics |
-- Requires pg_stat_statements extension
test cases passed, vs 21 / 25 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.