Can I use this skill to generate database migrations?

Yes, the skill provides a standardized workflow using 'drizzle-kit generate' for SQL creation and 'wrangler d1 migrations apply' for deployment.

Does it support TypeScript type inference?

Absolutely. It includes patterns for using 'InferSelectModel' and 'InferInsertModel' to ensure your application code stays in sync with your database schema.

What common D1 errors does this skill help resolve?

It provides specific solutions for 'D1_ERROR: Cannot use BEGIN TRANSACTION', foreign key constraint failures, and environment binding issues.

How does this skill handle transactions in Cloudflare D1?

Since D1 does not support standard SQL BEGIN/COMMIT statements, this skill implements transactions using the Drizzle 'db.batch()' API, which is the recommended approach for D1.

Drizzle ORM for Cloudflare D1

Name: Drizzle ORM for Cloudflare D1
Author: secondsky

bysecondsky

•

Database Management

Streamlines Cloudflare D1 database management using Drizzle ORM with type-safe schemas, automated migrations, and optimized query patterns.

About

This skill equips Claude with the expertise to architect and maintain Cloudflare D1 databases using Drizzle ORM, ensuring production-ready performance and type safety. It provides comprehensive guidance on defining relational schemas, managing migrations via Drizzle Kit, and implementing D1-specific patterns like the batch API for transactions. By incorporating best practices for schema design and a detailed catalog of common D1 error solutions, this skill helps developers avoid common pitfalls such as transaction errors and foreign key failures in the Cloudflare Workers environment.

Key Features

21 GitHub stars
Type-safe schema definition and TypeScript model inference
Automated migration workflows using Drizzle Kit and Wrangler
Pre-built templates for CRUD, relational queries, and prepared statements
Optimized transaction handling via the Cloudflare D1 batch API
Extensive error catalog for debugging D1-specific runtime issues

Use Cases

Managing complex database migrations and schema evolutions on D1
Implementing relational data models with cascading deletes and optimized indexes
Building scalable, type-safe backends on Cloudflare Workers

About

Key Features

21 GitHub stars
Type-safe schema definition and TypeScript model inference
Automated migration workflows using Drizzle Kit and Wrangler
Pre-built templates for CRUD, relational queries, and prepared statements
Optimized transaction handling via the Cloudflare D1 batch API
Extensive error catalog for debugging D1-specific runtime issues

Use Cases

Managing complex database migrations and schema evolutions on D1
Implementing relational data models with cascading deletes and optimized indexes
Building scalable, type-safe backends on Cloudflare Workers