Drizzle

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.