Open navigation menu

Drizzle ORM

Lightweight, performant TypeScript SQL ORM with zero dependencies, edge-compatible, and SQL-like query builder.

Version: v0.31

Official Documentation ↗

Installation

npmnpm install drizzle-orm pg
pnpmpnpm add drizzle-orm pg

Methods

FAQ

How does Drizzle compare to Prisma?
Drizzle uses SQL-like syntax with no code generation step, resulting in smaller bundles and edge compatibility. Prisma generates a client from a declarative schema, providing better DX but larger bundles. Drizzle is better for edge/serverless; Prisma for traditional servers.
Is Drizzle compatible with Cloudflare Workers?
Yes. Drizzle is edge-compatible with zero dependencies and small bundle size. It works with Cloudflare D1, Neon, Supabase, and PlanetScale via their HTTP drivers. No WebSocket or TCP connection needed.
How do migrations work in Drizzle?
Use drizzle-kit to generate SQL migrations from schema changes: npx drizzle-kit generate. Apply with drizzle-kit migrate or your existing migration tool. Drizzle also supports push for development.