drizzle-orm-d1
drizzle-orm-d1 equips you with a complete type-safe ORM layer for Cloudflare D1 databases, handling schema definition, migration generation via Drizzle Kit, and D1-specific patterns like batch operations instead of traditional transactions. It includes templates for common queries, relations, and prepared statements, plus an error catalog addressing D1-specific issues like binding errors and foreign key constraints.
drizzle-orm-d1 provides type-safe ORM setup for Cloudflare D1 databases with migrations and batch transactions.
AI-generated summary based on this skill's SKILL.md
Install
secondsky/claude-skills/drizzle-orm-d1 · repository language: TypeScript
git clone https://github.com/secondsky/claude-skills
cp -r claude-skills/plugins/drizzle-orm-d1/skills/drizzle-orm-d1 ~/.claude/skills/drizzle-orm-d1Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do you use drizzle with Cloudflare D1?
drizzle-orm-d1 provides a complete type-safe ORM layer for Cloudflare D1 databases. Set up drizzle-orm with the D1 driver, define your schemas using Drizzle's schema API, and generate migrations via Drizzle Kit. drizzle-orm-d1 handles D1-specific patterns like batch operations instead of traditional transactions, includes templates for common queries and relations, and offers prepared statement support for type-safe SQL execution.
What is drizzle kit migrations setup for D1?
drizzle-orm-d1 uses Drizzle Kit to manage D1 database migrations. Define your schema in TypeScript, then run Drizzle Kit's generate command to create migration files. These migrations are applied to your D1 database, enabling version control over schema changes. drizzle-orm-d1 provides guidance on structuring migrations and integrating them into your Cloudflare Workers workflow.
How does drizzle schema definition handle relations?
drizzle-orm-d1 lets you define schemas and relations using Drizzle's declarative API. Create tables with columns, set primary keys, and establish foreign key relationships. drizzle-orm-d1 includes templates for common relation patterns and supports type inference across joined queries, ensuring your TypeScript types automatically reflect your database structure and relationships.
How do you resolve D1 errors and transaction handling?
drizzle-orm-d1 includes an error catalog addressing D1-specific issues like binding errors, foreign key constraint violations, and transaction errors. Since D1 doesn't support traditional transactions, drizzle-orm-d1 guides you through the batch API for executing multiple statements atomically. The error reference helps diagnose common problems and provides solutions for proper error handling.
Can drizzle-orm-d1 build type-safe SQL queries?
Yes. drizzle-orm-d1 enables type-safe SQL queries and prepared statements for D1. Use Drizzle's query builder to construct SELECT, INSERT, UPDATE, and DELETE statements with full TypeScript type checking. Prepared statements prevent SQL injection and improve performance, while the query builder ensures compile-time validation of your database operations.
What does drizzle-orm-d1 include for D1 setup?
drizzle-orm-d1 provides everything needed to set up type-safe ORM for Cloudflare D1 development: schema definition templates, Drizzle Kit migration workflows, query builder examples, prepared statement patterns, batch operation guidance, and a D1-specific error catalog. It equips you with best practices for D1-specific constraints like batch-only execution and foreign key handling.
SKILL.md
rendered from the published skill — quoted content, verbatim
Drizzle ORM for Cloudflare
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 15 files
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/SKILL.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/common-errors.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/error-catalog.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/links-to-official-docs.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/migration-workflow.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/query-builder-api.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/schema-patterns.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/references/wrangler-setup.md
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/scripts/check-versions.sh
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/basic-queries.ts
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/basic-schema.ts
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/client.ts
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/cloudflare-worker-integration.ts
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/drizzle.config.ts
plugins/drizzle-orm-d1/skills/drizzle-orm-d1/templates/migrations/0001_example.sql