kysely-org/kysely

Health v2 · maintenance only

Adoption not part of the score

14168 stars · 435 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Kysely is a type-safe, autocompletion-friendly SQL query builder for TypeScript, inspired by Knex. It supports PostgreSQL, MySQL, MSSQL, and SQLite, and runs on Node.js, Deno, Bun, workers, and browsers with zero runtime dependencies.

Use cases

• build type-safe SQL queries in TypeScript
• catch invalid table and column references at compile time
• compose reusable query fragments, subqueries, and CTEs
• query PostgreSQL, MySQL, SQLite, or MSSQL from Node.js
• get autocompletion for table and column names
• migrate queries safely when the database schema changes

When to choose

• you want compile-time safety for SQL without a full ORM
• your team uses TypeScript with strict mode and values precise result types
• you need a lightweight query builder with zero runtime dependencies
• you want Knex-like ergonomics with much stronger typing

When to avoid

• you need a full ORM with relations DSL, migrations, and entity management out of the box
• your project is plain JavaScript without TypeScript
• you prefer writing raw SQL strings exclusively

Facets

library · maturity stable

database orm developer-tools databases web-development backend developer-tools bun browser cross-platform sql-query-builder type-safe query-builder postgresql mysql sqlite mssql knex-inspired nodejs deno typescript

Member repositories

For agents

markdown · JSON · MCP: product_card(name="kysely-org/kysely")