SQL Optimization Patterns

1---
2name: sql-optimization-patterns
3description: Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
4---
5 
6# SQL Optimization Patterns
7 
8Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
9 
10## Use this skill when
11 
12- Debugging slow-running queries
13- Designing performant database schemas
14- Optimizing application response times
15- Reducing database load and costs
16- Improving scalability for growing datasets
17- Analyzing EXPLAIN query plans
18- Implementing efficient indexes
19- Resolving N+1 query problems
20 
21## Do not use this skill when
22 
23- The task is unrelated to sql optimization patterns
24- You need a different domain or tool outside this scope
25 
26## Instructions
27 
28- Clarify goals, constraints, and required inputs.
29- Apply relevant best practices and validate outcomes.
30- Provide actionable steps and verification.
31- If detailed examples are required, open `resources/implementation-playbook.md`.
32 
33## Resources
34 
35- `resources/implementation-playbook.md` for detailed patterns and examples.
36