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

Contents

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

Adapters

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.
• kysely-cursor - Cursor based pagination utils for Kysely with multi-dialect support.
• kysely-shaper - Helper for Kysely to create composable queries.

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.
• A simple fuzzy search using PostgreSQL and Kysely - An interactive blog post by kafendt on how to implement a fuzzy search using only Postgres and Kysely.

CLIs

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

Dialects

ORMs

• kysely-orm - TypeSafe ORM for Kysely library.
• kysely-mapper - Flexible Kysely-based utility for mapping between tables and objects.
• kysera - Type-safe data access toolkit for TypeScript built on Kysely.
• kysely-relations - Drizzle like relations api to use kysely like an orm

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
• kysely-hash - Hash plugin for Kysely.
• kysely-sqlcommenter - Add SQLCommenter-compliant request, route, and trace metadata to Kysely-generated SQL.

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.
• kysely-prompt - A prompt packed with examples from the Kysely docs to help AI learn how to write queries with Kysely.

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.