SQL Performance Surgeon — Database Query Optimization Prompts

Queries That Run in Milliseconds, Not Minutes

What's Inside

• EXPLAIN Plan Interpreter — Paste any EXPLAIN ANALYZE output, get plain-English diagnosis with fix recommendations
• Index Strategy Advisor — Analyzes query patterns and recommends composite, partial, and covering indexes
• N+1 Query Detector — Identifies ORM-generated N+1 problems with eager loading solutions
• Partition Strategy Planner — Recommends range/list/hash partitioning based on table size and query patterns
• Query Rewrite Optimizer — Transforms slow queries using CTEs, window functions, and lateral joins
• + 5 more: connection pool tuner, vacuum/analyze scheduler, deadlock resolver, materialized view designer, read replica query router