database-optimizer

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.

Quality

58%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./skills/database-optimizer/SKILL.md

Quality

Content

23%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 content is a capability inventory rather than an actionable skill: no executable guidance, no real validation workflow for destructive database ops, and a monolithic inline structure with no supporting bundle files. The description sets expectations the body fails to deliver.

Suggestions

Replace the capability bullet catalog with concrete, copy-paste-ready guidance: example EXPLAIN ANALYZE workflows, index-design heuristics with SQL, and caching/Redis patterns that Claude can execute.

Add explicit validation checkpoints for destructive/batch operations (e.g., 'Run migration on a replica first; verify row counts; rollback procedure X') so the Response Approach becomes a real feedback-loop workflow rather than an abstract list.

Move the long capability and knowledge-base inventories into separate reference files under references/ and keep SKILL.md as a concise overview that links to them, instead of inlining ~155 lines.

Dimension	Reasoning	Score
Conciseness	The ~155-line body is a padded catalog of capability bullets and a 'Knowledge Base' that restates concepts Claude already knows (e.g., 'Database internals and query execution engines'); no executable payload earns its tokens.	2 / 5
Actionability	Contains zero code, commands, or concrete procedures; the Instructions are generic ('Apply relevant best practices and validate outcomes') and the Example Interactions are quoted prompts, so it only describes rather than instructs.	1 / 5
Workflow Clarity	A 9-step 'Response Approach' sequence exists, but it is an abstract process outline with no concrete commands and only implicit validation; for a skill involving destructive/batch database operations (migrations, sharding) the missing explicit validation checkpoints cap this at 3.	3 / 5
Progressive Disclosure	No bundle files exist (references/, scripts/, assets/ absent) and the entire capability catalog is inlined as a monolithic bullet list with no external references or signaled navigation, so content that clearly belongs in separate files is inlined.	2 / 5
	Total	8 / 20 Passed

Description

92%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 is strong: it specifies many concrete actions, answers both what and when with explicit trigger phrases, and occupies a clear niche. The only gap is slightly incomplete trigger-term synonym coverage.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions such as 'advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization', giving comprehensive coverage of specific capabilities rather than vague abstractions.	5 / 5
Completeness	Clearly states 'what' (tuning, query optimization, caching, partitioning, migrations, monitoring) and explicitly states 'when' via 'Use PROACTIVELY for database optimization, performance issues, or scalability challenges', answering both with concrete triggers.	5 / 5
Trigger Term Quality	Includes natural user-facing terms like 'database optimization, performance issues, or scalability challenges', but misses common synonyms (e.g., 'slow queries', 'query tuning', 'indexing') and has no concrete file/extension triggers.	4 / 5
Distinctiveness Conflict Risk	Occupies a clear database-performance niche with distinct triggers ('N+1 resolution', 'multi-tier caching', 'partitioning strategies') unlikely to collide with other skills.	5 / 5
	Total	19 / 20 Passed

Validation

93%

Warnings & errors only

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

Criteria	Description	Result
metadata_version	'metadata.version' is missing	Warning

	Total	15 / 16 Passed

Repository: rmyndharis/antigravity-skills
Path: skills/database-optimizer/SKILL.md
Commit: 3eff4af

Reviewed: 1 day ago

Table of Contents

Discovery Implementation Validation

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.