Kysely
Kysely: A free, open-source SQL builder for TypeScript teams that want static query typing. Ranked #9 of 51 in Database Query Builders by our editors (7.9/10); pricing: Free plan; best for typeScript teams prioritizing a type-safe SQL builder.
At a glance
- Editor score7.9 / 10
- PricingFree plan
- Best forTypeScript teams prioritizing a type-safe SQL builder
- Free planYes
- Paid fromNone
- Type safetyStatic
- Founded2021
- Facts checked4 Oct 2026
Where it wins
- Infers result types and catches invalid table or column references at compile time
- Built-in dialects cover PostgreSQL, MySQL, SQL Server, SQLite, and PGlite
- Supports CTEs, transactions, schema queries, plugins, and raw SQL
Where it doesn't
- Focused on TypeScript rather than a language-neutral query API
- Only five database dialects are built in; others rely on community support
- Self-hosted and supported through documentation and community channels
Our verdict on Kysely
Kysely is an open-source TypeScript SQL query builder for developers building applications around relational databases. It suits teams that want SQL expressed through a fluent API while using a typed schema to get autocomplete, inferred result types, and compile-time checks for invalid table or column references. Its free, self-hosted model can fit projects from solo development through enterprise use, provided the team is comfortable working in TypeScript.
Database coverage is one of its practical strengths: built-in dialects support PostgreSQL, MySQL, Microsoft SQL Server, SQLite, and PGlite, while a community-supported dialect system extends the options. Kysely can compile queries without a database driver, which can be useful where query construction and execution need to remain separate. The API covers CRUD operations, joins, subqueries, set operations, common table expressions, transactions, and data definition language queries. Raw SQL remains available through a template tag, so teams can step outside the fluent builder when needed.
Kysely is a focused library rather than a hosted database service: deployment is self-hosted, and support comes through documentation and the community. Its type-safety model depends on a typed database schema and is aimed specifically at TypeScript, so it is a poor fit for teams seeking a language-agnostic tool or managed support channel. Choose it when compile-time query checks, SQL composition, and driver-independent compilation matter; consider another approach if your priority is a managed interface or a built-in dialect beyond its five listed options.
Your product? Our editors can test Kysely in depth and publish a review, labelled as paid · from $99/mo →
Kysely pricing
Kysely fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | TypeScript |
| SQL dialects | PostgreSQL, MySQL, Microsoft SQL Server (MSSQL), SQLite, PGlite; community dialects also available |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Deployment | Self-hosted |
| Platforms | Web, Windows, macOS, Linux |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | kysely.dev |
| Facts checked | 4 Oct 2026 |
Alternatives to Kysely
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
Used Kysely? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Kysely for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Kysely is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/kysely/"><img src="https://www.itechguides.com/best/badge/kysely.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update