Content
18%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 placeholder with no actionable content. It describes what SQL optimization is about but provides zero concrete guidance — no SQL examples, no EXPLAIN plan analysis steps, no indexing patterns, no optimization workflows. The entire substance is deferred to a resource file that doesn't exist in the bundle, leaving the skill non-functional.
Suggestions
Add concrete SQL examples showing common optimization patterns (e.g., replacing subqueries with JOINs, adding covering indexes, fixing N+1 queries) with before/after EXPLAIN output.
Define a clear workflow: 1) Run EXPLAIN ANALYZE on the slow query, 2) Identify bottlenecks (sequential scans, missing indexes), 3) Apply optimization, 4) Re-run EXPLAIN to validate improvement — with specific commands at each step.
Replace the generic instruction bullets ('Apply relevant best practices') with SQL-specific actionable guidance that Claude can directly execute.
Either include the referenced `resources/implementation-playbook.md` in the bundle or inline the essential patterns directly in the SKILL.md.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The 'Use this skill when' and 'Do not use this skill when' sections are padded with obvious items that don't add value. The instructions section is generic boilerplate ('Clarify goals, constraints, and required inputs') rather than SQL-specific content. However, it's not excessively verbose overall. | 3 / 5 |
Actionability | The skill provides zero concrete code, commands, SQL examples, or executable guidance. Every instruction is vague and abstract ('Apply relevant best practices and validate outcomes'). There are no actual optimization patterns, no EXPLAIN examples, no indexing strategies — everything is deferred to a resource file that doesn't exist in the bundle. | 1 / 5 |
Workflow Clarity | There is no meaningful workflow defined. The four bullet points under Instructions are generic platitudes with no sequencing, no validation checkpoints, and no specific steps for query optimization. For a skill involving database operations, the complete absence of validation steps is a critical gap. | 1 / 5 |
Progressive Disclosure | The skill references `resources/implementation-playbook.md` for detailed patterns, which is a reasonable structure in theory. However, the bundle confirms no such file exists, making the reference a dead link. The SKILL.md itself contains essentially no substantive content, so it's not a useful overview — it's an empty shell pointing to a nonexistent resource. | 2 / 5 |
Total | 7 / 20 Passed |