A curated list of Kysely resources, tools, utilities and applications.
- nestjs-kysely - Kysely module for NestJS.
- @auth/kysely-adapter - Official Auth.js adapter for Kysely.
- feathers-kysely - FeathersJS SQL service adapter built with Kysely.
- 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.
- 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.
- Typescript で SQL を叩く方法を整理する - A blog post by moekidev about trying out Kysely with Prisma and Vercel Postgres.
- 現状Cloudflare WorkersでGraphQLサーバを構築するならコレ - A blog post by chimame about combining GraphQL, Prisma and Kysely on Cloudflare Workers.
- kysely-migration-cli - Thin migration cli library for Kysely.
- kysely-data-api - This library adds AWS RDS Data Api support for Kysely. It has support for both MySQL and Postgres.
- kysely-planetscale - A Kysely dialect for PlanetScale, using the PlanetScale serverless driver for JavaScript.
- kysely-d1 - Kysely dialect for Cloudflare D1.
- 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.
- @vercel/postgres-kysely - A @vercel/postgres wrapper for the Kysely query builder.
- kysely-neon - Kysely dialect for Neon serverless Postgres.
- kysely-dialect-tauri - Kysely dialect using Tauri's official SQLite plugin.
- kysely-wasm - WebAssembly dialect for Kysely.
- kysely-sqlite-worker - Execute SQL in Node worker threads, using better-sqlite3.
- kysely-wasqlite-worker - Execute SQL in Web Worker, using wa-sqlite, store data in IndexedDB.
- @libsql/kysely-libsql - A Kysely dialect for libSQL/sqld, using the Hrana protocol over a WebSocket.
- kysely-singlestore - Kysely dialects, plugins and other goodies for SingleStore (formerly MemSQL).
- kysely-surrealdb - Kysely dialects, plugins and other goodies for SurrealDB. SurrealQL is based on SQL, so why not?
- @andersgee/kysely-fetch-driver - Edge compatible fetch driver for Kysely.
- kysely-s3-select - Kysely dialects, plugins and other goodies for Amazon S3 Select.
- kysely-ydb - Kysely dialects, plugins and other goodies for YDB.
- kysely-pg-client - Non-pooling single-connection PostgreSQL dialect for Kysely, thoroughly tested.
- kysely-expo - Support for Kysely with Expo SQLite.
- kysely-deno-postgres - A Kysely dialect for PostgreSQL using deno-postgres under the hood.
- 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.
- 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.
- 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-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.