optimizing-sql-queries

Quick Review

This skill addresses SQL query optimization, a valuable and complex domain where automated assistance provides clear value. However, the SKILL.md suffers from being overly generic—it reads like a template applicable to any backend task rather than SQL-specific optimization. The description mentions 'query performance analysis' and references specific scripts (analyze_query.py, explain_query.sh, recommend_indexes.py, rewrite_query.py), but the main documentation provides no SQL-specific guidance, optimization techniques, indexing strategies, or query analysis methodology. The 5-step process (Assess, Design, Implement, Validate, Deploy) is sensible but completely generic. A CLI agent would struggle to understand when to use which script, what constitutes 'good' query performance, or how to interpret EXPLAIN output. The structure is reasonably clear with logical sections, and novelty is moderate since query optimization does require specialized knowledge. To improve: add SQL-specific optimization patterns, concrete examples of query rewrites, indexing decision trees, performance threshold guidelines, and clearer integration points for the referenced scripts.