drizzle-orm-d1

What problem does it solve?

This Skill streamlines the process of interacting with Cloudflare D1 databases by providing a type-safe interface through Drizzle ORM, preventing common errors and simplifying schema management and data querying.

Core Features & Use Cases

• Type-Safe Schema Definition: Define your D1 database schema in TypeScript using Drizzle ORM.
• Automated Migrations: Generate and apply SQL migrations using Drizzle Kit.
• D1 Batch API: Safely handle transactions and multiple operations using D1's batch API, avoiding SQL BEGIN/COMMIT errors.
• Error Prevention: Proactively prevents 18 common issues, including D1 transaction failures, foreign key problems, and parameter limits.
• Use Case: When building a new Cloudflare Worker that requires a persistent database, use this Skill to define your schema, set up migrations, and perform all CRUD operations safely and efficiently.

Quick Start

Use the drizzle-orm-d1 skill to generate a migration file for the schema defined in src/db/schema.ts.