CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

database-schema

Schema awareness - read before coding, type generation, prevent column errors

50

Quality

63%

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

Quality

Content

56%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 highly actionable with well-sequenced, validated workflows for schema reading and migrations, but it is bloated: repeated checklists, decorative ASCII diagrams, and full per-stack boilerplate that belongs in reference files. Restructuring into a lean core with per-stack references would substantially improve token efficiency and organization.

Suggestions

Move the per-stack type-generation code (Drizzle, Prisma, Supabase, SQLAlchemy) into separate reference files (e.g. references/drizzle.md, references/prisma.md) and keep only a stack-location table plus one-line pointers in SKILL.md.

Cut the decorative ASCII box diagrams (use plain numbered lists) and consolidate the three overlapping checklists (Pre-Code, session state, final Checklist) into one.

Trim boilerplate schema/model definitions Claude already knows — keep only project-specific conventions like the schema-reference.md template and the verification checklist format.

DimensionReasoningScore

Conciseness

The 380-line body includes decorative ASCII box diagrams, full boilerplate schema definitions for Drizzle/Prisma/SQLAlchemy that Claude already knows, and a verification checklist repeated three times (Pre-Code Checklist, Session Start state, final Checklist). This is noticeably verbose with several padded sections — anchor 2 — though not anchor 1 since there is no conceptual tutoring prose.

2 / 5

Actionability

Concrete executable commands ('npx prisma generate', 'supabase gen types typescript --local > src/types/database.ts', 'npx drizzle-kit generate') and real type-safe query examples cover common cases, with minor gaps: the SQLAlchemy example uses 'relationship' without importing it, and the TypeORM row gets no example at all. Anchor 4 (mostly executable, minor gaps) rather than 5.

4 / 5

Workflow Clarity

The migration workflow is a clear six-step sequence with explicit validation ('Run type check - find all broken code', 'Fix type errors, update tests, run full validation'), and the Schema Verification Checklist acts as a pre-code checkpoint — satisfying the database-operations feedback-loop requirement. Minor gaps ('If schema file doesn't exist → CREATE IT' with no how) keep it at anchor 4 rather than 5.

4 / 5

Progressive Disclosure

No bundle files exist and everything is inline in one 380-line file; per-stack type-generation guides and the schema-reference template clearly belong in separate reference files. Section headers are clear and navigation within the file is fine, which lifts it above anchor 2 ('minimal structure') to anchor 3 ('some structure, content that should be separate is inline').

3 / 5

Total

13

/

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 is compact and domain-anchored but reads like a tagline rather than a capability description. It lacks a 'Use when...' trigger clause within the description itself and misses natural synonyms (SQL, ORM, migrations) that would help users invoke it. Expanding it into third-person sentences with explicit trigger phrases would lift most dimensions.

Suggestions

Rewrite the description in third-person full sentences, e.g. 'Reads the database schema and regenerates types before writing queries or models, preventing wrong-column-name and type-mismatch errors.'

Add an explicit trigger clause to the description itself: 'Use when writing database queries, modifying schema/models, running migrations, or working with Drizzle, Prisma, Supabase, or SQLAlchemy.'

Include natural synonyms and file/tech terms users would actually say (SQL, ORM, tables, migrations, .prisma) to improve trigger-term coverage and distinctiveness.

DimensionReasoningScore

Specificity

The description names the domain ('Schema awareness') and 2-3 concrete actions ('read before coding', 'type generation', 'prevent column errors'), but they are telegraphic fragments rather than fully specified actions, and 'prevent column errors' is an outcome rather than a capability. This matches anchor 3 (domain plus 1-2 concrete actions, not comprehensive); anchor 4 requires several specific, well-articulated actions.

3 / 5

Completeness

The 'what' is only weakly stated ('Schema awareness' is a concept, not an action description), and the description field itself contains no 'Use when...' clause — trigger guidance exists only in the separate frontmatter 'when-to-use' field, so per the judging guideline completeness is capped at 3. Not score 2 because the what, while terse, is still discernible.

3 / 5

Trigger Term Quality

Terms like 'schema', 'type generation', and 'column errors' are relevant to the domain, but common natural phrases users would say — 'SQL', 'ORM', 'migrations', 'tables', 'Postgres' — are absent. This matches anchor 3 (some relevant keywords, missing common variations and synonyms) rather than anchor 4's good coverage.

3 / 5

Distinctiveness Conflict Risk

The database-schema niche ('type generation', 'prevent column errors', database queries) is mostly distinct with clear triggers, though it could minorly overlap with migration or general TDD/coding skills. Matches anchor 4 (mostly distinct, minor overlap risk) rather than anchor 5, whose triggers are more comprehensively differentiated.

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

alinaqi/maggy

Path

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