drizzle

Complete Drizzle ORM documentation in markdown format. Use when working with Drizzle ORM - covers schema definition, queries, migrations, database connections (PostgreSQL, MySQL, SQLite), integrations (Neon, Supabase, PlanetScale, Cloudflare D1, Turso), column types, relations, transactions, and framework usage (Next.js, SvelteKit, Astro).

SKILL.md

---
name: drizzle
description: Complete Drizzle ORM documentation in markdown format. Use when working with Drizzle ORM - covers schema definition, queries, migrations, database connections (PostgreSQL, MySQL, SQLite), integrations (Neon, Supabase, PlanetScale, Cloudflare D1, Turso), column types, relations, transactions, and framework usage (Next.js, SvelteKit, Astro).
---

# 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

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.