SQL Optimization Patterns

소개

This skill empowers Claude to transform slow database queries into high-performance operations by applying systematic optimization techniques. It covers deep analysis of execution plans (EXPLAIN), implementation of sophisticated indexing strategies (B-Tree, GIN, BRIN, and functional indexes), and the elimination of common performance bottlenecks like N+1 queries and inefficient pagination. Whether you are designing a new schema from scratch or debugging a production slowdown, this skill provides the architectural patterns and query refactoring logic needed to reduce database load, improve scalability, and ensure application responsiveness.

주요 기능

• Advanced indexing strategies including composite, partial, covering, and functional indexes
• Query refactoring to eliminate N+1 anti-patterns and inefficient JOIN operations
• High-performance pagination techniques using cursor-based logic instead of OFFSET
• 0 GitHub stars
• In-depth EXPLAIN and EXPLAIN ANALYZE plan interpretation and bottleneck identification
• Implementation of advanced database features like Materialized Views and Table Partitioning

사용 사례

• Debugging and resolving slow-running production SQL queries and database timeouts
• Optimizing large-scale data migrations, batch processing, and aggregation operations
• Designing performant database schemas and indexing strategies for high-traffic applications