Kysely

Kysely is a type-safe SQL query builder for TypeScript that actually trusts you to write SQL. No magic schema files, no ORM abstractions — just a query builder where TypeScript catches your column name typos at compile time.

Drizzle ORM is the trendier alternative with built-in migrations and a schema DSL — most new projects default to it in 2026. Prisma is the ORM with the best DX for simple CRUD but generates bloated queries. Knex is the predecessor Kysely improves on, minus the type safety.

Use Kysely if you're a SQL-first developer who wants full query control with TypeScript autocomplete. It shines when your queries are complex — joins, subqueries, CTEs — where ORMs generate garbage. Performance benchmarks show it slightly faster than Drizzle with less overhead.

The catch: no built-in migrations or schema management. You'll pair it with a separate migration tool, which means more setup. And community momentum has shifted toward Drizzle — fewer tutorials, fewer integrations, smaller ecosystem. Kysely is the technically superior query builder that's losing the popularity contest.