Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer.
Quickly install d1-drizzle-schema AI skill to your development environment via command line
Source: jezweb/claude-skills.
Generate correct Drizzle ORM schemas for Cloudflare D1. D1 is SQLite-based but has important differences that cause subtle bugs if you use standard SQLite patterns. This skill produces schemas that work correctly with D1's constraints.
| Foreign keys | OFF by default | Always ON (cannot disable) | | Boolean type | No | No — use integer({ mode: 'boolean' }) | | Datetime type | No | No — use integer({ mode: 'timestamp' }) | | Max bound params | 999 | 100 (affects bulk inserts) | | JSON support | Extension | Always available (jsonextract, ->, ->>) |
| Concurrency | Multi-writer | Single-threaded (one query at a time) |
Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer. Source: jezweb/claude-skills.
Stable fields and commands for AI/search citations.
npx skills add https://github.com/jezweb/claude-skills --skill d1-drizzle-schemaGenerate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns. Produces schema files, migration commands, type exports, and DATABASE_SCHEMA.md documentation. Handles D1 quirks: foreign keys always enforced, no native BOOLEAN/DATETIME types, 100 bound parameter limit, JSON stored as TEXT. Use when creating a new database, adding tables, or scaffolding a D1 data layer. Source: jezweb/claude-skills.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/jezweb/claude-skills --skill d1-drizzle-schema Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/jezweb/claude-skills