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.

Quality

89%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Passed

No findings from the security scan

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.

Highly actionable with executable code and a clean progressive-disclosure structure backed by real bundle files. The main weakness is workflow clarity: batch and migration steps lack explicit validation/verification checkpoints, capping that dimension.

Suggestions

Add an explicit verification checkpoint after Step 6 (migrations), e.g. confirm 'wrangler d1 migrations list' shows the expected applied state and that local and remote row counts/ schema match before testing.

For the Bulk Insert Pattern, add a validation step after batching (e.g. verify inserted count equals rows.length, or wrap in a transaction and rollback on error) since batch inserts are failure-prone.

Add an explicit 'validate schema generated successfully' check after 'db:generate' (e.g. inspect the generated SQL migration file for the expected DDL) before applying migrations.

Dimension	Reasoning	Score
Conciseness	Mostly lean: a tight comparison table, focused code blocks, and pointers to reference files; minor over-explanation such as restating that 'D1 is SQLite-based but has important differences' and inline comments re-explaining booleans/timestamps Claude already understands.	4 / 5
Actionability	Copy-paste-ready executable TypeScript for schema definition, relations, type exports, bulk-insert batching, and runtime query patterns, plus concrete package.json scripts and a real config template asset — concrete examples cover the common cases.	5 / 5
Workflow Clarity	Steps 1-7 are clearly sequenced, but operations that are inherently batch/destructive (bulk insert, 'apply migrations on BOTH local AND remote', running drizzle-kit generate) lack explicit validation/verification checkpoints, which per the rubric caps workflow_clarity at 3.	3 / 5
Progressive Disclosure	Clear overview body with well-signaled one-level-deep references — two navigation tables ('Reference Files', 'Assets') pointing to real files (references/column-patterns.md, references/d1-specifics.md, assets/drizzle-config-template.ts, assets/schema-template.ts), all confirmed present; content is appropriately split with easy navigation.	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.

The description is specific, complete, and well-targeted, naming both concrete capabilities and explicit 'Use when...' triggers tied to a distinct D1/Drizzle niche. The only minor gap is broader natural-term/synonym coverage in the trigger phrase.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions — 'Generates schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation' — plus specific D1 quirks (FKs enforced, no BOOLEAN/DATETIME, 100 param limit, JSON as TEXT), giving comprehensive coverage rather than minimal or generic actions.	5 / 5
Completeness	Explicitly answers both 'what' (generate schemas + produce schema files, migrations, types, docs, handle D1 quirks) and 'when' ('Use when creating a new database, adding tables, or scaffolding a D1 data layer') with concrete trigger phrases.	5 / 5
Trigger Term Quality	Includes natural trigger phrases users would say — 'creating a new database, adding tables, or scaffolding a D1 data layer' — but lacks file-extension cues and common synonyms (e.g. 'Cloudflare Workers database', 'D1 migrations'); good but not comprehensive.	4 / 5
Distinctiveness Conflict Risk	A narrow niche (Drizzle ORM + Cloudflare D1 specifically) with D1-specific triggers; minimal risk of firing for generic SQL or other ORM skills.	5 / 5
	Total	19 / 20 Passed

Validation

100%

Warnings & errors only

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
Path: plugins/cloudflare/skills/d1-drizzle-schema/SKILL.md
Commit: 176df0f

Reviewed: 6 days ago

Table of Contents

Discovery Implementation Validation

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.