sql-optimization-patterns

What problem does it solve?

This Skill helps you diagnose and fix slow database queries, significantly improving application speed and reducing resource consumption.

Core Features & Use Cases

• Query Plan Analysis: Understand EXPLAIN output to identify bottlenecks.
• Indexing Strategies: Learn to create effective indexes (B-Tree, GIN, etc.) for faster data retrieval.
• Query Optimization Patterns: Apply techniques like eliminating N+1 queries, optimizing pagination, and efficient aggregation.
• Use Case: When a critical report takes minutes to load, use this Skill to analyze the query plan, add appropriate indexes, and rewrite the query for sub-second performance.

Quick Start

Analyze the query plan for the following SQL statement: SELECT * FROM users WHERE email = 'user@example.com';