PostgreSQL

meet drizzle

Get started Sustainability Why Drizzle? Guides Tutorials Latest releases Gotchas

Upgrade to v1.0

How to upgrade? v0 → v1 updates Relational Queries v1 to v2

Fundamentals

Schema Relations Database connection Query Data Migrations

Connect

PlanetScale Postgres Neon Vercel Postgres Prisma Postgres Supabase Xata PGLite Nile Bun SQL Effect Postgres Netlify Database AWS Data API Postgres

Manage schema

Data types Indexes & Constraints Sequences Views Schemas Drizzle Relations Row-Level Security (RLS) Extensions

Migrations

Overview generate migrate push pull export check up studio Custom migrations Migrations for teams Web and mobile drizzle.config.ts

Seeding

Overview Generators Versioning

Access your data

Query Select Insert Update Delete Filters Utils Joins Aliases Magic sql operator SQL comments

Performance

Queries Serverless

Advanced

Set Operations Generated Columns Transactions Batch Cache Dynamic query building Read Replicas Custom types Codecs JIT mappers Goodies

Validations

zod valibot typebox arktype typebox-legacy effect-schema

Extensions

ESLint Plugin drizzle-graphql

Become a Sponsor

Our goodies!

Payload

Xata

Neon

SQLite Cloud

Upstash

Lokalise

Replit

Sentry

Sevalla

Clerk

Warp

Turso

Sponsor

Product by Drizzle Team

One Dollar Stats $1 per mo web analytics

DrizzleORM v0.32.1 release

Fix typings for indexes and allow creating indexes on 3+ columns mixing columns and expressions
Added support for “limit 0” in all dialects - closes #2011
Make inArray and notInArray accept empty list, closes #1295
fix typo in lt typedoc
fix wrong example in README.md