CtrlK
BlogDocsLog inGet started
Tessl Logo

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.

72

Quality

88%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Failed to scan

The risk profile of this skill

SKILL.md
Quality
Evals
Security

Quality

Content

88%Weight 40%Scale 1-5

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

A well-structured, actionable skill body with copy-paste SQL, clear validation-gated workflow, and one-level-deep references to verified bundle files. It is efficient and practical, with only minor conciseness and organization tweaks available.

DimensionReasoningScore

Conciseness

Largely lean with no padding about what databases or EXPLAIN are; inline code comments ('Requires pg_stat_statements extension', 'Use BUFFERS to expose cache hit vs. disk read ratio') earn their place. Minor trimmable redundancy in the 'When to Use' list and six-item Output Templates.

4 / 5

Actionability

Fully executable, copy-paste-ready SQL for both PostgreSQL and MySQL (top slow queries, EXPLAIN with BUFFERS, covering index, validation queries), plus a concrete EXPLAIN-pattern-to-remedy table covering the common cases.

5 / 5

Workflow Clarity

Five-step Core Workflow with explicit validation checkpoints — baseline EXPLAIN ANALYZE before changes, 'validate each change before proceeding', re-run EXPLAIN and compare costs after — and a revert feedback loop for degraded writes, satisfying the destructive/batch validation requirement.

5 / 5

Progressive Disclosure

A well-signaled Reference Guide table maps five real bundle files to topics and 'Load When' conditions at one level of depth, with common operations kept inline; minor organization gaps as several inline SQL blocks could lean further on the references.

4 / 5

Total

18

/

20

Passed

Description

88%Weight 40%Scale 1-5

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, third-person description that clearly states capabilities and explicit trigger conditions with good keyword coverage. It is well-distinguished and comprehensive, with only minor room for additional synonyms.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — 'Optimizes database queries', 'analyzing execution plans', 'index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution' — giving comprehensive coverage of the skill's capabilities.

5 / 5

Completeness

Explicitly answers both 'what' ('Optimizes database queries and improves performance across PostgreSQL and MySQL systems') and 'when' ('Use when investigating slow queries, analyzing execution plans...'), with concrete trigger phrases.

5 / 5

Trigger Term Quality

Strong natural terms users would say ('slow queries', 'execution plans', 'database performance', 'index design') plus the two system names; a few common synonyms (e.g. 'database tuning', 'query slow') are absent, so it is not fully comprehensive.

4 / 5

Distinctiveness Conflict Risk

Occupies a clear niche (cross-DBMS query/performance optimization) with distinct triggers; minor overlap risk with closely related skills such as a postgres-pro or devops-engineer specialist.

4 / 5

Total

18

/

20

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
jeffallan/claude-skills
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.