Drizzle ORM is unclaimed —
D
Drizzle ORM
next gen TypeScript ORM.·orm.drizzle.team
Drizzle ORM is a lightweight and performant TypeScript ORM built with developer experience in mind. It supports PostgreSQL, MySQL, SQLite, SingleStore, MSSQL and CockroachDB, and integrates with serverless and edge database providers such as Neon, Supabase, PlanetScale and Cloudflare D1. It provides schema definition, a type-safe query builder, migrations, and Row-Level Security support for PostgreSQL, along with companion tools like Drizzle Kit for migrations and Drizzle Studio for browsing data.
What it's for
Writing type-safe SQL queries in TypeScriptDefining and managing database schemaGenerating and running database migrationsConnecting to serverless and edge databases (Neon, Supabase, PlanetScale, Cloudflare D1, etc.)Enabling Row-Level Security policies on PostgreSQL tablesSeeding databases with test dataValidating data against schema using zod, valibot, typebox, arktype or effect-schemaBrowsing and editing database data via Drizzle Studio
Features 20
- Custom types and codecs
- Database seeding via drizzle-seed with generators and versioning
- Drizzle Studio for browsing and editing database data
- drizzle-graphql extension
- Dynamic query building
- ESLint plugin
- Migrations via Drizzle Kit (generate, migrate, push, pull, export, check, up, studio)
- Query building: select, insert, update, delete, filters, joins, aliases
- Read replicas support
- Row-Level Security (RLS) support for PostgreSQL with roles and policies
- Schema definition with data types, indexes, constraints and sequences
- Serverless-ready by design
- Set operations and generated columns
- Support for Views and Materialized Views
- Supports PostgreSQL, MySQL, SQLite, SingleStore, MSSQL and CockroachDB
- Transactions and batch queries
- Tree-shakeable
- TypeScript ORM with SQL-like query syntax
- Validation library integrations (zod, valibot, typebox, arktype, effect-schema)
- ~7.4kb minified+gzipped, zero dependencies
At a glance
TypeLibrary / SDK
Fordevelopers
CompanyDrizzle Team
Integrations
PostgreSQLMySQLSQLiteSingleStoreMSSQLCockroachDBGelNeonVercel PostgresPrisma PostgresSupabaseXataPGliteNileBun SQLEffect PostgresNetlify DatabaseAppwrite PostgresAWS Data API PostgresPlanetScalePlanetScale PostgresTiDBAppwrite MySQLTurso CloudTurso DatabaseSQLite CloudCloudflare D1Cloudflare Durable ObjectsBun:SQLiteNode:SQLiteExpo SQLiteOP SQLitezodvalibottypeboxarktypeeffect-schema
Resources