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.

主要功能

Automated prevention of 12 documented D1 and Drizzle-Kit errors
D1 Batch API implementation for transaction-safe operations
Type-safe schema definition and relation mapping for SQLite
91 GitHub stars
Optimized configuration for wrangler.jsonc and drizzle.config.ts
Standardized migration workflow for local and remote D1 environments

使用场景

Implementing transactional logic in environments that don't support SQL BEGIN
Managing complex relational database migrations in a CI/CD pipeline
Building type-safe serverless backends on Cloudflare Workers

关于

主要功能

Automated prevention of 12 documented D1 and Drizzle-Kit errors
D1 Batch API implementation for transaction-safe operations
Type-safe schema definition and relation mapping for SQLite
91 GitHub stars
Optimized configuration for wrangler.jsonc and drizzle.config.ts
Standardized migration workflow for local and remote D1 environments

使用场景

Implementing transactional logic in environments that don't support SQL BEGIN
Managing complex relational database migrations in a CI/CD pipeline
Building type-safe serverless backends on Cloudflare Workers