Drizzle ORM

Drizzle ORM is a TypeScript-first object-relational mapper that provides type-safe database queries without adding a runtime abstraction layer between the application code and the SQL engine. The library is built on top of SQL, meaning every query written through the Drizzle API maps directly to the equivalent SQL statement that a developer would write by hand, with no hidden query generation or N+1 problem surprises. Schema definitions use a declarative TypeScript syntax where each table is described as a plain object with typed column definitions, and the resulting types flow through to all query operations automatically, giving IDE autocomplete for column names and compile-time detection of type mismatches. Migration generation compares the schema file against the live database state, producing SQL migration files that can be reviewed, version-controlled, and executed through a command-line tool. The query builder supports selects with joins, subqueries, aggregations, CTEs, and raw SQL fallbacks for cases where the builder API does not cover a specific database feature. A relational query API lets developers define relations between tables and fetch nested data structures in a single call, with the join strategy optimized per database dialect. Compatible with PostgreSQL, MySQL, SQLite, and Turso through dedicated adapter packages, with edge-runtime support for Cloudflare Workers and Vercel Edge Functions. The library has over thirty-three thousand GitHub stars and is backed by PlanetScale.