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.

60

Quality

75%

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 ./engineering/skills/database-schema-designer/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

68%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, code-heavy skill body with concrete executable examples and sensible use of a one-level-deep reference file. Its main gaps are the absence of explicit validation/verification steps in the design workflow (capping workflow clarity) and code examples that depend on undefined project scaffolding.

Suggestions

Add explicit validation checkpoints to the Schema Design Process, e.g., 'Step 4: Verify — apply the migration in a transaction, test RLS policies with a non-superuser role, and roll back on failure.'

Make the seed script self-contained or note its prerequisites (schema files, client setup) so the example is actionable without guesswork.

Move the RLS policy details and seed/ERD examples into reference files (e.g., references/rls-policies.md, references/seed-and-erd.md), keeping SKILL.md as a lean overview.

DimensionReasoningScore

Conciseness

The body is efficient: terse headers, bullet lists, and code with almost no re-teaching of concepts Claude already knows. Minor trimmable parts exist — the 60-line seed script and the 'When to Use' section that duplicates the frontmatter description — keeping it just short of the lean-anchor 5.

4 / 5

Actionability

Mostly executable guidance: complete RLS SQL policies, a runnable TypeScript seed script, a Mermaid ERD block, and concrete commands ('npx prisma-erd-generator'). Not a 5 because the seed example imports undefined project files ('./client', '../src/lib/auth', './schema') so it is not standalone copy-paste ready.

4 / 5

Workflow Clarity

The 'Schema Design Process' presents a clear three-step sequence (requirements to entities, relationships, cross-cutting concerns), but the workflow has no validation checkpoints — migration and RLS verification appear only as pitfall bullets ('RLS not tested — always test RLS with a non-superuser role') rather than as explicit steps. Per the rubric's database-operation rule, missing feedback loops in this context caps the score at 3.

3 / 5

Progressive Disclosure

Good structure: the bulk full-schema example is pushed to references/full-schema-examples.md (a real file, one level deep, no nested references, clearly signaled with an arrow pointer), and sections are well organized. Not a 5 because sizable RLS, seed, and ERD examples remain inline in SKILL.md and could be split into reference files for a leaner overview.

4 / 5

Total

15

/

20

Passed

Description

70%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, well-targeted description with concrete trigger phrases and a clear niche, but it omits any explicit statement of what the skill actually does (design schemas, generate migrations/types/RLS policies/seed data). Adding a one-line 'what' clause before the 'Use when' clause would make it complete.

Suggestions

Add an explicit capability sentence before the trigger clause, e.g., 'Designs relational database schemas and generates migrations, TypeScript/Python types, RLS policies, and indexes.'

Include a few common synonyms users naturally say, such as 'model data', 'database design', or 'design tables', to widen trigger coverage.

Mention specific ORM contexts (Prisma, Drizzle) in the description so it triggers when users ask about those tools.

DimensionReasoningScore

Specificity

Lists several specific concrete actions: 'create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.' Not a 5 because coverage of the skill's actual capabilities (RLS policies, type generation, seed data, indexes) is absent from the description; not a 3 because it enumerates four distinct actions rather than 1-2.

4 / 5

Completeness

The description is structured as only a 'when' clause ('Use when the user asks to...') with no explicit statement of what the skill does — its capabilities are only implied by the verbs in the trigger list. It sits between anchor 2 ('only when is present without what') and anchor 3, earning a 3 rather than 2 because the 'when' clause is concrete and enumerates specific tasks rather than being vague.

3 / 5

Trigger Term Quality

Good keyword coverage with natural phrases users would say: 'ERD diagrams', 'normalize database schemas', 'design table relationships', 'plan schema migrations.' Not a 5 because common synonyms and variations are missing (e.g., 'model my data', 'database design', 'table design', ORM-specific terms like 'Prisma schema').

4 / 5

Distinctiveness Conflict Risk

Clear niche with distinct triggers: database schema design with ERD diagrams, normalization, table relationships, and schema migrations. These are specific, well-scoped triggers with minimal overlap risk against other skills.

5 / 5

Total

16

/

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.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

alirezarezvani/claude-skills

Path

engineering/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.