Drizzle Orm

Drizzle ORM has become the go-to choice for TypeScript teams that want type-safe SQL without Prisma's heavyweight client and code generation. It is genuinely SQL-like (select().from().where() mirrors SQL syntax), edge-compatible (zero Node.js builtins), and works with every major Postgres variant including serverless ones (Neon, PlanetScale, Turso, Cloudflare D1). Drizzle Kit handles migrations. No code generation required — types are inferred directly from schema definitions. Confidence is docs-derived.

npm install drizzle-orm. Schema: export const users = pgTable("users", {id: serial("id").primaryKey(), name: text("name")}). Query: await db.select().from(users).where(eq(users.id, 1)). Insert: await db.insert(users).values({name: "Alice"}). Update: await db.update(users).set({name: "Bob"}).where(eq(users.id, 1)). Migrations: drizzle-kit generate, drizzle-kit migrate. Supports both pg (Node.js) and neon-serverless (edge) drivers.

No Drizzle API key — open-source library. Database credentials passed at client initialization (postgres connection string or driver-specific config). Open-source MIT license. No hosted service auth required. Edge deployments: credentials via environment variables.

Type system catches schema mismatches at compile time — fewer runtime surprises than untyped ORMs. SQL-like query builder reduces abstraction surprise. Migration failures: drizzle-kit generates migration SQL for review before application. Active GitHub (drizzle-team/drizzle-orm, 20k+ stars). Rapid release cadence; check changelog before major version upgrades.

orm.drizzle.team/docs covers schema definition, CRUD operations, migrations, adapter guides for all major databases, and Drizzle Studio. Getting started: npm install drizzle-orm pg, define schema, first query in under 15 minutes. Open-source MIT. Very active Discord community. Comprehensive documentation quality.