D1 Drizzle Schema

Generate Drizzle ORM schemas for Cloudflare D1 databases with correct D1-specific patterns.

firstsun-dev 1974629 6 files · 14.5 KB Updated

File contents

D1 Drizzle Schema

Generate correct Drizzle ORM schemas for Cloudflare D1 while avoiding D1-specific bugs.

Core Reference

Choose the appropriate reference based on your progress:

  • Schema Workflow: Scaffolding and bulk insert patterns.
    • Read references/WORKFLOW.md.
  • Column Patterns: Complete type reference for D1-compatible columns.
    • Read references/COLUMNS.md.
  • D1 Specifics: TROUBLESHOOTING limits and SQLite differences.
    • Read references/d1-specifics.md.

Critical D1 Differences

  • Bound Params: Limit is 100 (affects batch size).
  • JSON: Stored as TEXT, handled via { mode: 'json' }.
  • FK Enforced: Foreign keys are always ON.

firstsun-dev/skills/tree/main/custom/develop/d1-drizzle-schema commit 197462901f

Frequently asked questions

npx skillmds@latest add firstsun-dev/d1-drizzle-schema