Beekeeper Studio Release Notes

What's Changed

• fix persistence guard by @azmy60 in #4645
• use config values instead of old globals by @not-night-but in #4642
• fix(sidebar): drag-and-drop reordering is discarded on the next render by @andreasarf in #4647
• Merge rc-60 into master by @github-actions[bot] in #4644
• Autocomplete defaults overhaul - restoring upper case by @rathboma in #4648
• table column widths are replaced by new tabs by @azmy60 in #4651
• only save persistence data if data has changed by @not-night-but in #4656
• Update bundled plugins when the app ships a newer version by @azmy60 in #4658

Full Changelog: v6.0.1...v6.0.4

Original source

What's Changed

• Use UI Kit Context Menu by @azmy60 in #4436
• Patch for share bugs by @azmy60 in #4626
• force folders to be alphabetically sorted by @azmy60 in #4625
• FEAT: Ask AI by @azmy60 in #4628
• fix ssh attempting to parse encrypted default keys by @not-night-but in #4622
• Decouple release publishing from build workflow by @rathboma in #4629
• Add per-path checkboxes to release publishing dispatch by @rathboma in #4635
• Merge rc-60 into master by @github-actions[bot] in #4623
• ci: never restore node_modules cache in release builds; key caches by runner image by @rathboma in #4638
• ugrade identifier in ui-kit by @not-night-but in #4634
• fix pageant on windows by @not-night-but in #4640
• fix save connection form showing up on new connection screen by @not-night-but in #4636
• remove duplicate import for config in utility.ts by @not-night-but in #4633
• Rc 60 by @rathboma in #4639

Full Changelog: v6.0.0...v6.0.1

Original source

🧚 Listen! Beekeeper Studio is a fast, modern, and open source database GUI

The standout feature for v6 is team collaboration v2! Full infinite depth folder trees, plus per-file and per-folder share settings make this the best Beekeeper Studio ever if you work on a team.

Hmm, what was that? Oh yes we are a little late releasing v6, it was due at the end of July, but you know what they say - good things come to those who wait.

Highlights

• Sharing and permissions for queries, connections, and folders.

  In a cloud workspace you can now decide who can view and who can edit each individual item, instead of a single team folder that everyone can edit. Set a general team access level (no access / can view / can edit), then add per-member grants on top. Access is inherited down the folder tree, owners always keep full access to their own items, and only owners (or workspace admins) can change sharing. Existing team items keep their old behavior and are upgraded seamlessly as you start using the new features.

• Folders infinite depth.

  Connections and saved queries use a new tree component with properly nested folders and simple drag-and-drop to move and reorder items. This combines with Beekeeper’s new sharing & permissions system to make a Google-Drive like experience, but for SQL. There’s nothing else like it available.

• StarRocks support.

  New StarRocks driver, so you can browse schemas and run queries against StarRocks the same way you do everywhere else.

Other Improvements

• Query edit history in local workspaces.

  Saved query version history — previously cloud-only — now works for local workspaces, so you can see past edits and restore an earlier version of a query.

• Import a directory of SQL files.

  The SQL import modal can now walk a whole directory recursively and recreate its folder structure as saved query folders, with an option to preserve or skip the root directory.

• Add a row from the grid itself.

  Right-click the empty space below the last row to add a new row, instead of hunting for the + button in the bottom corner.

• Kerberos (GSSAPI) authentication for MongoDB.

  Configured through the connection URL with authMechanism=GSSAPI, with friendlier errors when the ticket or SPN isn’t right. Requires a Business license and a working krb5 client.

• SSH config Include support.

  Include directives in ~/.ssh/config are now read in place, including glob patterns and paths relative to the config file. Thanks @Squidysquid1!

• “Select Top 100 Rows” in the table context menu.

  Right-click a table in the sidebar to drop a select top 100 query straight into the editor. Thanks @manos02!

• Plugin API: disabledFeatures on getConnectionInfo.

  Plugins (the ERD plugin especially) can now tell which features the connected database actually supports.

• Nicer tooltips.

  Keyboard shortcuts in tooltips are formatted properly, and connection and query tooltips show who created the item.

Everything Else

Another big thanks to the dozens of contributors who helped to make Beekeeper Studio better this month.

• Trino query errors are no longer swallowed and reported as empty results (#4499)
• Ctrl+Z no longer undoes several steps at once in the query editor (#4498)
• Postgres: SQL: Create now uses the selected overload for overloaded functions (#4551)
• Postgres dollar-quoted blocks are split correctly (sql-query-identifier 3.2.0) (#4592)
• Jump-to-last-page uses the filtered row count instead of the total (#4599)
• Manual table refresh re-fetches columns, so renames show up (#4590)
• SQL → SQL exports preserve the table’s column order (#4560)
• Row delete shortcuts work again on macOS (#4556)
• Grab/grabbing cursor on the column reorder handle (#4506)
• AND/OR operators repositioned in table filters (#4559)
• Fixed overlapping context menus in the data grid (#4539)
• Database dropdown hides the selected text while searching, and its icons no longer overlap on resize (#4532, #4507)
• Editor font size now applies to modal editors (#4510)
• Query elapsed timer shows the hours field at exactly one hour (#4612)
• JSON viewer escapes regex metacharacters when locating keys by path (#4613)
• Long error messages no longer make the status bar unusable (#4543)
• Delete confirmation shows the favorite’s title (#4547)
• Alert shown when folder creation is disabled (#4535)
• Folders that fail to load show an error instead of an empty “no items” state (#4610)
• Fixed sidebar overflow caused by tree item tooltips (#4619)
• Cloud sync fixes: only poll modules that are actually on screen, poll correctly on mount, don’t clear a new folder mid-poll, and handle remotely deleted items and merges (#4584, #4617)
• Fixed the import-from-local-workspace modals, and skip .git folders when importing (#4609, #4615)
• Fixed the last-used workspace not being restored (#4578)
• Azure CLI discovery and launch fixed on Windows (#4538). Thanks @jasonnutter!
• Improved AppImageLauncher detection (#4562)
• Swahili README translation (#4555). Thanks @cleven12!
• Docs: paste-as-new-rows, plugin view types, setDebugComms, plugin prerequisites, Snowflake moved to full support, SAP HANA listed as coming soon
• Dependency updates including Electron 39.8.10, dompurify, nanoid, js-yaml, axios, typeorm, tar, protobufjs, and undici

Original source

What's Changed

Workflow job to make sure we don't have rc branches with changes hidden from view by @rathboma in #4453

Merge rc-57 into master by @github-actions[bot] in #4454

ci: upgrade GitHub Actions off deprecated Node 20 runtime by @rathboma in #4458

chore(deps): bump js-yaml from 3.14.2 to 3.15.0 by @dependabot[bot] in #4445

Decouple snap publishing from build matrix by @rathboma in #4470

CI: Remove temporary branch from SQL Server Kerberos tests by @rathboma in #4473

Update ssh-config dependency to published version 5.2.0 by @rathboma in #4474

V5.9 release branch back to Master by @rathboma in #4452

Merge rc-59 into master by @github-actions[bot] in #4479

More kerberos by @rathboma in #4446

Query, connection, and folder sharing by @azmy60 in #4396

Move upgrading docs to /support/how-to-upgrade, keep old URL in the A/B funnel by @rathboma in #4496

Fix Ctrl+Z undoing multiple steps at once in the query editor by @muhammadusamahoyrr in #4498

Fix Trino query errors being swallowed as empty results by @muhammadusamahoyrr in #4499

fix: apply editor font size to modal editors (#4146) by @deeferentleeg in #4510

Position database dropdown icons absolutely by @manos02 in #4507

fix: show grab/grabbing cursor on table column reorder handle by @deeferentleeg in #4506

feat: query audit for the local workspace by @azmy60 in #4332

chore(deps): bump axios from 1.16.0 to 1.18.0 by @dependabot[bot] in #4514

Bump protobufjs from 7.6.4 to 7.6.5 by @dependabot[bot] in #4518

Bump brace-expansion from 1.1.12 to 1.1.16 by @dependabot[bot] in #4519

Bump brace-expansion from 1.1.11 to 2.1.2 in /apps/ui-kit/examples/react by @dependabot[bot] in #4521

Bump body-parser from 2.2.2 to 2.3.0 by @dependabot[bot] in #4523

Bump immutable from 4.3.8 to 4.3.9 by @dependabot[bot] in #4529

Bump tar from 7.5.16 to 7.5.21 by @dependabot[bot] in #4530

Bump fast-uri from 3.1.2 to 3.1.4 by @dependabot[bot] in #4531

chore(deps): bump shell-quote from 1.8.4 to 1.10.0 by @dependabot[bot] in #4533

Bump dompurify from 3.4.11 to 3.4.12 by @dependabot[bot] in #4527

Bump typeorm from 0.3.29 to 0.3.31 by @dependabot[bot] in #4528

chore(deps): bump postcss from 8.5.3 to 8.5.22 in /apps/ui-kit/examples/html by @dependabot[bot] in #4534

fix: hide selected dropdown text while searching by @AnandaBintang in #4532

Fix overlapping context menus in the data grid by @manos02 in #4539

Add "select top 100 rows: by @manos02 in #4524

show alert when folders are disabled by @azmy60 in #4535

Add support for ssh include directive by @Squidysquid1 in #4459

Add StarRocks by @azmy60 in #4367

fix too long error make status bar unusable by @kice in #4543

ui: change table edit trigger from double to single click by @mazzoccantelorenzo in #4504

ui: add context menu to table empty space for new row by @mazzoccantelorenzo in #4503

docs: document Paste as new rows by @drannonymousxx in #4544

fix: fix inability to discover or launch az cli on windows by @jasonnutter in #4538

fix: reposition AND/OR operators in table filters by @bnquon in #4559

chore(deps): bump brace-expansion from 1.1.16 to 1.1.18 by @dependabot[bot] in #4554

fix: show favorite title in delete confirmation by @ylyra in #4547

Fix/appimage launcher detection by @cynicalmindset in #4562

add disabledFeatures to getConnectionInfo by @azmy60 in #4561

feat: add Swahili (SW) README translation by @cleven12 in #4555

chore(deps): bump undici from 6.27.0 to 6.28.0 by @dependabot[bot] in #4566

fix: display formatted keybindings in tooltips by @bnquon in #4564

chore(deps): bump fast-uri from 3.1.4 to 3.1.5 by @dependabot[bot] in #4569

chore(deps): bump postcss from 8.5.22 to 8.5.25 in /apps/ui-kit/examples/html by @dependabot[bot] in #4568

fix(postgres): use selected overload for SQL: Create on overloaded functions by @AdityaBhosale22 in #4551

fix: preserve table column order in SQL->SQL exports by @bnquon in #4560

fix: restore table row delete shortcuts via config on macOS by @ylyra in #4556

Update prerequisites for creating a plugin by @Lucas-Tolle in #4574

Fix last used workspace, add author to connection and query tooltips by @azmy60 in #4578

Directory import by @not-night-but in #4571

Tree list for connections and queries by @azmy60 in #4502

Merge rc-60 into master by @github-actions[bot] in #4579

Update database support: Snowflake to full support, add SAP HANA by @rathboma in #4581

Enhance plugin views documentation with view types reference by @Lucas-Tolle in #4597

Enhance setDebugComms documentation by @Lucas-Tolle in #4596

fix: re-fetch table columns on manual table refresh to reflect renames by @YuriNachos in #4590

fix(table): use filtered count when jumping to last page by @ylyra in #4599

fix polling by @azmy60 in #4584

fix quick search connections and queries by @azmy60 in #4582

only poll cloud modules on the screen that shows them by @azmy60 in #4586

fix saving query payload and poll saved query by @not-night-but in #4588

fix tooltip display by @not-night-but in #4591

fix recursive import to local workspace by @not-night-but in #4593

add "no items" state to the folder by @azmy60 in #4587

fix new folder cleared by poll by @azmy60 in #4602

Polling breaks filtering by @azmy60 in #4603

Prevent users from restoring a version when there are pending remote by @azmy60 in #4604

fix save query title and folder by @not-night-but in #4605

Fix for being unable to close tabs by @rathboma in #4608

Fix import from local workspace modals by @not-night-but in #4609

skip .git folder in import by @not-night-but in #4615

fix query polling on mount if not active by @not-night-but in #4617

fix(deps): bump sql-query-identifier to ^3.2.0 for Postgres dollar-quote splitting by @YuriNachos in #4592

chore(deps): bump js-yaml from 3.15.0 to 3.15.1 by @dependabot[bot] in #4614

fix(editor): show hours field at exactly one hour in query elapsed timer by @YuriNachos in #4612

chore(deps): bump dompurify from 3.4.12 to 3.4.13 by @dependabot[bot] in #4601

chore(deps): bump nanoid from 3.3.12 to 3.3.18 by @dependabot[bot] in #4618

show error alert instead of "no items" by @azmy60 in #4610

rc-60 by @azmy60 in #4611

fix(json-viewer): escape regex metacharacters when locating keys by path by @YuriNachos in #4613

use title instead of v-tooltip to fix tree sidebar overflow by @azmy60 in #4619

chore(deps-dev): bump electron from 39.8.5 to 39.8.10 by @dependabot[bot] in #4580

New Contributors

@muhammadusamahoyrr made their first contribution in #4498

@deeferentleeg made their first contribution in #4510

@manos02 made their first contribution in #4507

@AnandaBintang made their first contribution in #4532

@kice made their first contribution in #4543

@mazzoccantelorenzo made their first contribution in #4504

@drannonymousxx made their first contribution in #4544

@jasonnutter made their first contribution in #4538

@bnquon made their first contribution in #4559

@ylyra made their first contribution in #4547

@cynicalmindset made their first contribution in #4562

@cleven12 made their first contribution in #4555

@AdityaBhosale22 made their first contribution in #4551

@Lucas-Tolle made their first contribution in #4574

@YuriNachos made their first contribution in #4590

Full Changelog: v5.9.3...v6.0.0

Original source

🧚 Listen! Beekeeper Studio is a fast, modern, and open source database GUI

Another month, another killer release for Beekeeper Studio. The highlights of this release are:

1. Snowflake Support - including all common enterprise auth methods
2. Kerberos Support for SQL Server - fully cross-platform via the MSSQL ODBC driver.
3. SSH auto-mode commpatibility improvements for SSH config

Snowflake Support

Snowflake is an enterprise ‘Big Data’ analytics warehouse (read: Expensive). It uses a columnar storage format to make sparse analytics queries very fast, even if you have petabytes of data. These types of databases are not the core competancy of Beekeeper Studio, but Snowflake is very popular and was one of our most requested features.

Enterprise authentication included

In addition to username & password login, Beekeeper Studio supports both serverless SSO authentication and MFA authentication (code or Duo) out of the box, so you can easily adhere to your organization’s information security policies.

Kerberos for SQL Server

While we already support SQL Server, v5.9 includes support for both Kerberos and Windows integrated auth (NTLM). We’ll be following this up with Kerberos support for other databases, because devs at big enterprises also deserve access to a fast, modern, and easy to use database GUI. :-).

SSH Automatic mode enhancements

Oh man, I gotta tell you that integrating properly with ssh-config files was harder than expected. The good news is that v5.9 fixes a bunch of issues we had with automatic SSH mode:

1. The app now follows the same resolution logic used by openssh to determine which key to use (when multiple are in the ssh-agent and ssh-config)
2. Beekeeper now properly skips keys that are listed in ssh-config, but are not present on disk
3. The app now evaluates Match/exec blocks in SSH config for host matching, but includes a security config option to disable this (see disableSshConfigMatchExec)

Also in this release

• Paste data as new rows. Copy a block of data from anywhere and paste it into a table as new rows instead of overwriting the cells you’ve selected — the quick way to port a chunk of data between tables without setting up a full import. There’s a dedicated keybinding, and backspace now clears a selected range as you’d expect.
• Pick enum values from a dropdown. Enum columns now offer their valid values in a dropdown right in the table and result grids, so you don’t have to remember or retype them. Works on PostgreSQL, CockroachDB, MySQL/MariaDB, DuckDB, and ClickHouse.
• One move-to dialog for everything. The move-to modal now handles saved queries and (sub)folders as well as connections, so you can reorganize the whole sidebar from one consistent dialog instead of a scatter of context-menu entries.
• Inline renaming in the sidebar. Rename queries, connections, and folders inline, right where they live.
• Plugin keyboard shortcuts. Plugin menu items can now be bound to custom keyboard shortcuts via the config file.
• New “unix timestamp” query magic. Convert a Unix timestamp (seconds, milliseconds, microseconds, or nanoseconds) to a readable date string, with timezone and ISO formatting options — e.g. columnname__format__unixtime__ms__utc.
• SSH tunneling for more engines. Fixed SSH tunneling for ClickHouse and Firebird, and added bastion/jump-host support for MongoDB (forcing directConnection so it actually works).
• ClickHouse custom SSL certificates. ClickHouse connections now support custom SSL certificates for encrypted connections. Thanks @mastercactapus!
• Sidebar remembers where you were. The last-open sidebar tab persists across restarts, and the default sidebar tab is configurable.

Full Change List

New Features

• Snowflake driver: connections, schema browsing, views/materialized views, keys, indexes, DDL retrieval, table cloning, transactional writes, streaming and cancellation (#4323)
• SQL Server integrated (Windows/Kerberos) authentication, with Encrypt toggle and optional SPN override (#4416, #4430)
• Paste copied data as new rows, with a dedicated keybinding; backspace clears a selected range (#4450)
• Select enum values from a dropdown — PostgreSQL, CockroachDB, MySQL/MariaDB, DuckDB, ClickHouse (#4444)
• Unified move-to dialog for connections, saved queries, and (sub)folders (#4448)
• Inline renaming of queries, connections, and folders in the sidebar (#4250)
• Plugin menu items support configurable keyboard shortcuts (#3837)
• New unix-timestamp query magic (#4401). Thanks @Squidysquid1!
• ClickHouse custom SSL certificate support (#4343). Thanks @mastercactapus!
• DynamoDB beta support and connection docs (#4298)
• Persist last-open sidebar tab across restarts; configurable default sidebar selection (#4440, #4447)

Bug Fixes

• Restoring the edited text of a saved query was broken (#4443)
• Auto-refresh now works when making table alterations from the query editor (#4442)
• BigQuery NUMERIC/BIGNUMERIC (and other custom-type) values now display correctly (#4391)
• SQL Server autocomplete handles bracket-quoted [identifiers] correctly (#4437)
• Editing a PostgreSQL array of enums no longer throws a JSON error (#4238)
• Newly added columns no longer become invisible when dragged to reorder (#4418). Thanks @aanthoonyy!
• Team subfolders show their own name instead of the parent’s (#4403)
• Query import clears the folder ID for correct personal-folder placement (#4406)
• Fixed two import bugs: a generateColumnTypesFromFile TypeError and a CSV error message (#4244)
• Paste a single value across all selected cells (#3972). Thanks @anabdsantos!
• Proper string escaping in the TableMenu copy actions (#4421). Thanks @Squidysquid1!
• Simplified delete context-menu wording (#4386)
• Reverted AppImage to the default runtime for AppImageLauncher compatibility

SSH

• Surface invalid/untrusted ssh config and missing identity files as non-blocking warning toasts (#4378 and related)
• Use ssh-config’s native Match exec support instead of stripping Match blocks
• New [security] allowSshConfigMatchExec option to control execution of Match exec directives
• Skip SSH tunnel entries with a missing IdentityFile (#4368)
• Fixed SSH tunneling for MongoDB, ClickHouse, and Firebird (#4435)

Security

• Fixed a plugin-manifest path-traversal vulnerability (GHSA-3wfm-5rhc-mg5c) that could trigger arbitrary recursive directory deletion on uninstall; plugin IDs are now validated and must match their install directory (#4393)
• Misc dependency vulnerability fixes (#4392)

Packaging & Platform

• Migrated Snap builds to electron-builder’s native core24 snapcraft config to fix broken snap builds (#4427)
• Switched Windows code signing from Azure to Google Cloud KMS (#4424)
• Upgraded electron-builder to 26.11.1 and configured the AppImage toolset (#4315), with follow-up toolset config cleanup (#4432)
• Fixed desktop-environment window association on Linux (#4429)

Internal / Tooling

• Migrated the TableSchemaValidation editor to the shared UI Kit text editor (#4327)
• Upgraded Vite to v8 (#4394)
• Upgraded the ERD library (#4364)
• Updated the Tabulator data-grid library (#4400)
• Structured plugin error classes/codes for better diagnostics (#3316)
• Extracted folder-tree logic into reusable utilities (#4408)
• Test/CI: pinned the ClickHouse Docker image to stop timeouts, static ed25519 SSH fixture, lightweight none-auth tunnel harness, dockerized Samba AD + SQL Server Kerberos stack, and regression tests for several utility bugs
• Dependency bumps: @babel/core, dompurify, fast-xml/builder, form-data, @grpc/grpc-js, protobufjs, qs, shell-quote, tmp, @tootallnate/once, typeorm, undici, vitest, ws

New Contributors

• @mastercactapus made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/4343
• @anabdsantos made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3972
• @SuperCowProducts made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/4409
• @aanthoonyy made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/4418
• @Squidysquid1 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/4401

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v5.8.1…v5.9.0

Original source

Beekeeper Studio 5.9.0

This is a big one. Snowflake support — which we've been teasing for a couple of releases — has finally landed, bringing our fully-featured driver count up another notch. SQL Server gets proper integrated (Windows/Kerberos) authentication, and there's a pile of everyday-workflow upgrades: paste copied data straight in as new rows, pick enum values from a dropdown, rename things inline in the sidebar, and move queries, folders, and connections around from a single dialog. On top of that there's a long tail of bug fixes, SSH and packaging improvements, and a security fix worth calling out.

Highlights

Snowflake support. Our long-awaited Snowflake driver is here. Connect with username/password, SSO via browser, or multi-factor auth (authenticator code or Duo push), with token caching where your account allows it. You get full schema browsing, views and materialized views, primary/foreign keys, index create/drop, create-script (DDL) retrieval, table cloning, and transactional inserts/updates/deletes — plus streaming and cancellation for big queries. The connection form takes your account ID, default database, and warehouse, and there's a read-only mode for locked-down environments.

SQL Server integrated (Windows/Kerberos) authentication. Connect to your SQL Server using either integrated Windows auth, or Kerberos. Kerberos authentication works across all three operating systems (although it sometimes requires system-wide libraries installed).

Notable Improvements

Paste data as new rows. Copy a block of data from anywhere and paste it into a table as new rows instead of overwriting the cells you've selected — the quick way to port a chunk of data between tables without setting up a full import. There's a dedicated keybinding, and backspace now clears a selected range as you'd expect.

Pick enum values from a dropdown. Enum columns now offer their valid values in a dropdown right in the table and result grids, so you don't have to remember or retype them. Works on PostgreSQL, CockroachDB, MySQL/MariaDB, DuckDB, and ClickHouse.

One move-to dialog for everything. The move-to modal now handles saved queries and (sub)folders as well as connections, so you can reorganize the whole sidebar from one consistent dialog instead of a scatter of context-menu entries.

Inline renaming in the sidebar. Rename queries, connections, and folders inline, right where they live.

Plugin keyboard shortcuts. Plugin menu items can now be bound to custom keyboard shortcuts via the config file.

New "unix timestamp" query magic. Convert a Unix timestamp (seconds, milliseconds, microseconds, or nanoseconds) to a readable date string, with timezone and ISO formatting options — e.g. columnname__format__unixtime__ms__utc.

Smarter SSH config handling. Previously-silent ~/.ssh/config problems now surface as non-blocking warning toasts on connect/test (unparseable config, bad ownership/permissions, or a missing IdentityFile in agent mode). SSH tunnels now skip entries with a missing IdentityFile, and Beekeeper uses ssh-config's native Match exec handling instead of stripping Match blocks by hand. A new [security] allowSshConfigMatchExec option (default true, matching ssh(1)) lets you disable execution of Match exec directives.

SSH tunneling for more engines. Fixed SSH tunneling for ClickHouse and Firebird, and added bastion/jump-host support for MongoDB (forcing directConnection so it actually works).

ClickHouse custom SSL certificates. ClickHouse connections now support custom SSL certificates for encrypted connections. Thanks @mastercactapus!

DynamoDB is now in beta. DynamoDB moves from planned to beta support, with a new connection guide covering IAM auth and local-endpoint configuration.

Sidebar remembers where you were. The last-open sidebar tab persists across restarts, and the default sidebar tab is configurable.

Full Change List

New Features

Snowflake driver: connections, schema browsing, views/materialized views, keys, indexes, DDL retrieval, table cloning, transactional writes, streaming and cancellation (#4323)

SQL Server integrated (Windows/Kerberos) authentication, with Encrypt toggle and optional SPN override (#4416, #4430)

Paste copied data as new rows, with a dedicated keybinding; backspace clears a selected range (#4450)

Select enum values from a dropdown — PostgreSQL, CockroachDB, MySQL/MariaDB, DuckDB, ClickHouse (#4444)

Unified move-to dialog for connections, saved queries, and (sub)folders (#4448)

Inline renaming of queries, connections, and folders in the sidebar (#4250)

Plugin menu items support configurable keyboard shortcuts (#3837)

New unix-timestamp query magic (#4401). Thanks @Squidysquid1!

ClickHouse custom SSL certificate support (#4343). Thanks @mastercactapus!

DynamoDB beta support and connection docs (#4298)

Persist last-open sidebar tab across restarts; configurable default sidebar selection (#4440, #4447)

Bug Fixes

Restoring the edited text of a saved query was broken (#4443)

Auto-refresh now works when making table alterations from the query editor (#4442)

BigQuery NUMERIC/BIGNUMERIC (and other custom-type) values now display correctly (#4391)

SQL Server autocomplete handles bracket-quoted [identifiers] correctly (#4437)

Editing a PostgreSQL array of enums no longer throws a JSON error (#4238)

Newly added columns no longer become invisible when dragged to reorder (#4418). Thanks @aanthoonyy!

Team subfolders show their own name instead of the parent's (#4403)

Query import clears the folder ID for correct personal-folder placement (#4406)

Fixed two import bugs: a generateColumnTypesFromFile TypeError and a CSV error message (#4244)

Paste a single value across all selected cells (#3972). Thanks @anabdsantos!

Proper string escaping in the TableMenu copy actions (#4421). Thanks @Squidysquid1!

Simplified delete context-menu wording (#4386)

Reverted AppImage to the default runtime for AppImageLauncher compatibility

SSH

Surface invalid/untrusted ssh config and missing identity files as non-blocking warning toasts (#4378 and related)

Use ssh-config's native Match exec support instead of stripping Match blocks

New [security] allowSshConfigMatchExec option to control execution of Match exec directives

Skip SSH tunnel entries with a missing IdentityFile (#4368)

Fixed SSH tunneling for MongoDB, ClickHouse, and Firebird (#4435)

Security

Fixed a plugin-manifest path-traversal vulnerability (GHSA-3wfm-5rhc-mg5c) that could trigger arbitrary recursive directory deletion on uninstall; plugin IDs are now validated and must match their install directory (#4393)

Misc dependency vulnerability fixes (#4392)

Packaging & Platform

Migrated Snap builds to electron-builder's native core24 snapcraft config to fix broken snap builds (#4427)

Switched Windows code signing from Azure to Google Cloud KMS (#4424)

Upgraded electron-builder to 26.11.1 and configured the AppImage toolset (#4315), with follow-up toolset config cleanup (#4432)

Fixed desktop-environment window association on Linux (#4429)

Internal / Tooling

Migrated the TableSchemaValidation editor to the shared UI Kit text editor (#4327)

Upgraded Vite to v8 (#4394)

Upgraded the ERD library (#4364)

Updated the Tabulator data-grid library (#4400)

Structured plugin error classes/codes for better diagnostics (#3316)

Extracted folder-tree logic into reusable utilities (#4408)

Test/CI: pinned the ClickHouse Docker image to stop timeouts, static ed25519 SSH fixture, lightweight none-auth tunnel harness, dockerized Samba AD + SQL Server Kerberos stack, and regression tests for several utility bugs

Dependency bumps: @babel/core, dompurify, fast-xml/builder, form-data, @grpc/grpc-js, protobufjs, qs, shell-quote, tmp, @tootallnate/once, typeorm, undici, vitest, ws

New Contributors

@mastercactapus made their first contribution in #4343

@anabdsantos made their first contribution in #3972

@SuperCowProducts made their first contribution in #4409

@aanthoonyy made their first contribution in #4418

@Squidysquid1 made their first contribution in #4401

Full Changelog: v5.8.1...v5.9.0

Original source