What problem does it solve? Cloudflare D1 is SQLite-based but differs from standard SQLite in ways that cause subtle bugs: foreign keys are always enforced, there are no native BOOLEAN or DATETIME types, bound parameters are capped at 100, and JSON is stored as TEXT. This Skill generates Drizzle ORM schemas that correctly handle all of these D1 quirks instead of producing schemas that fail silently at runtime. ## Core Features & Use Cases - D1-Correct Schema Generation: Produces schema files using proper patterns such as integer with boolean mode, integer timestamps, typed JSON text columns, UUID primary keys, and enforced foreign keys. - Migration and Config Scaffolding: Provides a drizzle.config.ts template, package.json migration scripts for local and remote wrangler d1 commands, and batch insert logic that respects the 100 bound parameter limit. - Documentation Output: Generates a DATABASE_SCHEMA.md documenting tables, relationships, indexes, and the migration workflow for future sessions. - Use Case: When scaffolding a new Cloudflare Workers project with a D1 database, use this Skill to generate the full data layer including schema.ts, relations, type exports, drizzle config, and migration commands in one pass. ## Quick Start Ask the agent to create a Drizzle schema for a new Cloudflare D1 database with users and posts tables, including relations, type exports, and migration scripts.
