# Olore Drizzle Latest

> 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.

- Skill: `olorehq/olore-drizzle-latest` (Agent Skill, multi-file: 498 files)
- Install (CLI): `npx get-skill add olorehq/olore-drizzle-latest`
- Raw SKILL.md: https://api.skillmd.com/api/skills/olorehq/olore-drizzle-latest/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: olorehq (https://skillmd.com/u/olorehq)
- Updated: 2026-11-12
- Page: https://skillmd.com/skills/olorehq/olore-drizzle-latest

---


# 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/pg/sql-schema-declaration.mdx` (also mysql/, sqlite/, mssql/, cockroach/, singlestore/) |
| SELECT queries | `contents/pg/select.mdx` |
| INSERT / UPDATE / DELETE | `contents/pg/insert.mdx`, `update.mdx`, `delete.mdx` |
| Relational queries | `contents/pg/rqb.mdx` |
| Migrations (Kit) | `contents/pg/kit-overview.mdx` |
| Drizzle config | `contents/drizzle-config-file.mdx` |
| Column types (PG) | `contents/pg/column-types.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

1. **First**, read `TOC.md` for the complete file listing organized by directory
2. Identify the relevant section based on the user's question
3. Read specific files for details

**TOC.md contains all 208 files organized by directory - always check it first.**

