CtrlK
BlogDocsLog inGet started
Tessl Logo

d1-drizzle-schema

Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer.

71

Quality

89%

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

The canonical home for this skill is d1-drizzle-schema in jezweb/claude-skills

SKILL.md
Quality
Evals
Security

Quality

Content

80%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, highly actionable skill body with excellent progressive disclosure and executable examples. The main gap is the absence of validation and error-recovery steps in the migration workflow, which the rubric explicitly caps for database operations.

Suggestions

Add a validation checkpoint to the migration workflow, e.g. 'Verify migrations applied: wrangler d1 migrations list DB --local, then run a smoke-query before applying remote' between Steps 6 and 7.

Include an error-recovery loop for migrations: if `wrangler d1 migrations apply` fails, re-generate with `drizzle-kit generate`, inspect the generated SQL, and re-apply before proceeding.

Add a 'test locally before remote' rule to make the local/remote ordering an enforced checkpoint rather than a single bolded note.

DimensionReasoningScore

Conciseness

The body is efficient — the D1 differences table, inline comments, and code examples all earn their place and assume Claude's competence. It is not a 5 because the intro sentence ("D1 is SQLite-based but has important differences that cause subtle bugs...") partially duplicates the table below it, and 'Drizzle relations are query builder helpers' briefly explains a concept Claude already knows.

4 / 5

Actionability

Fully executable, copy-paste-ready code throughout: the complete schema example with indexes and D1-correct column modes, relations definitions, type exports, package.json migration scripts, and runtime query patterns. The only placeholders (COLUMNS_PER_ROW, UserPreferences) are inherently table-specific and justified flexibility.

5 / 5

Workflow Clarity

The 7-step sequence is clearly ordered and well-defined, but this is a database/migration workflow (remote migrations are destructive batch operations) with no validation or verification checkpoint — no step verifies migrations applied successfully, tests locally before applying remote, or handles errors and retries. The rubric caps database/batch workflows without feedback loops at 3, so it cannot score 4 despite the clear sequencing.

3 / 5

Progressive Disclosure

Clear overview with well-signaled one-level-deep references: the 'Reference Files' table gives a when-to-read signal for each of the two reference files, the 'Assets' table lists both asset templates, and all referenced paths exist with no nested references (verified). Body content is appropriately split — quick patterns inline, full detail in references.

5 / 5

Total

17

/

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.

A strong description: concrete actions, explicit 'Use when' triggers, third-person voice, and a clearly distinct Drizzle+D1 niche. Keyword coverage is good but could add natural synonyms like 'wrangler', 'Cloudflare Workers', or 'D1 migrations'.

DimensionReasoningScore

Specificity

"Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation" plus schema generation lists multiple specific concrete actions with comprehensive coverage of the skill's outputs. It is not a 4 because coverage extends beyond 'several specific actions' to the full output surface including quirks handling.

5 / 5

Completeness

Explicitly answers what ("Generate Drizzle ORM schemas ... Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation") and when ("Use when creating a new database, adding tables, or scaffolding a D1 data layer") with concrete trigger phrases. Both clauses are present and specific, matching the top anchor exactly.

5 / 5

Trigger Term Quality

Good natural keywords: "creating a new database", "adding tables", "scaffolding a D1 data layer", "Drizzle ORM", "Cloudflare D1", "migration commands". It is not a 5 because common user synonyms such as "Cloudflare Workers", "wrangler", "SQLite", or "D1 migrations" are missing.

4 / 5

Distinctiveness Conflict Risk

The "Drizzle ORM" + "Cloudflare D1" pairing carves a clear niche with distinct triggers; no other generic database or ORM skill would be selected for this phrasing. Minor overlap with generic Drizzle/SQLite skills exists but does not rise to the level of the 4 anchor.

5 / 5

Total

19

/

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
jezweb/claude-skills
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.