indexes

Quick Review

This skill addresses database index optimization, a valuable and complex task that would be token-intensive for a CLI agent to perform from scratch. The description clearly states the goal (analyze queries, recommend indexes with impact analysis), and the structure is clean with well-organized documentation requirements. However, taskKnowledge is limited—the skill provides documentation templates but lacks concrete analysis methodology, query parsing techniques, index selection algorithms, or scripts to extract/analyze queries from the codebase. A CLI agent would need significant domain expertise to execute this effectively. The novelty score is strong since database performance analysis requires specialized knowledge and cross-referencing multiple files, making it a good candidate for a skill. To improve, add specific steps for query extraction, EXPLAIN plan analysis, index recommendation logic, or reference scripts/tools that perform the actual analysis work.