# drizzle-team/drizzle-orm

ORM

Repository: https://github.com/drizzle-team/drizzle-orm
Canonical: https://ross.abutalabs.com/products/drizzle-orm
Homepage: https://orm.drizzle.team
Language: TypeScript
License: Apache-2.0
License Family: permissive
Topics: typescript, orm, postgresql, mysql, sql, sqlite, bunjs, nodejs, postgres, turso
Last push: 2026-08-26T16:28:01+00:00

## Health v2 (maintenance only)
Score: 87/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 65, longevity 100
- inputs: {"age_days": 1896, "days_push": 7, "days_rel": 159, "gap_med": 4.0, "n_releases_24m": 67}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 35602, forks 1551 (observed 2026-08-28T04:12:00.868621+00:00)

## What it is
Drizzle ORM is a lightweight, headless TypeScript ORM for SQL databases with zero dependencies and full type safety. It supports PostgreSQL, MySQL, and SQLite (including serverless providers like Neon, Turso, PlanetScale, and Cloudflare D1) and ships with Drizzle Kit for migrations and Drizzle Studio for data browsing.

## Use cases
- query postgres with type-safe typescript orm
- manage sqlite schema migrations for a serverless app
- connect to mysql from nodejs without heavy data proxies
- declare sql schemas in typescript and generate migrations
- run database queries in cloudflare workers or edge runtimes
- browse and edit database data with a gui
- build relational queries with joins and filters in typescript

## When to choose
- you want a lightweight, tree-shakeable TypeScript ORM with strong type safety
- you deploy to serverless or edge runtimes and need no native binaries or data proxies
- you use PostgreSQL, MySQL, or SQLite including managed providers like Neon, Turso, or PlanetScale
- you prefer SQL-like query building over heavy abstraction

## When to avoid
- you need a full-featured ORM with automatic change tracking, lazy loading, or a mature unit-of-work pattern
- your project uses databases outside the SQL family (e.g., MongoDB)
- you rely on a very stable 1.0 API and cannot accept pre-1.0 breaking changes

## Facets
- artifact type: library
- maturity: active
- function: orm, database, database-driver, cli
- domain: databases, web-development, backend, developer-tools
- platform: bun, cross-platform, serverless, cloud
- tags: sql, postgresql, mysql, sqlite, type-safe, serverless, migrations, drizzle-kit, drizzle-studio, edge-runtime, nodejs, deno, typescript

## Member repositories
- drizzle-team/drizzle-orm (main) score 87

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:12:00.868621+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T16:26:52.628475+00:00, confidence not recorded.
  - readme: https://github.com/drizzle-team/drizzle-orm (fetched 2026-08-28T04:12:00.868621+00:00, sha dfa1b50369b5)
  - homepage: https://orm.drizzle.team (fetched 2026-08-29T07:48:28.157552+00:00, sha 8e92ac3296d1)
  - site_page: https://orm.drizzle.team/docs/get-started (fetched 2026-08-29T07:48:28.162569+00:00, sha e5dec0b0244a)
  - site_page: https://orm.drizzle.team/docs/overview (fetched 2026-08-29T07:48:28.164351+00:00, sha 88760e704145)
  - site_page: https://orm.drizzle.team/docs/sustainability (fetched 2026-08-29T07:48:28.166162+00:00, sha 2ec92e8b7b2b)
  - site_page: https://orm.drizzle.team/docs/guides (fetched 2026-08-29T07:48:28.168544+00:00, sha f0f94f9a526e)
  - site_page: https://orm.drizzle.team/docs/tutorials (fetched 2026-08-29T07:48:28.170191+00:00, sha 16b7b6caeda1)
  - site_page: https://orm.drizzle.team/docs/latest-releases (fetched 2026-08-29T07:48:28.171679+00:00, sha d1ba72731be9)
  - site_page: https://orm.drizzle.team/docs/gotchas (fetched 2026-08-29T07:48:28.173453+00:00, sha 27b6da663355)
  - site_page: https://orm.drizzle.team/docs/upgrade-v1 (fetched 2026-08-29T07:48:28.174979+00:00, sha 61da6b229fb1)
- Data as of 2026-08-30T08:39:29.467469+00:00.
