Drizzle ORM

Drizzle ORM is a lightweight, TypeScript-first object-relational mapping library created by Andrii Sherman in 2022, providing a fully type-safe SQL query builder and schema management system for Node.js and edge environments, designed as a modern alternative to Prisma with zero dependencies, minimal overhead, and edge-runtime compatibility, adopted by Vercel, Cloudflare, and thousands of developers building serverless and edge applications. The TypeScript-first design means all SQL queries, table schemas, column types, relations, and result sets are fully type-safe with compile-time checking and editor auto-completion, with the schema definition using a declarative TypeScript DSL that maps one-to-one to SQL table structures, supporting all PostgreSQL and MySQL column types, foreign key constraints, indexes, and composite primary keys. The query builder provides a fluent, chainable API for constructing SQL queries including selects with joins, subqueries, common table expressions, window functions, recursive queries, and raw SQL escape hatches, with the query output type automatically inferred from the select columns and joins, eliminating the need for manual type assertions. The edge compatibility means Drizzle runs on Cloudflare Workers, Vercel Edge, Deno Deploy, and Bun without native dependencies, using lightweight database drivers and connection pooling through HTTP-based protocols. The migration system generates SQL migration files from schema changes, with a declarative approach and studio for visual database management. Designed for TypeScript developers building serverless and edge applications.