Kysely: Type-Safe SQL Patterns

Kysely (pronounced "Key-Seh-Lee") is a type-safe TypeScript SQL query builder. It generates plain SQL with zero runtime ORM overhead. Every query is validated at compile time with full autocompletion.

Kysely is not an ORM -- no relations, no lazy loading, no magic. Just SQL with types.

When to Use

• "write a Kysely query"
• "create database migration"
• "add a new table"
• "query with joins / subqueries / CTEs"
• "JSONB or array column operations"
• Working with an existing Kysely + PostgreSQL codebase
• Debugging Kysely type inference issues

Outcomes