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

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

1. Start with references/get-started/ for installation and basics

2. For database setup: Find relevant connect-*.mdx file

3. For schema design: Check references/column-types/ and references/relations/

4. For queries: Use query-specific files (select, insert, update, delete, joins)

5. For migrations: See references/migrate/

6. For validation: Check references/zod.mdx or other validator files

7. For best practices: Browse references/guides/

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