sql-optimization-patterns

Quick Review

Exceptional SQL optimization skill with comprehensive coverage of indexing strategies, query patterns, and EXPLAIN analysis. The description clearly communicates when to use this skill (slow queries, schema design, performance optimization). Task knowledge is outstanding with detailed code examples covering execution plans, index types, N+1 queries, pagination, aggregation, subquery optimization, and advanced techniques like materialized views and partitioning. Structure is very clear with logical progression from core concepts to patterns to advanced techniques. The skill demonstrates high novelty as SQL optimization requires specialized expertise that would consume many tokens for a CLI agent to reproduce, especially the nuanced understanding of EXPLAIN plans, index strategies, and database-specific optimizations. Minor room for improvement: could benefit from a quick-reference decision tree at the top for rapid pattern selection.