optimizing-sql-queries

4.0

104

Execute use when you need to work with query optimization. This skill provides query performance analysis with comprehensive guidance and automation. Trigger with phrases like "optimize queries", "analyze performance", or "improve query speed".

sql-optimization

4.0

Rating

Installs

Backend Development

Quick Review

This skill addresses SQL query optimization, a valuable and complex task (novelty: 4). However, it suffers from major gaps in actionable content. The SKILL.md uses a generic template that lacks SQL-specific guidance—steps like 'Assess Current State' and 'Design Solution' are boilerplate and don't explain how to analyze EXPLAIN plans, identify slow queries, or apply indexing strategies (descriptionCoverage: 3, taskKnowledge: 2). While scripts/ contains promising files (analyze_query.py, recommend_indexes.py, rewrite_query.py), the SKILL.md provides no detail on how to invoke them or what they do, making CLI invocation unclear. The structure is reasonable with separated scripts (structure: 4), but the main documentation is hollow. To improve: replace generic steps with SQL optimization workflows (e.g., 'Run EXPLAIN ANALYZE', 'Identify missing indexes', 'Rewrite subqueries'), document script usage and parameters, and provide concrete examples of query analysis and optimization patterns.