CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-designer

Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.

59

Quality

74%

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 ./.gemini/skills/database-designer/SKILL.md

The canonical home for this skill is database-designer in alirezarezvani/claude-skills

SKILL.md
Quality
Evals
Security

Quality

Content

58%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 skill's core tool workflow is excellent — well-sequenced, command-driven, and backed by an explicit verification loop — but it sits inside a bloated body of textbook SQL and database-architecture material Claude already knows. Worse, every script, asset, and reference file the workflow depends on is missing from the bundle, so the workflow cannot actually execute as shipped.

Suggestions

Move the Query Generation Patterns, Performance Optimization, Multi-Database Decision Matrix, and Sharding & Replication sections into a reference file (e.g., references/database-design-reference.md), keeping only a one-line pointer per topic in SKILL.md — this would cut the body by more than half and fix the broken reference.

Ship the scripts and assets the workflow depends on (schema_analyzer.py, index_optimizer.py, migration_generator.py, assets/sample_schema.sql, assets/sample_schema.json, assets/sample_query_patterns.json), or rewrite the workflow around guidance Claude can execute without them.

Delete or drastically condense the generic Best Practices section ("Use meaningful names", "Encrypt sensitive data", "Validate inputs") — these are database-commonsense items Claude already applies without instruction.

DimensionReasoningScore

Conciseness

Over half the body restates textbook knowledge Claude already has — JOIN/CTE/window-function tutorials, GROUPING SETS, generic best practices ("Use meaningful names", "Encrypt sensitive data"), and the PostgreSQL/MySQL/SQLite comparison and sharding/replication matrices. These are several large padded sections rather than a few trimmable sentences.

2 / 5

Actionability

The tool workflow provides concrete, flag-level commands (e.g., `python3 schema_analyzer.py --input schema.sql --generate-erd --output-format json -o analysis.json`) and runnable SQL examples, but the commands reference scripts and sample assets that are not present in the bundle, so they are not fully copy-paste executable as shipped — concrete commands with a gap.

4 / 5

Workflow Clarity

The tool workflow is a clear four-step sequence (analyze → optimize → migrate → verify), each step with a full command, and includes an explicit validation feedback loop: "Re-run step 1 on the *target* schema and assert the issues found in the first pass are gone; run `migration_generator.py --validate-only` before handing over the migration" — exactly the feedback-loop rigor the rubric demands for database operations.

5 / 5

Progressive Disclosure

The body inlines roughly 200 lines of material that belongs in separate reference files (query generation patterns, sharding and replication, database comparison matrices), its only reference pointer — "See references/database-design-reference.md" — targets a file that does not exist, and every referenced script and asset (schema_analyzer.py, assets/sample_query_patterns.json, etc.) is missing from the bundle entirely.

2 / 5

Total

13

/

20

Passed

Description

80%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 description with concrete, action-rich triggers and an explicit 'Use when' clause covering the skill's full scope. Its main weakness is fusing the 'what' into the trigger sentence instead of stating capabilities separately, plus a few missing natural synonyms like normalization and indexing.

DimensionReasoningScore

Specificity

The description lists five concrete actions — "design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships" — giving comprehensive coverage of the skill's scope, matching the anchor-5 pattern of multiple specific concrete actions.

5 / 5

Completeness

The 'when' is fully explicit with concrete trigger scenarios, and the five verbs convey capabilities, but the 'what' is embedded inside the "Use when..." clause rather than stated as a standalone capability sentence — both are present, yet the merged form is slightly less explicit than the anchor-5 pattern.

4 / 5

Trigger Term Quality

Natural phrases like "design database schemas", "plan data migrations", "optimize queries", and "SQL and NoSQL" are present, but common user variations such as "normalization", "indexing", "ERD", or "database performance tuning" are missing — good coverage with a few natural terms absent.

4 / 5

Distinctiveness Conflict Risk

The database-design niche is clear, but "optimize queries" and "plan data migrations" are triggers that could also fire for dedicated query-optimization or migration skills (the body itself cross-references such siblings), giving minor overlap risk with closely related skills.

4 / 5

Total

17

/

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

referenced_paths_exist

Referenced path issues: 5 missing

Warning

Total

15

/

16

Passed

Repository

alirezarezvani/claude-skills

Path

.gemini/skills/database-designer/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.