AI agent skill · by @olorehq

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.

Archived 2026-10-23 · Source updated 2026-09-18 · License: MIT. Check the original repository for the latest version.

SKILL.md instructions

# 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

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