Cross-platform SQL editor and database manager for Linux, macOS, and Windows, supporting MySQL, PostgreSQL, SQLite, SQL Server and many more.
drizzle-team/drizzle-orm
A lightweight, headless TypeScript ORM for PostgreSQL, MySQL and SQLite that works across Node.js, Bun, Deno and edge runtimes.
Open-source alternative to:Prisma
- Stars
- 36,089
- Forks
- 1,726
- Open issues
- 2,167
- Last commit
- 4 hours ago
What is it?
Drizzle ORM is a TypeScript ORM for Node.js, TypeScript and JavaScript projects. It lets you declare SQL schemas in TypeScript and write both SQL-like queries and relational queries, with types inferred from the schema. It is a thin typed layer over SQL rather than a heavy abstraction, and it has no runtime dependencies.
It targets every PostgreSQL, MySQL and SQLite database, including serverless and edge services such as Turso, Neon, PlanetScale, Cloudflare D1 and Supabase. The project works in Node.js, Bun, Deno, Cloudflare Workers and browsers, and does not require a separate data proxy or native binaries.
The companion Drizzle Kit CLI generates SQL migration files or applies schema changes directly to the database. Drizzle Studio provides a UI for browsing and editing data.
Key features
- 01Declare SQL schemas in TypeScript with inferred types.
- 02Supports both SQL-like queries and relational queries.
- 03Works with PostgreSQL, MySQL and SQLite, including serverless providers.
- 04Runs across Node.js, Bun, Deno, edge runtimes and browsers.
- 05Ships with zero dependencies and a small bundle size.
- 06Drizzle Kit generates and applies migrations.
Use cases
- Building TypeScript backends that talk to PostgreSQL or MySQL with type-safe queries.
- Deploying database access to serverless or edge functions such as Cloudflare Workers.
- Managing schema changes and migrations for SQLite-backed apps.
- Browsing and editing database contents during development with Drizzle Studio.
Quick start
- 1
Read the full documentation on the official website
Topics
FAQ
- What is drizzle-orm?
- A lightweight, headless TypeScript ORM for PostgreSQL, MySQL and SQLite that works across Node.js, Bun, Deno and edge runtimes. Drizzle ORM is a TypeScript ORM for Node.js, TypeScript and JavaScript projects. It lets you declare SQL schemas in TypeScript and write both SQL-like queries and relational queries, with types inferred from the schema. It is a thin typed layer over SQL rather than a heavy abstraction, and it has no runtime dependencies.
- Is drizzle-orm free to use? What license does it have?
- drizzle-orm is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
- Is drizzle-orm still maintained?
- Actively maintained. The last commit to drizzle-orm was on Oct 19, 2026.
- What can I use drizzle-orm for?
- Building TypeScript backends that talk to PostgreSQL or MySQL with type-safe queries. Deploying database access to serverless or edge functions such as Cloudflare Workers. Managing schema changes and migrations for SQLite-backed apps. Browsing and editing database contents during development with Drizzle Studio.
- How do I install drizzle-orm?
- Read the full documentation on the official website
- Where can I get drizzle-orm?
- The source code and installation instructions are on GitHub: https://github.com/drizzle-team/drizzle-orm
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
A lightweight, framework-agnostic command-line tool for managing plain SQL database migrations across teams and environments.
A keyboard-driven terminal UI for connecting to and querying many SQL databases, inspired by lazygit.
Lightweight cross-platform database client for 100+ databases, with desktop, Docker, CLI, a built-in AI SQL assistant and an MCP server.
A lightweight, self-hostable backend with database, auth, media and workflows, built on Web Standards to run across many runtimes and frameworks.
Full-stack database exploration tool for designing, navigating, documenting and analyzing schemas, with ERD diagrams for large, messy databases.