analyzing-query-performance

Quick Review

This skill attempts to provide query performance analysis capabilities but suffers from significant generic templating. The description mentions query optimization triggers appropriately, and the structure shows promise with dedicated Python scripts (explain_plan_parser.py, index_advisor.py, query_rewriter.py) that would provide task-specific automation. However, the SKILL.md itself is heavily templated with generic placeholders like 'query-performance-analyzer' that don't match the actual skill name. The 5-step process (Assess, Design, Implement, Validate, Deploy) is overly generic and could apply to any backend task rather than being specific to query performance analysis. The skill would benefit from concrete examples of SQL EXPLAIN analysis, index recommendations, query rewriting patterns, and database-specific optimization techniques. While the referenced scripts suggest domain expertise exists, the main documentation lacks the specificity needed for effective CLI agent invocation. Novelty is low-moderate since query optimization is common but the automation scripts could reduce token usage if properly documented.