A curated list of Kysely resources, tools, utilities and applications.
| name | description | url | status |
|---|---|---|---|
 @auth/kysely-adapter |
Official Auth.js adapter for Kysely. | link |   |
 nestjs-kysely |
Kysely module for NestJS. | link |    |
 kysely-sequelize |
A toolkit (dialect, type translators, etc.) that allows using your existing Sequelize instance with Kysely. | link |    |
 kysely-typeorm |
A toolkit (dialect, type translators, etc.) that allows using your existing TypeORM setup with Kysely. | link |    |
 feathers-kysely |
FeathersJS SQL service adapter built with Kysely. | link |    |
 pg-mem |
pg-mem is an experimental in-memory emulation of a postgres database. | link | |
 kysely-knex |
A toolkit (dialect, type translators, etc.) that allows using your existing Knex setup with Kysely. | link |    |
 kysely-supabase |
A toolkit (type translators for now) that allows using your existing Supabase setup with Kysely. | link |    |
- kysely-paginate - Pagination helpers for use with Kysely.
- kysely-params - A utility for parameterizing compiled Kysely queries.
- Kysely - A type-safe SQL query builder for typescript - A blog post by koskimas, the creator of Kysely. Letting the world know, way back in 2021, what is Kysely, its inspiration, design principles, etc.
- Type-safety with TypeScript ORMs and query builders - thetutlage compares Kysely with alternatives and showcases it's superior type-safety and autocompletion in this precise post.
- Typesafe Database Queries on the Edge - The groundbreaking blog post by nexxel that set the stage for the Prisma + Kysely + Planetscale's DatabaseJS serverless driver usage pattern. Inspired the prisma-kysely adapter.
- Type-safe SQL queries with Kysely and PostgreSQL - A blog post by Marcin Wanago that covers introducing Kysely and PostgreSQL to a NestJS project from the ground up and in great detail.
- One-to-one relationships with the Kysely query builder - A blog post by Marcin Wanago that covers how to manage one-to-one SQL relationships between tables using Kysely.
- Building a PageSpeed Monitoring Service Using Remix, Kysely, and Litestream - A great blog post by Josef Erben that provides a high-level overview of an architecture combining Kysely and Remix, and shows trade-offs of design decisions made.
- Build TypeSafe Node API using tRPC, Fastify, Kysely and Atlas CLI - A blog post by Francisco Mendes on combining Kysely, tRPC, Fastify and Atlas to build a robust, type-safe CRUD API.
- Crafting the Perfect T3 Stack: My Journey with Kysely, Atlas, and Clerk - A blog post by Johan Eliasson on how he built his T3 inspired stack with Kysely, Atlas and Clerk.
- Build a fully typed web app using Next.js, PlanetScale, Drizzle, and Kysely - A blog post by Ayoub Khial. If you're working with a Next.js app based on TypeScript and searching for a reliable database solution, combining PlanetScale, DrizzleORM, and Kysely can be a mighty stack.
- Kysely dialect for PlanetScale - A blog post by Jacob Gillespie on how Depot adopted Kysely and PlanetScale and created the Planetscale dialect.
- Running Vercel Postgres Locally - A blog post by Gal Schlezinger on how he utilizes neon's WebSockets proxy docker image and Kysely to run his postgres queries locally and ship fast without breaking anything.
- Simple CQRS in NodeJS with Typescript - A blog post by Illija on how to implement a simple CQRS pattern with query models using Kysely.
- Kysely and CockroachDB - A blog post by Morgan Winslow on Kysely and how to use it with CockroachDB.
- Type-safe S3 Select queries with Kysely - A blog post by Thomas Aribart on how to query AWS S3 buckets, and how to do it in a type-safe manner with Kysely. Inspired the S3 Select dialect.
- Kysely: The Type-Safe SQL Query Builder for TypeScript - A blog post by Pugazhenthi providing a short overview of Kysely.
- Build a GraphQL server running on Cloudflare Workers - A blog post by chimame about combining GraphQL, Prisma and Kysely on Cloudflare Workers.
- Typescript で SQL を叩く方法を整理する - A blog post by moekidev about trying out Kysely with Prisma and Vercel Postgres.
- Kysely が Knex をリプレイスする日も近いかもしれない - A blog post by acro5piano comparing the type safety of Kysely, Knex, and Slonik.
- kysely-migrate - Kysely migrations and codegen CLI.
- kysely-migration-cli - Thin migration cli library for Kysely.
| name | description | url | status |
|---|---|---|---|
 kysely-data-api |
This library adds AWS RDS Data Api support for Kysely. It has support for both MySQL and Postgres. |
link |    |
 kysely-postgres-js |
Kysely dialect for PostgreSQL using the Postgres.js client library under the hood. This dialect should not be confused with Kysely's built-in PostgreSQL dialect, which uses the pg client library instead. |
link |    |
 kysely-planetscale |
A Kysely dialect for PlanetScale, using the PlanetScale serverless driver for JavaScript. |
link |    |
 @vercel/postgres-kysely |
A @vercel/postgres wrapper for the Kysely query builder. | link |   |
 kysely-neon |
Kysely dialect for Neon serverless Postgres. | link |    |
 @xata.io/kysely |
A Kysely dialect for Xata, using the Xata serverless driver for TypeScript. | link |   |
 kysely-d1 |
Kysely dialect for Cloudflare D1. | link |    |
 kysely-bun-worker |
Kysely dialect for Bun SQLite, run sql in worker. | link |   |
 @libsql/kysely-libsql |
A Kysely dialect for libSQL/sqld, using the Hrana protocol over a WebSocket. | link |    |
 kysely-sqlite-worker |
Execute SQL in Node worker threads, using better-sqlite3. | link |   |
| kysely-wasm |
WebAssembly dialect for Kysely. | link |   |
 kysely-dialect-tauri |
Kysely dialect using Tauri's official SQLite plugin. | link |   |
| kysely-wasqlite-worker |
Execute SQL in Web Worker, using wa-sqlite, store data in IndexedDB. | link |   |
 kysely-singlestore |
Kysely dialects, plugins and other goodies for SingleStore (formerly MemSQL). | link |    |
 kysely-surrealdb |
Kysely dialects, plugins and other goodies for SurrealDB. SurrealQL is based on SQL, so why not?  |
link |    |
 @andersgee/kysely-fetch-driver |
Edge compatible fetch driver for Kysely. | link |    |
 @tidbcloud/kysely |
Kysely dialect for TiDB Cloud, using the TiDB Cloud serverless driver. | link |    |
 kysely-s3-select |
Kysely dialects, plugins and other goodies for Amazon S3 Select. | link |    |
 kysely-duckdb |
This dialect allows you to use Kysely with DuckDB. | link |    |
- kysely-orm - TypeSafe ORM for Kysely library.
- kysely-mapper - Flexible Kysely-based utility for mapping between tables and objects.
- kysely-plugin-serialize - Kysely plugin that serializes parameters.
- kysely-access-control - plugin that allows you to Allow/Deny/Omit (or add a where clause) to access any kysely table or column
- kysely-grants - plugin that implements "Postgres-style grants" on top of kysely-access-control
- kysely-plugin-prefix - set of plugins that allow you to prefix table and index names implicitly
- Acme Corp - Your all-in-one, enterprise ready starting point. Full-stack Typesafety with tRPC, Next.js, and React Server Components. Typesafe database access using Kysely as a query builder, and Prisma for schema management.
- create-o7-app - An opinionated CLI for creating type-safe Svelte apps. create-o7-app's template includes Kysely for Edge support and fast cold starts, with all the convenience of using Prisma to define your database model.
- remix-d1-kysely-demo - In this repo you'll learn how to setup a D1 database starting from Remix's @cloudflare/pages template and how to interact with it using Kysely query builder.
- Vercel Postgres + Kysely Next.js Starter - Simple Next.js template that uses Vercel Postgres as the database and Kysely as the query builder.
- kysely-playground - Playground for Kysely. Provides vscode-like experiences including type checking and auto suggestions. Supports built-in dialects (Postgres, MySQL, SQLite), last 20 Kysely versions. You can test stuff quickly, and create issues with reproducing with the playground.
- Kysely Assistant - Translate SQL to Kysely syntax using Chat GPT.
- kysely-codegen - Generate Kysely type definitions from your database.
- prisma-kysely - Generate Kysely types directly from your Prisma schema.
- kanel-kysely - Generate Kysely types directly from your PostgreSQL database. This package extends Kanel with some Kysely specific features.
- I tried 8 different Postgres ORMs - Fireship breaks down some popular PostgreSQL libraries in the Node.js ecosystem. Starting from client libraries, going through query builders (Kysely is mentioned starting at the 5:20 mark) and then finishing with ORMs.
- Kysely first impressions - Typescript SQL query builder and migrations - In the video we take a quick look at a new Typescript SQL query builder which optimizes for type-safety and the best possible intellisense. We'll walk through how to use it to connect to a database and perform typical CRUD queries, we'll explore how to simulate relational queries, and finally, we'll give their migration feature a try!
- We need to talk about Prisma - Mehul Mohan talks about what codedamn went through while migrating from MongoDB to Prisma and Planetscale, and their eventual re-re-write to AWS Aurora and Kysely for type-safety and performance (starts at the 14:37 mark).
- Let's Talk About Database Performance - Theo Browne aka t3.gg talks about database performance, Prisma, serverless and edge functions, PlanetScale, their Data API offering and type-safety via Kysely (starts at the 15:57 mark).
- Type-Safe SQL on the Edge with Kysely - Supabase Edge Functions can connect directly to your Postgres database to execute SQL Queries. Kysely is a type-safe and autocompletion-friendly typescript SQL query builder. Combining Kysely with Deno Postgres provides a neat developer experience for interacting directly with your Postgres database.
- 2022-08-12 - Fresh Spots - Deno + Fresh Part 4 - Kysely DB Setup / Replacement - Watch Coding Garden as he combines Kysely (starts at the 12:09 mark), Deno and Fresh on his stream.
- how to get better at typescript (feat. kysely) - While videos and blog posts are great, nothing teaches me faster than trying to duplicate a cool pattern or technique. Sometimes that pattern comes from other languages, like Rust, and sometimes, it's something that TS developers who are way smarter than me have come up with.
