Drizzle ORM
Lightweight TypeScript ORM that feels like writing SQL
About Drizzle ORM
Drizzle ORM is a TypeScript ORM that delivers the developer experience of Prisma with the performance and flexibility of raw SQL. Its philosophy is "if you know SQL, you know Drizzle" because the query API maps directly to SQL concepts, making it predictable and powerful. Unlike Prisma which uses its own query engine, Drizzle generates SQL queries at build time with zero runtime overhead. You define your schema in TypeScript files using a declarative API, and Drizzle gives you fully typed queries, inserts, updates, and deletes with autocomplete for column names, operators, and joins. It supports PostgreSQL, MySQL, SQLite, and their serverless variants (Neon, PlanetScale, Turso, D1). Drizzle Kit provides migrations management with automatic SQL migration generation from schema changes, push for rapid prototyping, and introspect to generate schemas from existing databases. The relational query API supports nested relations, partial selects, and pagination patterns. Drizzle Studio is a visual database browser for exploring and editing your data. At under 30KB with no dependencies, Drizzle is perfect for edge computing and serverless environments where bundle size matters. For TypeScript developers who want type safety without the abstraction tax, Drizzle is the ORM of choice.
Key Features
- SQL-like query builder with full TypeScript inference
- Support for PostgreSQL, MySQL, and SQLite
- Drizzle Kit for schema migrations
- Drizzle Studio for visual database browsing
- Zero dependencies and lightweight bundle
- Prepared statements and query performance optimization
- Relational queries API for joins
Pros & Cons
What we like
- Queries feel natural if you know SQL
- Excellent TypeScript type inference
- Very lightweight with zero runtime dependencies
- Migration system is simple and declarative
- Growing rapidly in popularity and community support
Room for improvement
- Younger project with fewer battle-tested edge cases
- Documentation can lag behind features
- Smaller ecosystem of plugins compared to Prisma
- Some advanced SQL features require raw queries
