name: olore-drizzle-latest description: Local Drizzle ORM documentation reference (latest). Drizzle ORM documentation. Use for Drizzle queries, schema definitions, migrations, column types, PostgreSQL/MySQL/SQLite dialects, and Drizzle Kit.
Drizzle ORM Documentation
Drizzle ORM documentation. Use for Drizzle queries, schema definitions, migrations, column types, PostgreSQL/MySQL/SQLite dialects, and Drizzle Kit.
Quick Reference
| Task | Entry Point |
|---|---|
| Overview | contents/overview.mdx |
| Quick start | contents/quick.mdx |
| Schema declaration | contents/sql-schema-declaration.mdx |
| SELECT queries | contents/select.mdx |
| INSERT / UPDATE / DELETE | contents/insert.mdx, contents/update.mdx, contents/delete.mdx |
| Relational queries | contents/rqb.mdx |
| Migrations (Kit) | contents/kit-overview.mdx |
| Drizzle config | contents/drizzle-config-file.mdx |
| Column types (PG) | contents/column-types/pg.mdx |
| Get started by DB | contents/get-started/ |
When to use
Use this skill when the user asks about:
- Drizzle ORM schema definitions, column types, relations, views, indexes
- SELECT, INSERT, UPDATE, DELETE, JOIN, and set operation queries
- Relational Query Builder (RQB /
db.query) - Drizzle Kit commands (generate, migrate, push, pull, check, studio)
- Connecting to PostgreSQL, MySQL, SQLite, Neon, Supabase, Turso, PlanetScale, Cloudflare D1, and other providers
- Migrations, seeding, and schema introspection
- Zod, Valibot, TypeBox, ArkType, or Effect Schema integrations with Drizzle
- Performance, transactions, read replicas, RLS, caching, batch API
How to find information
- First, read
TOC.mdfor the complete file listing organized by directory - Identify the relevant section based on the user's question
- Read specific files for details
TOC.md contains all 208 files organized by directory - always check it first.