What kysely-org/kysely shipped
Written by FoxPlug from the repository's own releases; not affiliated with Kysely. Paste your own repository in the box below and FoxPlug writes the same weekly update for your product. This page is an automatic summary of the releases, pull requests and commits in github.com/kysely-org/kysely; Kysely did not write it and does not use or endorse FoxPlug. Every line links to the change it describes.
Get a weekly update like this for your product, free
Week of November 2, 2026
What shipped
- Fixed jsonBuildObject inferring unknown when a key() or at() JSON path reference is passed inline instead of hoisted into a variable. Pull request #2228
- Fixed withSchema crashes on for update and share tables and on
json_aggorto_jsontables inside subqueries built from the same instance. Pull request #2227 - Fixed pglite reporting a successful commit when the transaction was actually aborted and rolled back, with a bump to the pglite dependency. Pull request #2217
- Documented FileMigrationProvider customization, covering supported files, migration exports and ignored-file reasons with import and reporting examples. Pull request #2179
- Documented compiled queries and raw execution, including how they are created, their fields and dialect-specific parameter placeholders. Pull request #2177
- Added a Kysely vs Knex page comparing the two on table types, inference through joins, aliases and nested JSON results. Pull request #2184
- Expanded the raw SQL recipe with a reusable
date_binexpression in a typed query showing bound values and composition around a local fragment. Pull request #2191 - Adopted Pagefind 1.6 search options on the site, marking truncated excerpts with an ellipsis on the guide and API indexes and hiding the keyboard shortcut badge on small devices. Pull request #2233
- Refreshed 49 of the 51 proof wall repository permalinks to current default-branch HEAD, updating evidence dates. Pull request #2231
- Added Capacities, Disney, Talentir and Teamspective to the production proof wall. Pull request #2229
Why it matters
This week brought three fixes for real query building and driver problems: inline JSON path references in jsonBuildObject, withSchema subqueries, and pglite commit reporting. The docs also gained pages on compiled queries, file migration provider customization and a Kysely vs Knex comparison, plus an expanded raw SQL recipe. The proof wall picked up new entries and refreshed links.
Changelog entry
- Fixed jsonBuildObject inferring unknown for inline key() and at() JSON path references. Pull request #2228
- Fixed withSchema crashes on for update and share tables and
json_aggorto_jsontables in subqueries. Pull request #2227 - Fixed pglite reporting successful commits for aborted, rolled-back transactions and bumped the pglite dependency. Pull request #2217
- Documented FileMigrationProvider custom imports and ignored-file callbacks. Pull request #2179
- Documented CompiledQuery, CompiledQuery.raw and executeQuery with a parameterized PostgreSQL example. Pull request #2177
- Added a Kysely vs Knex comparison page. Pull request #2184
- Expanded the raw SQL recipe with a reusable
date_binexpression in a typed query. Pull request #2191 - Adopted Pagefind 1.6 search options, including ellipsis on truncated excerpts. Pull request #2233
- Refreshed proof wall permalinks for 49 of 51 repository entries. Pull request #2231
- Added Capacities, Disney, Talentir and Teamspective to the production proof wall. Pull request #2229
- Added Omnea to the production proof wall. Pull request #2220
- Added OpenWork to the production proof wall. Pull request #2232
This week: jsonBuildObject now infers types for inline key() and at() paths, withSchema no longer crashes on subqueries with for update tables or json_agg, and pglite no longer reports aborted transactions as committed. Docs add compiled queries, Knex comparison and more proof wa
This week shipped three fixes: jsonBuildObject now infers types when key() or at() references are passed inline, withSchema no longer crashes on subqueries containing for update or share tables or json_agg and to_json tables, and the pglite dialect no longer reports a commit as successful when the transaction was aborted and rolled back. On the docs side we documented compiled queries and raw execution, documented FileMigrationProvider customization, added a Kysely vs Knex comparison, expanded the raw SQL recipe, and updated the production proof wall with new entries and refreshed permalinks.
Week of October 26, 2026
What shipped
- Released 0.29.8 with two PostgreSQL transaction fixes: failed rollbacks discard the client instead of returning it to the pool, and commits that PostgreSQL turns into rollbacks now throw AbortedTransactionError. Release
- Released 0.28.19, a maintenance release that backports the PostgreSQL transaction fixes from 0.29.8. Release
- Released 0.28.18, backporting bug fixes and documentation improvements from the 0.29 line, including connection leaks and shared completion state in controlled transactions. Release
- Merged a fix that rejects commits that roll back aborted transactions by checking the transaction command instead of trusting a successful commit. Pull request #2161
- Added a documentation page comparing SQL query builders and raw SQL in TypeScript, covering fragment reuse and other patterns. Pull request #2182
- Added a documentation category comparing SQL query builders and ORMs. Pull request #2181
- Added Craig to the site proof wall. Pull request #2197
- Added TREK to the site proof wall. Pull request #2196
- Bumped dependencies. Pull request #2209
Why it matters
This week brought important PostgreSQL transaction fixes: failed rollbacks no longer return a client to the pool, and commits that PostgreSQL actually rolls back now raise an error instead of reporting success. Both fixes are available in 0.29.8 and backported to 0.28.19, so users on either line can get them. The docs also gained new comparison pages covering SQL query builders, raw SQL, and ORMs.
Changelog entry
- Released 0.29.8 with PostgreSQL transaction fixes for failed rollbacks and aborted commits. Release
- Released 0.28.19 with backported PostgreSQL transaction fixes. Release
- Released 0.28.18 with backported bug fixes and documentation improvements. Release
- Rejected commits that roll back aborted transactions in PostgreSQL. Pull request #2161
- Added documentation comparing SQL query builders and raw SQL in TypeScript. Pull request #2182
- Added documentation comparing SQL query builders and ORMs. Pull request #2181
- Added Craig to the site proof wall. Pull request #2197
- Added TREK to the site proof wall. Pull request #2196
- Bumped dependencies. Pull request #2209
Kysely 0.29.8 is out with PostgreSQL transaction fixes: failed rollbacks now discard the client instead of returning it to the pool, and commits that PostgreSQL turns into rollbacks throw AbortedTransactionError. Backported in 0.28.19. New docs compare query builders with raw SQL
Two Kysely releases this week address PostgreSQL transactions. In 0.29.8, clients whose rollback fails are discarded instead of returned to the pool, and commits that PostgreSQL turns into rollbacks now throw AbortedTransactionError rather than reporting success. These fixes are backported to 0.28.19. Release 0.28.18 also backports bug fixes and documentation improvements from the 0.29 line, including fixes for connection leaks and shared completion state in controlled transactions. On the docs side, new comparison pages cover SQL query builders versus raw SQL in TypeScript and versus ORMs. The proof wall also gained Craig and TREK.
Week of October 12, 2026
What shipped
- Published 0.30.0-beta.2 with a new transactionMode option for Migrator and its methods, offering per-run, per-migration and none. Release
- Released 0.29.7 with controlled transaction fixes: commit, rollback and savepoint commands now wait for ongoing queries and streams to finish, and connection leak and shared completion state issues are addressed. Release
- Released 0.28.18 as a maintenance release that backports bug fixes and documentation improvements from the 0.29 line, including the controlled transaction fixes. Release
- Added Migrator.provider and FileMigrationProvider.migrationFolder getters so kysely-ctl can obtain the migration folder from a migrator using FileMigrationProvider. Pull request #2144
- Changed controlled transaction commands to go through the connection provider, so commit, rollback, savepoint, rollbackToSavepoint and releaseSavepoint no longer reach the driver while a query or stream still owns the connection. Pull request #2081
- Fixed a lost pool slot: when rollback of a controlled transaction rejects, the connection is now released. Pull request #2136
- Fixed the Postgres driver so that when destroy runs while acquireConnection is still waiting on pool.connect, the client is released and an error is thrown. Pull request #2088
- Clarified in the destroy JSDoc and the getting-started guide that callers of shared or externally managed pools and database instances should skip destroy and let the application close the resources. Pull request #2143
- Updated CI to add registry fallbacks and reuse the SQL Server image, so database startup is less likely to fail when a registry throttles downloads. Pull request #2140
- Bumped dependencies. Pull request #2142
Why it matters
This week brought a new beta with a configurable transaction mode for migrations, plus releases on the 0.29 and 0.28 lines carrying controlled transaction fixes for connection leaks, shared completion state and commands racing with ongoing queries. Several fixes also improve connection handling around destroy, failed rollbacks and acquiring connections, and the migration provider getters let kysely-ctl read the migration folder.
Changelog entry
- 0.30.0-beta.2: add transactionMode per-run, per-migration or none to Migrator and its methods. Release
- 0.29.7: controlled transaction commands wait for ongoing queries and streams; fix connection leaks and shared completion state. Release
- 0.28.18: maintenance release backporting 0.29 bug fixes and documentation improvements. Release
- Add Migrator.provider and FileMigrationProvider.migrationFolder getters. Pull request #2144
- Serialize controlled transaction commands with queries through the connection provider. Pull request #2081
- Release the controlled transaction connection when rollback fails. Pull request #2136
- Postgres: release the client when destroyed while acquiring a connection. Pull request #2088
- Docs: clarify shared pool and database instance lifecycles for destroy. Pull request #2143
- CI: add registry fallbacks and reuse the SQL Server image. Pull request #2140
- Bump dependencies. Pull request #2142
0.30.0-beta.2 is out with a new transactionMode option for Migrator: per-run, per-migration or none. Also shipped 0.29.7 and 0.28.18 with controlled transaction fixes: commands now wait for ongoing queries and streams, and connections are released when rollback fails or destroy r
Two releases and a beta this week. 0.30.0-beta.2 adds a new transactionMode option on Migrator and its methods, letting you choose per-run, per-migration or none. The 0.29.7 and 0.28.18 releases fix controlled transactions: commit, rollback and savepoint commands now wait for ongoing queries and streams to finish, shared completion state and connection leak issues are addressed, and connections are released when a rollback fails. The Postgres driver now releases the client if destroy runs while a connection is still being acquired, and the destroy docs clarify that shared or externally managed pools should not be destroyed. Migration providers also gained getters for reading the migration folder.
Week of October 5, 2026
What shipped
- Controlled transaction handles now share completion state, so the original handle reports the correct commit or rollback status after one handle commits. Pull request #2090
- The site respects reduced motion by showing the demo poster without requesting video until playback is pressed, and adds an accessible play and pause control. Pull request #2130
- Search now loads automatically when the browser is idle after page load, while clicking Search or pressing Cmd or Ctrl+K starts it immediately. Pull request #2101
- The homepage no longer downloads Prism, letting documentation chunks load the highlighter when needed. Pull request #2100
- The homepage now renders each testimonial once instead of three responsive copies, keeping the existing masonry placement. Pull request #2099
- PostgreSQL and MySQL test images are pulled from non-Docker Hub registries, with retries on pull rate limits. Pull request #2127
- The logging recipe now documents LogEvent as a discriminated union where query events may contain isStream and only error events contain error. Pull request #2121
- Testimonial cards dropped from 109 rendered cards for 37 quotes to one card per quote. Pull request #2099
- The type-generation guide now lists the built-in database families supported by the CLI and clarifies PGlite support. Pull request #2120
- Bun getting started examples enable the built-in SQLite dialect with documented better-sqlite3 and Bun versions. Pull request #2124
Why it matters
People using controlled transactions can now rely on completion flags being consistent across handles that share a connection, which fixes surprising query behavior after commit. On the site, the demo, search, and testimonial rendering are lighter and more accessible, so pages load usable content sooner. The documentation also gets more accurate notes on type generation, logging, Deno, and Bun SQLite.
Changelog entry
- Fix: controlled transaction handles now share completion state with the handle they were created from. Pull request #2090
- Site: respect reduced motion and add a keyboard-accessible play/pause control to the demo. Pull request #2130
- Site: load search when the browser is idle, or immediately on Search or Cmd/Ctrl+K. Pull request #2101
- Site: stop loading Prism on the homepage when snippets are pre-highlighted at build time. Pull request #2100
- Site: render each testimonial once instead of three responsive copies. Pull request #2099
- Site: improve hero audit text contrast in both themes. Pull request #2102
- Site: darken the light-mode accent for better contrast on links, buttons and labels. Pull request #2108
- Site: enlarge theme toggle touch targets and separate the system preference button. Pull request #2105
- Site: preserve testimonial avatar aspect ratios by preventing picture shrink. Pull request #2106
- CI: pull PostgreSQL and MySQL images from registries other than Docker Hub, with retries. Pull request #2127
- Docs: describe LogEvent as a discriminated union. Pull request #2121
- Docs: enable the built-in SQLite dialect in Bun getting started examples. Pull request #2124
This week: controlled transaction handles now share completion state. The site respects reduced motion, defers Prism and search, and renders each testimonial once. Docs got updates on LogEvent, type generation, and Bun SQLite.
This week in Kysely: controlled transaction handles now share their connection's completion state, so the original handle correctly reports isCommitted after a commit and no longer allows queries against a released connection. On the site, the demo respects reduced motion and shows the poster before hydration, Prism and search load later or on demand, and the homepage renders each testimonial once. Documentation updates cover the LogEvent union, CLI type-generation support, and Bun SQLite setup.
Week of September 28, 2026
What shipped
- Every page now includes SoftwareApplication JSON-LD structured data identifying Kysely with its description, links, license, and version. Pull request #2091
- Organization JSON-LD now links to Kysely's GitHub organization, X account, and Bluesky profile for explicit identity verification. Pull request #2093
- Documentation build now generates agent discovery catalogs in.well-known/ including ard.json and agent-skills index. Pull request #2094
- Missing pages requested with Accept: text/markdown now return HTTP 404 with Markdown explanation and link to llms.txt. Pull request #2089
- Proof wall audited with 47 of 59 entries refreshed, removing Stacks and adding Domain Locker as current usage examples. Pull request #2085
- Homepage now declares og:type: website in Open Graph metadata for better link preview handling. Pull request #2092
- Official Kysely LinkedIn company page added to Organization JSON-LD sameAs links. Pull request #2095
Why it matters
The site now provides machine-readable structured data for identity verification, discovery, and project information across multiple formats. This helps agents and services properly identify and understand Kysely while improving how the project is represented in search results and previews.
Changelog entry
- Docs: add software identity and maintainer contact structured data Pull request #2091
- Docs: link organization identity profiles in JSON-LD Pull request #2093
- Docs: generate agent discovery catalogs Pull request #2094
- Fix(site): serve Markdown 404 responses to agents Pull request #2089
- Docs: audit the proof wall and refresh usage evidence Pull request #2085
- Docs: declare Open Graph website type Pull request #2092
- Docs: add LinkedIn to organization structured data Pull request #2095
Documentation now includes structured data for identity verification, agent discovery catalogs, and Markdown 404 responses. The proof wall is refreshed with current usage examples.
We've enhanced kysely.dev with comprehensive structured data including SoftwareApplication and Organization JSON-LD, agent discovery catalogs, and Markdown support for specialized clients. The proof wall now reflects current production usage across 59 companies. These changes improve how Kysely is discovered and understood by services and agents.
Week of September 21, 2026
What shipped
- Fixed transaction connection leak when beginTransaction fails, ensuring the connection is released and the original error is rethrown. Pull request #2080
- Fixed MSSQL jsonBuildObject to properly escape JSON in both keys and values, preventing injection and character loss from quotes, backslashes, and control characters. Pull request #2079
- Fixed MSSQL jsonBuildObject key escaping to prevent SQL injection through apostrophes in object keys. Pull request #2078
- Reduced homepage Markdown size from 58,126 to 28,485 characters while preserving all 37 testimonials and homepage content. Pull request #2071
- Improved API reference discovery in generated documentation by adding named API reference entry with class, method, type, and code example descriptions. Pull request #2072
- Published robots.txt with crawling policy and sitemap reference for explicit indexing permission. Pull request #2074
- Replaced text comparison workflow with local afdocs checks for site change validation in CI. Pull request #2070
Why it matters
Two critical transaction and JSON escaping bugs were fixed this week for MSSQL users. Documentation discovery improvements and site optimization make it easier for developers and agents to find Kysely's API reference.
Changelog entry
- Fix: release controlled transaction connection when begin fails Pull request #2080
- Fix(mssql): escape JSON in jsonBuildObject Pull request #2079
- Fix(mssql): escape jsonBuildObject keys Pull request #2078
- Docs(site): improve API reference discovery Pull request #2072
- Docs(site): reduce homepage Markdown size Pull request #2071
Fixed transaction connection leak when beginTransaction fails. Fixed MSSQL jsonBuildObject key and value escaping to prevent injection attacks.
This week's Kysely releases fix critical bugs affecting MSSQL users: transaction connection leaks when beginTransaction fails and JSON escaping vulnerabilities in jsonBuildObject that could allow injection attacks. Documentation improvements make the API reference more discoverable.
Week of September 14, 2026
What shipped
- V0.30.0-beta.2 adds a new transactionMode property to Migrator supporting 'per-run', 'per-migration', or 'none' strategies. Release
- 0.29.6 fixes a bug allowing immutable columns in doUpdateSet's where clause and expands the proof wall with new projects. Release
- Conflict-update predicates now support immutable columns by using the full schema instead of the SET schema in doUpdateSet's where clause. Pull request #2043
- Generated documentation now includes all 13 category pages in llms.txt, achieving 100% coverage for agent discovery. Pull request #2069
- The site now serves Markdown files directly for requests with Accept: text/markdown header. Pull request #2066
- HTML comments are removed from generated Markdown to prevent content splitting and false parity issues. Pull request #2068
- A default 1200×630 social preview card is configured for the homepage and documentation pages. Pull request #2061
- The homepage title is now descriptive, showing 'Kysely — Type-safe SQL query builder for TypeScript' in search results and browser tabs. Pull request #2058
- Langfuse is added to the built-into proof wall, showing Kysely-backed query layer in use. Pull request #2054
- TrueForge is added to the built-into proof wall for its Kysely-backed SQLite and Postgres storage. Pull request #2055
Why it matters
This week delivers a beta of v0.30 with a new transactionMode feature for migration control, a v0.29.6 bugfix release, and significant documentation improvements for agent discoverability. The site changes ensure agents and search engines find documentation while fixing content generation issues.
Changelog entry
- V0.30.0-beta.2: Add transactionMode property to Migrator supporting 'per-run' | 'per-migration' | 'none' Release
- 0.29.6: Fix immutable columns in doUpdateSet where clause; expand proof wall with Cypress, Canton, Tailor, Supabase Release
- Fix: allow immutable columns in doUpdateSet's where by using full schema instead of SET schema Pull request #2043
- Fix(site): include all 13 category pages in agent documentation, achieving 100% llms.txt coverage Pull request #2069
- Fix(site): serve Markdown files for Accept: text/markdown requests with proper Content-Type header Pull request #2066
- Fix(site): remove HTML comments from generated Markdown to prevent content splitting Pull request #2068
- Docs: add default 1200×630 social preview card for homepage and documentation Pull request #2061
- Docs: set descriptive homepage title for search results and browser tabs Pull request #2058
- Docs: add Langfuse to proof wall showing Kysely-backed query layer Pull request #2054
0.30.0-beta.2 is out with a new transactionMode property for Migrator—choose between 'per-run', 'per-migration', or 'none'. Try it with pnpm i kysely@next
Kysely 0.30.0-beta.2 is available now. The release introduces a configurable transactionMode property for Migrator, letting you choose between 'per-run', 'per-migration', or 'none' strategies. This gives you finer control over transaction handling in migrations. Test it with pnpm i kysely@next and share feedback.