Drizzle ORM Documentation

Complete Drizzle ORM documentation embedded in markdown. Read from references/ to answer questions about schema design, querying, migrations, and database integrations.

Documentation Structure

All documentation is in references/ organized by topic:

Getting Started (`references/get-started/`)

Installation and setup
Schema definition basics
Database connections
First queries

Database Connections (`references/connect-*.mdx`)

Connect to various databases and platforms: - PostgreSQL: connect-neon.mdx, connect-supabase.mdx, connect-effect-postgres.mdx, connect-pglite.mdx - MySQL: connect-planetscale.mdx, connect-tidb.mdx - SQLite: connect-cloudflare-d1.mdx, connect-turso.mdx, connect-bun-sqlite.mdx, connect-expo-sqlite.mdx, connect-op-sqlite.mdx - Serverless: connect-drizzle-proxy.mdx, connect-cloudflare-do.mdx - Edge: connect-nile.mdx, connect-sqlite-cloud.mdx

Column Types (`references/column-types/`)

All database column types and modifiers: - PostgreSQL, MySQL, SQLite types - Custom types and validators - Type safety and inference

Queries & Operations

Core query builder features: - select.mdx - Select queries - insert.mdx - Insert operations - update.mdx - Update operations - delete.mdx - Delete operations - joins.mdx - Join queries - indexes.mdx - Index management - views.mdx - Database views - batch-api.mdx - Batch operations - transactions.mdx - Transaction handling

Relations & Schema (`references/relations/`)

One-to-one, one-to-many, many-to-many
Foreign keys and constraints
Cascading operations

Migrations (`references/migrate/`)

Schema migration tools: - drizzle-kit usage - Migration generation - Push vs generate modes - Migration deployment

Integrations & Extensions (`references/extensions/`)

Validation (Zod, Valibot, Arktype, Effect)
Type safety enhancements
Caching strategies

Guides (`references/guides/`)

Best practices and how-tos: - Performance optimization - Type-safe queries - Testing strategies - Production patterns

Tutorials (`references/tutorials/`)

Step-by-step walkthroughs for common use cases.

Latest Releases (`references/latest-releases/`)

Version-specific features and updates.

Quick Reference

Common Tasks

Task	File to Read
Setup Drizzle	`references/get-started/`
Connect to Neon	`references/connect-neon.mdx`
Connect to Supabase	`references/connect-supabase.mdx`
Connect to PlanetScale	`references/connect-planetscale.mdx`
Connect to Cloudflare D1	`references/connect-cloudflare-d1.mdx`
Connect to Turso	`references/connect-turso.mdx`
Define schema	`references/get-started/` + `references/column-types/`
Run queries	`references/select.mdx`, `references/insert.mdx`, etc.
Setup relations	`references/relations/`
Run migrations	`references/migrate/`
Validate with Zod	`references/zod.mdx`
Batch operations	`references/batch-api.mdx`
Transactions	`references/transactions.mdx`

When to Use This Skill

Setting up Drizzle ORM in a TypeScript project
Defining database schemas with type safety
Connecting to PostgreSQL, MySQL, or SQLite databases
Working with serverless/edge databases (Neon, Supabase, D1, Turso)
Writing type-safe queries
Managing database migrations
Adding validation with Zod/Valibot
Questions about Drizzle ORM patterns and best practices

How to Navigate

Start with references/get-started/ for installation and basics
For database setup: Find relevant connect-*.mdx file
For schema design: Check references/column-types/ and references/relations/
For queries: Use query-specific files (select, insert, update, delete, joins)
For migrations: See references/migrate/
For validation: Check references/zod.mdx or other validator files
For best practices: Browse references/guides/

All files are .mdx (Markdown + JSX) but readable as plain markdown.

lb-drizzle-skill

Installation

Drizzle ORM Documentation

Documentation Structure

Getting Started (references/get-started/)

Database Connections (references/connect-*.mdx)

Column Types (references/column-types/)