The type-safe SQL
query builder for TypeScript
Type-safe SQL queries
Kysely let's you write type-safe SQL queries. This eliminates entire classes of errors and let's you sleep peacefully at night.
No magic, just SQL
Kysely is a light abstraction layer over SQL. This makes it easy to reason about performance, and reduces the amount of concepts you need to learn to be proficient with the library.
By exposing your database schema to the TypeScript compiler, you get autocompletion on table names, column names, aliases, etc.
PostgreSQL, MySQL, or SQLite? We've got you covered. There's also a growing ecosystem of 3rd party dialects, including PlanetScale, D3, SurrealDB, and more. Learn more.
Runs on every environment
Kysely runs on node.js, the browser, serverless and edge environments, even on Deno! Learn more.
Kysely comes with a plugin system that lets you extend the core with your own functionality. Learn more.
What the internet is saying
Developers are loving Kysely for it's simplicity and power.
Looking for code examples?
From finding a single record to complex joins, our docs have examples to get you started quickly.Jump right in