Kysely is a type-safe, autocompletion-friendly TypeScript SQL query builder for Node.js and other JavaScript environments like Deno, Bun, Cloudflare Workers, and web browsers. It helps ensure you only reference visible tables and columns, and it produces correctly typed result rows for the selected columns and aliases.
Project status
- The
kysely-org/kyselyrepository appears actively maintained, with the most recent upstream push on 2026-10-02 and multipleupdatestagged in September 2026 and August 2026. - Apparent cadence is relatively steady, with new version
updatesaround every 1 to 3 weeks (for example, v0.29.5 on 2026-08-10, v0.30.0-beta.2 on 2026-09-14, and v0.29.6 on 2026-09-16).
AI summary generated
Recent updates
v0.29.6
v0.29.6 is positioned as a small bugfix release. The code change targets ON CONFLICT update predicates, specifically enabling WHERE clauses to reference columns that are readable but not updatable (immutable columns). The release also includes broad dependency and tooling version bumps.
v0.30.0-beta.2
v0.30.0-beta.2 introduces major migration ergonomics changes via a new Migrator transactionMode and adds a defineMigration helper to enforce per-migration transaction configuration contracts. It also expands database introspection with where-based partial introspection, adds table comment metadata, and improves streaming support (RawBuilder.stream, plus SQLite row-streaming), alongside MySQL mysql2/promise compatibility.
BreakingFeaturesv0.29.5
Release v0.29.5 is primarily described as a small batch of bug fixes plus a larger docs site revamp. The release notes mention TypeScript type-checking performance improvements (more efficient builder assignability checks), along with specific fixes around infinite recursion in type checks and improving abort handling. The code diff provided, however, shows a very large amount of landing page and docs UI work (search, theming, layout), and multiple internal component API changes.
v0.30.0-beta.1
v0.30.0-beta.1 introduces new migration capabilities, including Migrator support for enforcing direction in migrateTo, and additional transaction control options (as described in the release notes). It also expands MySQL dialect support to work with mysql2/promise instead of hanging when using promise-based imports, while adding stricter SQLite JSON typing around BLOB values.
BreakingFeaturesv0.30.0-beta.0
Kysely v0.30.0-beta.0 introduces a new migration transaction configuration system via `transactionMode` (including per-migration overrides) and a `defineMigration` helper to enforce migration module contracts with better typing. It also updates SQLite JSON helpers to deny passing BLOB-like columns at compile time, and deprecates `disableTransactions` in favor of `transactionMode: 'none'`.
BreakingFeaturesv0.29.4
Release v0.29.4 is positioned as a small bug fix batch. The documented runtime fixes address PostgreSQL password handling for the control client, and the placement of SQLite DELETE RETURNING relative to ORDER BY and LIMIT.
v0.29.3
v0.29.3 is primarily a bugfix release focused on ensuring migrations run with proper exclusivity when `disableTransactions: true` for PostgreSQL and MSSQL. The release notes also include various CI/tooling and dependency bumps, plus documentation updates.
v0.29.2
v0.29.2 is a small release focused on correcting type-level behavior for the `$narrowType` helper, specifically around branded types. The only functional code change is in the type utility that powers `$narrowType`, plus an expanded TypeScript type test to cover branded/narrowing scenarios.
v0.29.1
v0.29.1 is described as a small bugfix release focused on plugin result transformation composition, plus related CI changes. The primary user-impacting change is in how `transformResult` arguments are piped through multiple registered plugins.
v0.29.0
Kysely v0.29.0 adds compile-time query narrowing helpers ($pickTables, $omitTables, $extendTables) and introduces a ReadonlyKysely<DB> helper type. It also ships web standards driven query cancellation via AbortSignal, and adds a new PGlite dialect, along with several related plugins and type-level improvements.
BreakingFeatures