# D1 Drizzle Schema

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

- Skill: `firstsun-dev/d1-drizzle-schema` (Agent Skill, multi-file: 6 files)
- Install (CLI): `npx skillmds@latest add firstsun-dev/d1-drizzle-schema`
- Raw SKILL.md: https://api.skillmd.com/api/skills/firstsun-dev/d1-drizzle-schema/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: firstsun-dev (https://skillmd.com/u/firstsun-dev)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/firstsun-dev/d1-drizzle-schema

---


# 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](references/WORKFLOW.md).
- **Column Patterns**: Complete type reference for D1-compatible columns.
  - Read [references/COLUMNS.md](references/COLUMNS.md).
- **D1 Specifics**: TROUBLESHOOTING limits and SQLite differences.
  - Read [references/d1-specifics.md](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.