Content
21%Scale 1-5Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This skill is essentially a high-level table of contents that delegates all actual work to other skills without providing any concrete, executable guidance itself. It suffers from severe verbosity through repetitive phase structures while simultaneously lacking any actionable content—no SQL examples, no configuration values, no specific commands. The skill would be far more useful if it were condensed to a fraction of its size and included actual PostgreSQL commands and examples.
Suggestions
Add concrete, executable examples: include actual SQL for EXPLAIN ANALYZE, specific pg_stat_statements queries for finding slow queries, and example CREATE INDEX statements with realistic scenarios.
Add specific PostgreSQL configuration values or ranges (e.g., 'shared_buffers: typically 25% of RAM, e.g., `shared_buffers = 4GB` for a 16GB server') instead of just listing parameter names.
Include validation steps: after creating indexes, show how to verify they're being used (`SELECT * FROM pg_stat_user_indexes WHERE idx_scan = 0`); after config changes, show how to verify they took effect.
Consolidate the 7 nearly identical phase structures into a more concise format—the repetitive 'Skills to Invoke / Actions / Copy-Paste Prompts' template wastes significant tokens without adding value.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The skill is heavily padded with repetitive structure across 7 phases that all follow the same template. It explains obvious concepts ('Check database version', 'Review configuration') that Claude already knows, and the 'Copy-Paste Prompts' sections just say 'Use @skill-name to do X' which adds no real value. The checklist and quality gates sections are nearly identical and redundant. | 2 / 5 |
Actionability | The content is entirely vague and abstract. There are no concrete SQL commands, no actual EXPLAIN ANALYZE examples, no specific configuration values, no executable code. Every 'action' is a high-level description like 'Tune shared_buffers' or 'Identify missing indexes' without any specifics on how to do it. The 'Copy-Paste Prompts' just delegate to other skills rather than providing actual guidance. | 1 / 5 |
Workflow Clarity | While there is a rough 7-phase sequence, the steps within each phase are poorly defined bullet lists with no specifics. There are no validation checkpoints, no feedback loops for error recovery, and no guidance on what to do if optimization doesn't improve performance. For database operations (which can be destructive), the complete absence of validation steps and safety measures is a significant gap. | 2 / 5 |
Progressive Disclosure | The skill references many external skills (@database-optimizer, @sql-optimization-patterns, etc.) and related workflow bundles, which suggests some progressive disclosure intent. However, no bundle files are provided, the references are not clearly signaled with links, and the main file itself is bloated with repetitive structure that could be condensed significantly. | 3 / 5 |
Total | 8 / 20 Passed |