Skip to main content

Kysely

The type-safe SQL
query builder for TypeScript

Getting started View on GitHub

↓

Type-safe SQL queries

Kysely lets you write type-safe SQL queries. This eliminates entire classes of errors and lets 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 number of concepts you need to learn to be proficient with the library.

Great autocompletion

By exposing your database schema to the TypeScript compiler, you get autocompletion on table names, column names, aliases, etc.

Multi-dialect support

PostgreSQL, MySQL, or SQLite? We've got you covered. There's also a growing ecosystem of third-party dialects, including PlanetScale, D1, 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.

Extensible core

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 its simplicity and power.

Lee "leerob" RobinsonNext.js comm lead, Vercel VP of DX

Type-safe SQL queries with PlanetScale and Kysely 😍

Orta TheroxEx-TypeScript team

👋 been using Kysely for a few days in Deno and Node, just wanted to say it's been going really well and it feels like a nice abstraction - kudos!

Ben HolmesAstro SWE

Kysely I love you, but I still can't spell your name

Julius MarmingetRPC & create-t3-app core team

Utterly astounded by how Kysely manages to make all of this typesafe. Seems like no matter how complex you get, it can infer it correctly.

Shoubhit "nexxel" Dashcreate-t3-app creator

kysely is great btw

Tim GriesserKnex.js creator, Cypress Staff Eng

👋 First just wanted to say this project looks awesome! Pretty close to what I wish Knex was if I started it now, with the affordances of modern TypeScript instead of 10 years ago when we were stuck in ES5 and Promises weren't even really an official language construct yet.

Dax "thdxr" RaadSST core team

Kysely is the best written TS codebase I've ever seen

Harminder VirkAdonisJS creator

Kysely is great. Keeping an eye on it to see how it evolves in coming months

Gal Schlezingerfnm creator, Vercel SWE

Yusuke "yusukebe" WadaHono creator, Cloudflare DevRel

Kysely is great. D1 will be great. This is great.

"pilcrow"Lucia creator

Ok, so I'm not a big fan of Drizzle. I don't like how I have to import everything when declaring schemas and queries, and I just prefer the simplicity and the overall API of Kysely.

Theo "t3dotgg" BrowneUploadthing creator, Ping.gg CEO

Planetscale's DatabaseJS combined with Kysely or DrizzleORM is pretty dope to stay on edge

Nicholas Griffinsqs-consumer maintainer, BBC SWE

I don't actually like prisma that much, I prefer Kysely, not an ORM though.

R. Alex AndersonThorium Nova creator

Shout out to Kysely for adding extensive JSDoc comments above the methods. It makes it much easier to figure out how to use it the way I want without having to dig into the docs. (though the docs are vv good too)

Ross Coundonleadent digital CTO

I particularly like Kysely here, it's a type-safe query builder and as such doesn't enforce the specifics of an ORM on you, therefore I feel, in the medium-to-long term, it'll save you the time and effort of working around ORM-specific and enforced structures/approaches

Alberto "gimenete" GimenoRailway SWE

I'm a happy Kysely user. It's great to see that the code I'm writing now can work with serverless PostgreSQL now!

Johan EliassonOneLab CTO

Instead of Prisma, I'm testing Kysely, Kysely Codegen, and Atlas. Works great.

Mehul MohanCodedamn Founder

We went with query builder because we did not have more time to waste on ORMs. ORMs might be great but we have the technical capability to pull off just using a query builder. However, we type safety and sanitization for DX and security was a must - hence Kysely.

Sam CookGamma.io SWE

Kysely is amazing.

Gannon HallAstro Labs Founder

Vercel just announced native Postgres support and published Prisma and Kysely templates. I like the DX of Prisma and the type safety of Kysely so I use both via prisma-kysely.

Alisson "thelinuxlich" C.AgianiOpensourcerer

Kysely is superior and with each release gets even more awesome

Try it out for yourself!

Modify the query on the left and view the generated SQL on the right.

Looking for code examples?

From finding a single record to complex joins, our docs have examples to get you started quickly.