A curated list of Kysely resources, tools, utilities and applications.

Contents

• Adapters
• Addons
• Articles
• CLIs
• Dialects
• ORMs
• Plugins
• Templates
• Tools
• Type Generators
• Videos

Adapters

name	description	url	status
@auth/kysely-adapter	Official Auth.js adapter for Kysely.	link
nestjs-kysely	Kysely module for NestJS.	link
fastify-kysely	Kysely plugin for Fastify.	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

Addons

• kysely-paginate - Pagination helpers for use with Kysely.
• kysely-params - A utility for parameterizing compiled Kysely queries.
• kysely-cache - Cache layer for Kysely.
• kysely-tables - Generate SQL schemas and migrations from your Kysely types.

Articles

• 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.

CLIs

• kysely-migrate - Kysely migrations and codegen CLI.
• kysely-migration-cli - Thin migration cli library for Kysely.

Dialects

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? :trollface:	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

ORMs

• kysely-orm - TypeSafe ORM for Kysely library.
• kysely-mapper - Flexible Kysely-based utility for mapping between tables and objects.

Plugins

• 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

Templates

• 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.

Tools

• 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.

Type Generators

• 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.

Videos

• 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.