d1-drizzle-schema

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) |

使用正確的 D1 特定模式為 Cloudflare D1 資料庫產生 Drizzle ORM 架構。產生架構檔案、遷移命令、類型匯出和 DATABASE_SCHEMA.md 文件。處理 D1 怪癖：始終強制執行外鍵、沒有本機 BOOLEAN/DATETIME 類型、100 個綁定參數限制、JSON 儲存為 TEXT。在建立新資料庫、新增表格或建置 D1 資料層時使用。 來源：jezweb/claude-skills。