CtrlK
BlogDocsLog inGet started
Tessl Logo

database-optimizer

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.

70

Quality

86%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

72%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-organized, token-efficient body that uses progressive disclosure effectively to push detail into real reference files. It is held back only by a lack of executable examples and explicit validation feedback loops within the SKILL.md itself.

Suggestions

Add one small executable snippet to the body (e.g. a baseline EXPLAIN ANALYZE / pg_stat_statements query) so the SKILL.md itself provides copy-paste-ready starting points rather than deferring all code to references.

Turn the Core Workflow into an explicit feedback loop: add a 'Measure → if no improvement or regressions, revise and re-measure' checkpoint, since database tuning is a context where missing validate-fix-retry loops cap workflow_clarity.

Tighten the 'Knowledge Reference' paragraph — it enumerates many features (VACUUM, sharding, caching) as a keyword dump that Claude already knows; either cut it or move specifics into the relevant reference file.

DimensionReasoningScore

Conciseness

The body is lean — short role definition, a 5-step workflow, a reference table, and terse MUST/MUST NOT lists — assuming Claude's competence without explaining what a database or index is, matching the score-3 'lean and efficient; every token earns its place' anchor rather than the padded score-2 example.

3 / 3

Actionability

The body offers directional guidance ('Analyze EXPLAIN plans before optimizing', 'Create indexes strategically') rather than concrete executable code or commands, matching the score-2 anchor of guidance that is incomplete; the executable SQL lives only in the referenced files, not the SKILL.md itself, so it falls short of the copy-paste-ready score-3.

2 / 3

Workflow Clarity

The 5-step Core Workflow is clearly sequenced (Analyze → Identify → Design → Implement → Validate) but lacks explicit validation checkpoints or a validate-fix-retry feedback loop; since database optimizations are explicitly listed as a context where missing feedback loops cap the score, it stays at the score-2 anchor rather than reaching score-3.

2 / 3

Progressive Disclosure

A concise overview with a well-signaled one-level-deep reference table (five real references/*.md files, all present and non-nested) mapping topic to file and load-when condition, matching the score-3 'clear overview with well-signaled one-level-deep references' anchor; the references contain executable SQL with no further nested .md pointers.

3 / 3

Total

10

/

12

Passed

Description

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.

A strong, specific description that clearly states both the capabilities and the trigger conditions in concise third-person voice. It lists concrete actions and natural trigger terms with no overlap risk.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — 'investigating slow queries, analyzing execution plans', 'index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution' — matching the rubric's score-3 anchor of multiple specific concrete actions; it exceeds the score-2 anchor which only names a domain and some actions.

3 / 3

Completeness

Explicitly answers both what (the listed optimization actions) and when via 'Use when investigating slow queries...' and 'Invoke for...', matching the score-3 anchor with explicit triggers; the 'Use when...' clause is present so the cap-at-2 guideline does not apply.

3 / 3

Trigger Term Quality

Natural terms a developer would actually say — 'slow queries', 'execution plans', 'index design', 'query rewrites', 'configuration tuning', 'partitioning', 'lock contention' — give good coverage of common phrasings, satisfying the score-3 anchor rather than the score-2 'some relevant keywords but missing common variations'.

3 / 3

Distinctiveness Conflict Risk

Has a clear niche (database performance tuning) with distinct triggers like execution plans, partitioning, and lock contention, making it unlikely to fire for the wrong skill; voice is third-person ('Use when', 'Invoke for') with no first/second person, so no specificity penalty applies.

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.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
zebbern/claude-code-guide
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.