drizzle-orm-d1

About drizzle-orm-d1

Type-safe ORM for Cloudflare D1 databases using Drizzle. This skill provides comprehensive patterns for schema definition, migrations management, type-safe queries, relations, and Cloudflare Workers integration. Use when: building D1 database schemas, writing type-safe SQL queries, managing database migrations with Drizzle Kit, defining table relations, implementing prepared statements, using D1 batch API for transactions, or encountering "D1_ERROR", transaction errors, foreign key constraint failures, migration apply errors, or schema inference issues. Prevents 12 documented issues: D1 transaction errors (SQL BEGIN not supported), foreign key constraint failures during migrations, module import errors with Wrangler, D1 binding not found, migration apply failures, schema TypeScript inference errors, prepared statement caching issues, transaction rollback patterns, TypeScript strict mode errors, drizzle.config.ts not found, remote vs local database confusion, and wrangler.toml vs wrangler.jsonc mixing. Keywords: drizzle orm, drizzle d1, type-safe sql, drizzle schema, drizzle migrations, drizzle kit, orm cloudflare, d1 orm, drizzle typescript, drizzle relations, drizzle transactions, drizzle query builder, schema definition, prepared statements, drizzle batch, migration management, relational queries, drizzle joins, D1_ERROR, BEGIN TRANSACTION d1, foreign key constraint, migration failed, schema not found, d1 binding error

基于 Drizzle 的 Cloudflare D1 数据库类型安全 ORM。本技能提供有关模式定义、迁移管理、类型安全查询、关系以及 Cloudflare Workers 集成的全面模式。 适用场景：构建 D1 数据库模式、编写类型安全的 SQL 查询、使用 Drizzle Kit 管理数据库迁移、定义表关系、实现预处理语句、使用 D1 批处理 API 处理事务，或遇到 "D1_ERROR"、事务错误、外键约束失败、迁移应用错误或模式推断问题时使用。 可防止的 12 个已记录问题：D1 事务错误（不支持 SQL BEGIN）、迁移期间外键约束失败、使用 Wrangler 时模块导入错误、未找到 D1 绑定、迁移应用失败、模式 TypeScript 推断错误、预处理语句缓存问题、事务回滚模式、TypeScript 严格模式错误、找不到 drizzle.config.ts、本地与远程数据库混淆，以及 wrangler.toml 与 wrangler.jsonc 混用。 关键词：drizzle orm、drizzle d1、类型安全 SQL、drizzle 模式、drizzle 迁移、drizzle kit、Cloudflare ORM、d1 orm、drizzle typescript、drizzle 关系、drizzle 事务、drizzle 查询构建器、模式定义、预处理语句、drizzle 批处理、迁移管理、关系查询、drizzle 连接（joins）、D1_ERROR、BEGIN TRANSACTION d1、外键约束、migration failed、schema not found、d1 binding error