CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-optimizer

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.

Quality

54%

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

Fix and improve this skill with Tessl

tessl review fix ./plugins/AI-Agents-Safe-Coding-Skills-claude/skills/database-optimizer/SKILL.md

The canonical home for this skill is database-optimizer in administrakt0r/AI-Agents-Safe-Coding-Skills

SKILL.md
Quality
Evals
Security

Quality

Content

35%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.

The body is a persona/capability catalog rather than operational guidance: it enumerates topic areas Claude already knows, provides no executable commands or code, and its only progressive-disclosure pointer references a nonexistent file. It needs concrete, example-driven instructions and its reference material moved into real bundle files.

Suggestions

Add executable examples and commands — e.g. EXPLAIN ANALYZE output interpretation, a pg_stat_statements query to find top offenders, a concrete index-creation example, and a fix-retry validation loop ('re-run EXPLAIN after adding the index; verify the plan uses it').

Move the Capabilities/Behavioral Traits/Knowledge Base catalogs into a reference file and keep SKILL.md as a concise operational overview with clearly signaled, verified links.

Fix the broken reference: 'resources/implementation-playbook.md' does not exist in the bundle — either create the file or correct the path to match the actual bundle structure.

DimensionReasoningScore

Conciseness

Roughly 130 lines of 'Capabilities', 'Behavioral Traits', and 'Knowledge Base' sections enumerate topics Claude already knows (B-tree indexes, write-through caching, read replicas, ORM eager loading) with no added operational knowledge — heavily padded. Not score 1 because it lists rather than prose-explains concepts, but it is noticeably verbose with several padded sections that earn no tokens.

2 / 5

Actionability

No code, commands, or executable steps anywhere: instructions are pure abstraction ('Apply relevant best practices and validate outcomes') and the 'Response Approach' steps ('Analyze current performance using appropriate profiling tools') give no specifics. Concrete tool names (EXPLAIN ANALYZE, pg_stat_statements, pgbench, DataLoader) appear only as knowledge-area bullets, providing minimal concrete hints without any steps to execute — between anchors 1 ('only describes rather than instructs') and 2, leaning low.

2 / 5

Workflow Clarity

The 'Response Approach' section lists a coherent 9-step sequence (analyze → identify bottlenecks → design → implement → monitor → validate) and validation is mentioned ('Validate improvements through comprehensive benchmarking and testing'), but there are no explicit checkpoints, commands, or fix-retry feedback loops for what are database operations — matching 'Steps listed but validation gaps; checkpoints missing or implicit'.

3 / 5

Progressive Disclosure

Section headers are well organized, but the bulk of the file (~130 lines of capability catalog) is inlined in SKILL.md where it belongs in reference files, matching 'content that should be separate is inline'. The single reference — 'open resources/implementation-playbook.md' — points to a file that does not exist in the bundle (no references/, scripts/, assets/, or resources/ directories are present), which blocks a score of 4; the genuine section structure keeps it above anchor 2's header-less monolith.

3 / 5

Total

10

/

20

Passed

Description

53%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.

The description names a clear domain but describes it in abstract, persona-style language without concrete actions, explicit trigger guidance, or platform-specific keywords. It would benefit most from a 'Use when...' clause and natural user vocabulary.

Suggestions

Add an explicit trigger clause, e.g. 'Use when the user mentions slow queries, query optimization, indexes, or database performance for PostgreSQL, MySQL, SQL Server, MongoDB, or cloud databases.'

Replace abstract domains with concrete actions, e.g. 'Analyzes execution plans with EXPLAIN, designs indexing strategies, resolves N+1 queries, and tunes caching and scaling for databases.'

Include natural synonyms and platform names (slow queries, indexes, EXPLAIN, PostgreSQL, MySQL, DynamoDB) to improve trigger-term coverage and distinctiveness.

DimensionReasoningScore

Specificity

Names the domain ('database optimizer') and a few areas ('performance tuning, query optimization, and scalable architectures'), but these read as abstract domains rather than concrete actions — comparable to 'Processes PDF files and extracts content' rather than the action-anchored score-4 example ('Extracts text, fills forms, converts pages'). Terms like 'modern' and 'scalable architectures' are buzzword-flavored and add no specificity.

3 / 5

Completeness

The 'what' is stated (performance tuning, query optimization, scalable architectures) but there is no 'Use when...' clause or equivalent explicit trigger guidance — the 'when' is entirely absent, which caps completeness at 3 per the judging guidelines. Fits anchor 3: clear 'what', 'when' missing.

3 / 5

Trigger Term Quality

Contains some natural terms users would say ('database', 'query optimization', 'performance tuning'), but misses common variations and synonyms: no platform names (PostgreSQL, MySQL, SQL Server), no 'slow queries', 'indexes/indexing', 'SQL', or 'EXPLAIN'. Matches 'Some relevant keywords but missing common variations or synonyms'.

3 / 5

Distinctiveness Conflict Risk

'Database optimizer' is a fairly distinct niche with little conflict risk against unrelated skills; only minor overlap risk with closely related backend/performance skills. Not score 5 because the description itself lacks distinctive trigger phrases that would cleanly separate it from general backend-optimization skills.

4 / 5

Total

13

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

15

/

16

Passed

Repository

administrakt0r/AI-Agents-Safe-Coding-Skills

Path

plugins/AI-Agents-Safe-Coding-Skills-claude/skills/database-optimizer/SKILL.md

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.