database-optimizer
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.
100
100%
Does it follow best practices?
Impact
Pending
No eval scenarios have been run
Passed
No known issues
Quality
Discovery
100%Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.
This is an excellent skill description that follows best practices. It provides specific concrete actions, includes natural trigger terms that database developers would use, explicitly states both what the skill does and when to use it, and carves out a clear niche that distinguishes it from other skills.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Lists multiple specific concrete actions: 'optimizes database queries', 'improves performance', 'investigating slow queries', 'analyzing execution plans', 'index design', 'query rewrites', 'configuration tuning', 'partitioning strategies', 'lock contention resolution'. Uses third person voice correctly. | 3 / 3 |
Completeness | Clearly answers both what ('Optimizes database queries and improves performance across PostgreSQL and MySQL systems') and when ('Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites...'). Has explicit 'Use when' clause with clear triggers. | 3 / 3 |
Trigger Term Quality | Excellent coverage of natural terms users would say: 'slow queries', 'execution plans', 'database performance', 'PostgreSQL', 'MySQL', 'index design', 'query rewrites', 'configuration tuning', 'partitioning', 'lock contention'. These are terms database developers naturally use. | 3 / 3 |
Distinctiveness Conflict Risk | Clear niche focused specifically on database query optimization for PostgreSQL and MySQL. The specific technical terms (execution plans, index design, partitioning strategies, lock contention) create a distinct profile unlikely to conflict with general coding or other database skills. | 3 / 3 |
Total | 12 / 12 Passed |
Implementation
100%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is an excellent skill file that demonstrates best practices across all dimensions. It provides concrete, executable examples while maintaining brevity, includes clear validation workflows with explicit checkpoints, and uses progressive disclosure effectively through a reference table. The constraints section reinforces safe practices without being verbose.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is lean and efficient, assuming Claude's competence with database concepts. No unnecessary explanations of what databases are or how SQL works—it jumps straight to actionable patterns and executable queries. | 3 / 3 |
Actionability | Provides fully executable SQL queries for PostgreSQL and MySQL, specific EXPLAIN patterns with remedies, and copy-paste ready index creation syntax. The examples are concrete and immediately usable. | 3 / 3 |
Workflow Clarity | Clear 5-step workflow with explicit validation checkpoints ('validate each change before proceeding'), feedback loops for testing in non-production, and specific validation queries. The MUST DO/MUST NOT DO constraints reinforce safe practices. | 3 / 3 |
Progressive Disclosure | Well-structured with a clear overview, reference table pointing to one-level-deep topic files, and inline examples for common operations. The table format for references makes navigation easy and signals when to load each resource. | 3 / 3 |
Total | 12 / 12 Passed |
Validation
100%Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.
Validation — 11 / 11 Passed
Validation for skill structure
No warnings or errors.
- Repository
- jeffallan/claude-skills
- Commit
5b76101
- Reviewed
Table of Contents
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.