ORM & Query Builders
TypeScript database libraries compared — schema-first ORMs, SQL-first query builders, and migration tooling for Postgres and more.
alternatives (4)
★ Prisma
Best for: Schema-first TypeScript ORM
Schema-first ORM with a declarative schema file, type-safe client, migrations, and Prisma Studio for browsing data.
- +Excellent DX
- +Prisma Studio
- +Strong migrations
- −Abstraction overhead
- −Not raw SQL
Drizzle
Best for: SQL-like TypeScript ORM
Lightweight, SQL-like TypeScript ORM — define schema in TS, query close to SQL, with zero runtime overhead and edge support.
- +SQL-like queries
- +Edge/serverless friendly
- +Lightweight
- −Younger than Prisma
Kysely
Best for: Type-safe SQL builder
Type-safe SQL query builder — no ORM magic, just composable SQL with full TypeScript inference from your schema types.
- +Pure SQL control
- +No ORM overhead
- +Great inference
- −No schema DSL
- −You write SQL
TypeORM
Best for: Decorator-based ORM
Mature decorator-based ORM for TypeScript — entities, relations, migrations, and support for many SQL databases.
- +Mature
- +Many DBs
- +Active Record pattern
- −Heavier API
- −Less modern than Drizzle
Compare
Tick the ones you want to compare
Pair with a database from Serverless Databases or a full BaaS. Prisma is the default for schema-first DX and migrations. Drizzle wins when you want SQL-like control with types and edge deployment. Kysely is for teams that want a query builder without ORM abstraction. TypeORM is the mature decorator-based option for traditional entity models.