analyzing-database-indexes

Quick Review

The skill addresses database index analysis and optimization, which is valuable for performance tuning. However, the SKILL.md is highly generic and templated, lacking specific database indexing knowledge. The description mentions 'index design and optimization' but the content provides only generic software development steps (assess, design, implement, validate, deploy) without indexing-specific guidance like index types, covering indexes, cardinality analysis, query plan interpretation, or index fragmentation handling. The analyze_indexes.py script is referenced but its functionality isn't described. While the structure is clean and database CLI tools are allowed, the skill lacks the domain-specific knowledge needed for a CLI agent to effectively perform index analysis tasks. The novelty score is moderate because index optimization does require specialized knowledge, but the current implementation doesn't capture enough of that knowledge to justify the skill's existence over a general-purpose agent with database access.