How do I handle migrations with this skill?

The skill guides you through using drizzle-kit to generate SQL and wrangler d1 migrations apply to execute them safely on both local and remote databases.

Does this skill help with foreign key constraints?

Yes, it includes specific patterns to prevent migration failures caused by how Drizzle and D1 handle PRAGMA foreign_keys.

What is the benefit of using wrangler.jsonc?

The skill recommends wrangler.jsonc because it supports comments and provides better compatibility with modern Cloudflare Worker configurations.

Can I use this for local development?

Absolutely. It includes configurations for testing migrations locally using the Wrangler D1 local emulator before pushing to production.

Why does D1 fail with traditional Drizzle transactions?

Cloudflare D1 does not support the standard SQL 'BEGIN TRANSACTION' syntax; this skill provides the pattern to use db.batch() instead.

Drizzle ORM for Cloudflare D1

Name: Drizzle ORM for Cloudflare D1
Author: jezweb

byjezweb

•

数据库管理

Streamlines building type-safe SQLite databases on Cloudflare Workers by implementing D1-specific patterns and preventing common migration errors.

This skill provides a production-ready framework for integrating Drizzle ORM with Cloudflare D1 databases. It specifically addresses architectural differences in the Cloudflare environment, such as the requirement for the Batch API instead of traditional SQL transactions. By providing standardized schema patterns, migration workflows, and troubleshooting guides for twelve documented D1 issues, this skill ensures developers can build robust, type-safe relational data layers on the edge without running into common pitfalls like binding failures or foreign key constraint errors.

主要功能

01Automated prevention of 12 documented D1 and Drizzle-Kit errors

02D1 Batch API implementation for transaction-safe operations

03Type-safe schema definition and relation mapping for SQLite

0491 GitHub stars

05Optimized configuration for wrangler.jsonc and drizzle.config.ts

06Standardized migration workflow for local and remote D1 environments

使用场景

01Implementing transactional logic in environments that don't support SQL BEGIN

02Managing complex relational database migrations in a CI/CD pipeline

03Building type-safe serverless backends on Cloudflare Workers

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill