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.

Drizzle ORM Complete Documentation

AI Skill Market Insights

Be Part of the 0+ Developer Community

Drizzle ORM Documentation

Documentation Structure

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

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

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

Queries & Operations

Relations & Schema (
`references/relations/`
)

Migrations (
`references/migrate/`
)

Integrations & Extensions (
`references/extensions/`
)

Guides (
`references/guides/`
)

Tutorials (
`references/tutorials/`
)

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

Quick Reference

Common Tasks

When to Use This Skill

How to Navigate

Quick Start

Manual Installation

TEAR & SHARE

Tags

document-release

中文去AI味

Copy Editing

Essence Distiller

文件总结 File Summary & Analysis

Channels

Learn

Compare

Company

Drizzle ORM Complete Documentation

AI Skill Market Insights

Be Part of the 0+ Developer Community

Drizzle ORM Documentation

Documentation Structure

Getting Started (references/get-started/)

Database Connections (references/connect-*.mdx)

Column Types (references/column-types/)

Queries & Operations

Relations & Schema (references/relations/)

Migrations (references/migrate/)

Integrations & Extensions (references/extensions/)

Guides (references/guides/)

Tutorials (references/tutorials/)

Latest Releases (references/latest-releases/)

Quick Reference

Common Tasks

When to Use This Skill

How to Navigate

Quick Start

Manual Installation

TEAR & SHARE

Tags

Channels

Learn

Compare

Company

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

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

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

Relations & Schema (
`references/relations/`
)

Migrations (
`references/migrate/`
)

Integrations & Extensions (
`references/extensions/`
)

Guides (
`references/guides/`
)

Tutorials (
`references/tutorials/`
)

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