Drizzle ORM

TypeScript SQL query builder and ORM

FreeDatabases & backendorm.drizzle.team

What it is

A headless TypeScript ORM whose query API deliberately mirrors SQL, so a Drizzle query reads like the statement it compiles to. Supports Postgres, MySQL, SQLite, SingleStore, MSSQL and CockroachDB, with dedicated drivers for Neon, Supabase, Turso, PlanetScale and Cloudflare D1. Drizzle Kit handles migrations.

Why it earns a slot

No code generation step and no separate engine binary, so it runs inside edge runtimes and whatever sandbox an agent is building in. Being close to SQL, models translate a schema idea into working queries with fewer invented helpers.

Know before you commit

Relational query ergonomics are thinner than Prisma's, and drizzle-kit push against production can drop columns without much ceremony. Migration tooling has churned across versions.

Getting started

npm i drizzle-orm && npm i -D drizzle-kit

Field notes

0 from the community

Loading notes…

Field check

Unverified

Pricing snapshot

Free and open source under Apache 2.0. Drizzle Studio and Drizzle Kit are free; Drizzle Gateway is in closed alpha.

Snapshots move fast — verify at checkout, and post a field note if it changed.

Drop into your Lovable chat

Evaluate Drizzle ORM (https://orm.drizzle.team) for this project, then use it only if it fits what we are already building.
Context: TypeScript SQL query builder and ORM. A headless TypeScript ORM whose query API deliberately mirrors SQL, so a Drizzle query reads like the statement it compiles to. Supports Postgres, MySQL, SQLite, SingleStore, MSSQL and CockroachDB, with dedicated drivers for Neon, Supabase, Turso, PlanetScale and Cloudflare D1. Drizzle Kit handles migrations.
Reviewer notes (general, not written for this codebase): No code generation step and no separate engine binary, so it runs inside edge runtimes and whatever sandbox an agent is building in. Being close to SQL, models translate a schema idea into working queries with fewer invented helpers.
Watch out for: Relational query ergonomics are thinner than Prisma's, and drizzle-kit push against production can drop columns without much ceremony. Migration tooling has churned across versions.
Pricing: Free and open source under Apache 2.0. Drizzle Studio and Drizzle Kit are free; Drizzle Gateway is in closed alpha.
Setup: npm i drizzle-orm && npm i -D drizzle-kit
Rules: treat the notes above as background only. Do not assume a theme, style, layout or feature that is not already in this project — inspect the existing code first and ask me before changing visual direction.

/api/public/tools/drizzle-orm

Neighbourhood

How Drizzle ORM sits against the rest of the atlas — swaps, companions and the tools builders actually save alongside it.

Instead of thisPocketBase Appwrite Convex Firebase

Named in the wiringTypeScript Next.js SaaS Starter (Vercel)Cloudflare D1 PlanetScale Supabase Turso

Also in Databases & backend

Appwrite

appwrite.io

Open-source Firebase alternative

Free tier + paidDatabases & backend

Free: 2 projects, 5GB bandwidth, 2GB storage, 750K executions, 75K MAU. Pro from $25/member/mo (2TB bandwidth, 150GB storage, 200K MAU).

Open dossier

Cloudflare D1

developers.cloudflare.com

SQLite on Cloudflare Workers

Free tier + paidDatabases & backend

Workers Free: 5M row reads/day, 100K writes/day, 5GB total, 10 databases at 500MB each. Workers Paid $5/mo: 25B reads and 50M writes monthly, then $0.001/M reads and $1.00/M writes.

Open dossier

Convex

convex.dev

Reactive TypeScript backend platform

Free tier + paidDatabases & backend

Free: 0.5GB DB, 1GB file storage, 1M function calls/mo, 1GB egress. Starter adds usage-based overages. Professional $25/developer/mo. Business from $2,500/mo.

Open dossier

Firebase

firebase.google.com

Google BaaS with NoSQL and auth

Free tier + paidDatabases & backend

Spark free: Firestore 1GiB, 50K reads/20K writes per day, 10GiB egress, 50K Auth MAU. Blaze is pay-as-you-go; Cloud Functions require Blaze.

Open dossier