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

•

데이터베이스 관리

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

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.

주요 기능

0121 GitHub stars

02Type-safe schema definition and TypeScript model inference

03Automated migration workflows using Drizzle Kit and Wrangler

04Pre-built templates for CRUD, relational queries, and prepared statements

05Optimized transaction handling via the Cloudflare D1 batch API

06Extensive error catalog for debugging D1-specific runtime issues

사용 사례

01Managing complex database migrations and schema evolutions on D1

02Implementing relational data models with cascading deletes and optimized indexes

03Building scalable, type-safe backends on Cloudflare Workers

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add secondsky/claude-skills drizzle-orm-d1

For use in Claude.ai and ChatGPT

Download Skill