CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-schema-designer

Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

54

Quality

68%

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-schema-designer/SKILL.md

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

SKILL.md
Quality
Evals
Security

Quality

Content

57%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-organized, example-rich body with executable SQL/TypeScript/Mermaid snippets and useful pitfalls and best-practices lists. Its main weaknesses are the dangling reference to references/full-schema-examples.md, the absence of validation checkpoints in a database workflow that the rubric requires, and inline bulk (full seed and RLS code) that inflates token cost without teaching much Claude doesn't know.

Suggestions

Create references/full-schema-examples.md (or remove the pointer) so the 'Full Schema Example' section doesn't dead-end, and move the full seed script and RLS policy set there, leaving only short canonical fragments inline.

Add explicit validation checkpoints to the workflow: run migrations against a throwaway copy first, then 'test RLS with a non-superuser role' as a numbered step, mirroring the validation→fix→retry pattern.

Trim known-by-Claude content: drop the Tier/Category/Domain metadata header and the 'When to Use' section that duplicates the frontmatter description, and merge the overlapping soft-delete/index advice repeated across Step 3, Common Pitfalls, and Best Practices.

DimensionReasoningScore

Conciseness

Mostly efficient with clear sections, but includes content Claude already knows or could derive: a ~60-line faker seed script and a ~40-line standard RLS policy set inlined in full, a Tier/Category/Domain metadata header that serves no runtime purpose, and a 'When to Use' section that duplicates the frontmatter description. Matches 'Mostly efficient but includes some unnecessary explanation or could be tightened'; not 4 because the two large code blocks plus redundant sections are more than minor trimming.

3 / 5

Actionability

Concrete, near-executable guidance throughout: full SQL RLS policies, a complete Drizzle-style seed script, Mermaid ERD syntax, and runnable commands ('npx prisma-erd-generator'). Not 5 because of minor gaps: the RLS examples compare uuid columns to current_setting(...)::text without a uuid cast and omit grants for app_user, and the 'Full Schema Example' section points to a file that does not exist.

4 / 5

Workflow Clarity

The 3-step design process (requirements → entities → relationships → cross-cutting concerns) is clearly sequenced, but there are no validation checkpoints anywhere — no verify-migration-on-a-copy step, no RLS test procedure integrated into the flow. The scoring note explicitly caps database-operation workflows without feedback loops at 3; the 'RLS not tested' pitfall mentions testing but never wires it into the process. Not 2 because the sequence itself is coherent and well-defined.

3 / 5

Progressive Disclosure

Good section structure and one clearly signaled reference ('→ See references/full-schema-examples.md for details'), but that file does not exist — no references/, scripts/, or assets/ directory is present, so the pointer is dead. Additionally, bulky content that belongs in reference files (the full seed script and full RLS policy set) is inlined in SKILL.md. Matches 'Some structure but could be better organized; references present but not clearly signaled; content that should be separate is inline'; not 4 because a broken reference and the inlined bulk exceed 'minor organization gaps'.

3 / 5

Total

13

/

20

Passed

Description

66%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 concise, concrete, third-person trigger description with strong 'when' guidance, but it omits an explicit statement of what the skill does, so the capability side is only implied through the trigger verbs. Keyword coverage is good though missing common synonyms like "entity relationship diagram" or "data model".

Suggestions

Add an explicit 'what' sentence before the trigger clause, e.g. "Designs relational database schemas and generates migrations, TypeScript/Python types, and seed data."

Include natural synonyms users might say: "entity relationship diagrams", "data model", "database design", "Prisma/Drizzle schema".

State the concrete outputs (migrations, types, RLS policies, indexes, seed data) rather than only user-facing tasks like "plan schema migrations".

DimensionReasoningScore

Specificity

Quotes four concrete actions — "create ERD diagrams", "normalize database schemas", "design table relationships", "plan schema migrations" — matching the anchor 'Lists several specific actions; minor gaps in coverage'. Not 5 because coverage has gaps: it never states what the skill produces (migrations code, types, seed data, RLS policies) and 'plan schema migrations' is weaker than generating them.

4 / 5

Completeness

The 'when' is explicit and concrete ("Use when the user asks to create ERD diagrams, normalize database schemas..."), but there is no explicit 'what' statement — the skill's capabilities are only implied through the trigger verbs, and the guideline says to score only what is explicitly stated. Falls between anchor 2 ('only when present without what', but far more specific than its example) and anchor 4 ('has both what and when', but the what is absent).

3 / 5

Trigger Term Quality

Natural phrases users would say: "ERD diagrams", "database schemas", "table relationships", "schema migrations". Not 5 because common synonyms and variations are missing ("entity relationship diagram", "data model", "database design", ".sql", "Postgres"), which the 5 anchor expects; not 3 because coverage clearly goes beyond the 'some relevant keywords' level.

4 / 5

Distinctiveness Conflict Risk

The database-schema-design niche with triggers like "normalize database schemas" and "ERD diagrams" is mostly distinct. Not 5 because "plan schema migrations" overlaps with generic migration/deployment skills and "ERD diagrams" with general diagramming skills — minor overlap risk with closely related skills, exactly the anchor-4 wording.

4 / 5

Total

15

/

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: 1 missing

Warning

Total

15

/

16

Passed

Repository

alirezarezvani/claude-skills

Path

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