Explore / Category guide
ORM & Query Builders
Discover the top ORM & Query Builders in 2026. Compare architecture, pricing tiers, performance benchmarks, and open-source developer alternatives.
Category overviewAbout ORM & Query BuildersRead guideClose guide
Six tools, all free, all open source, all for TypeScript or Node.js against Postgres, MySQL or SQLite. A page this small does not need a survey — the whole shelf fits on one screen, and for most readers the decision is between exactly two of them.
Drizzle ORM (88/100, Drizzle ORM) and Prisma (85/100, Prisma) are the only two here with a scored review, and they disagree about what an ORM is for. Our Drizzle review puts it plainly: it respects the database instead of hiding it. You write something close to SQL, you get types, and there is no query engine between you and Postgres. Prisma takes the opposite position — a schema language, generated client, and by our review's assessment the most approachable developer experience of the two, paid for in bundle size and runtime overhead. That trade is the whole decision. If your app runs on a serverless platform where cold starts and bundle weight are billed, it leans one way; if your team's bottleneck is onboarding people who do not write SQL comfortably, it leans the other.
The catalogue signals point the same direction from different angles. Drizzle sits in 7 published stacks against Prisma's 1, which says something about what people reach for when assembling a new project. Prisma appears in 5 of the 589 published comparisons against Drizzle's 4, which says something about what people are still arguing over. Note also that Prisma carries a telemetry-concerns tag in our catalogue — worth reading its tool page if outbound telemetry is a compliance question for you.
The other four are context rather than candidates. TypeORM and Sequelize are the incumbents you will meet in existing codebases; Knex.js is the query builder underneath a good deal of older Node.js code; Kysely is the type-safe query builder for teams who want the types without the ORM. None of the four has a scored review, and all four were last verified between 21 April and 24 May 2026 — three to four months before the two scored entries, which were both re-verified on 16 August 2026. Treat their details as older than the rest of this page.
One gap to name honestly: every tool here targets JavaScript or TypeScript. If you are on Python, Go or Ruby, this page has nothing for you yet.
showing 6 of 6 tools
TypeScript ORM that feels like SQL
Lightweight, serverless-ready TypeScript ORM with zero dependencies bringing SQL-like syntax into TypeScript for maximum type-safety. Maps queries closely to raw SQL with full auto-completion and type inference. Features Drizzle Kit for migrations, Drizzle Studio for visual browsing, supports PostgreSQL, MySQL, SQLite, and Turso. Runs on Node.js, Bun, Deno, Cloudflare Workers, and Vercel Edge. 26K+ GitHub stars, growing fast as a Prisma alternative.
Next-generation Node.js ORM
Next-generation TypeScript ORM with schema-first design and auto-generated, type-safe database client. Define models in Prisma Schema Language, manage migrations via Prisma Migrate, and browse data in Prisma Studio. Supports PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. Prisma Accelerate provides edge caching and connection pooling, Optimize offers AI-powered query analysis. 40K+ GitHub stars, widely adopted in Node.js/TypeScript.
SQL query builder for Node.js
Flexible SQL query builder for Node.js supporting PostgreSQL, MySQL, SQLite, Oracle, and MSSQL. Chainable API for constructing queries with parameterized bindings. Features schema builder, migration system, seed files, transaction support, and connection pooling. Foundation for ORMs like Bookshelf.js and Objection.js. One of the most established query builders in the Node.js ecosystem.
Type-safe SQL query builder for TS
Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.
Promise-based Node.js ORM
Mature, promise-based ORM for Node.js supporting PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server. Features model definitions with validations, eager/lazy loading, transactions, migrations, raw queries, and lifecycle hooks. Supports soft deletes, scopes, and virtual fields. One of the oldest and most battle-tested Node.js ORMs, widely used in enterprise apps though increasingly succeeded by Prisma and Drizzle in new projects.
ORM for TypeScript and JavaScript
Full-featured ORM for TypeScript and JavaScript supporting Active Record and Data Mapper patterns. Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and MongoDB. Features decorator-based entity definitions, migrations, relations (one-to-one, many-to-many), lazy/eager loading, query builder, transactions, and caching. Supports both Node.js and browser runtimes. 34K+ GitHub stars. Mature but losing mindshare to Prisma and Drizzle for new TypeScript projects.
Community tiers
A different perspective: rank the tools you know from S to D.
Sources & verification
- Eclipse Foundation - Jakarta Persistence Specification
- ACM Special Interest Group on Management of Data (SIGMOD)
Verification dates are editorial checks. Routine CMS saves and automatic updatedAt timestamps do not advance them.