概要
The SQL Optimization Patterns skill empowers Claude to transform sluggish database queries into high-performance operations by applying industry-standard optimization techniques. It provides comprehensive guidance on interpreting execution plans (EXPLAIN), implementing sophisticated indexing strategies—including composite, partial, and covering indexes—and resolving common bottlenecks like the N+1 query problem. Whether you are debugging slow production queries or designing a schema for a high-traffic application, this skill provides the patterns needed to reduce latency, scale datasets, and minimize database infrastructure costs.
