Beekeeper Studio Release Notes

What's Changed

Fix SSH agent mode attempting to read non-existent private key files by @rathboma in #4194

chore(deps): bump @xmldom/xmldom from 0.8.12 to 0.8.13 by @dependabot[bot] in #4156

chore(deps): bump follow-redirects from 1.15.11 to 1.16.0 by @dependabot[bot] in #4097

add [DEV] Make Fake Remote Change context menu item to query editor by @azmy60 in #4176

fix context menu showing on non-text inputs by @azmy60 in #4191

Disable write action shortcuts in readonly mode by @not-night-but in #4198

fix(autocomplete): suggest columns for quoted tables and joins by @rathboma in #4203

Fix clickhouse rawExecuteQuery by @not-night-but in #4207

chore: add BaseModal wrapper component by @azmy60 in #4131

fix: preserve column layout when refreshing table by @azmy60 in #4211

Prevent calling persistence write function before the table is ready by @azmy60 in #4209

Support SSH config file resolution for host aliases by @rathboma in #4195

Use saved connection details in recent connections list by @rathboma in #4190

Fix page navigation when focusing editable elements by @rathboma in #4210

fix(table): show loading spinner instead of 'No Data' while fetching by @NianJiuZst in #4180

Add driver dependency auto-download framework by @rathboma in #4018

fix: persist tabulator column state in app.db instead of localStorage by @azmy60 in #4160

fix bastion host background and padding by @azmy60 in #4201

fix double encoded jsonb values when inserting a new row from table view by @azmy60 in #4222

remove ssh tests that no longer make sense by @not-night-but in #4224

Refresh yarn.lock to clear high-severity transitive vulns by @rathboma in #4227

Bump deps to clear undici, flatted, and other parent-locked alerts by @rathboma in #4228

Cache playwright browsers in e2e workflows by @rathboma in #4230

fix(cassandra): convert UUIDs in set and map collections to strings by @andreasarf in #4220

Trim e2e PR trigger, add concurrency, bump old checkout actions by @rathboma in #4233

fix: two silent bugs in SQL change builders (Cassandra rename + DuckDB column type quoting) by @rathboma in #4239

fix models that don't scroll when there are too many items by @rathboma in #4242

chore(deps): bump @babel/plugin-transform-modules-systemjs from 7.29.0 to 7.29.4 by @dependabot[bot] in #4237

Fix trial license support date expiration condition by @rathboma in #4252

chore(deps): bump @protobufjs/utf8 from 1.1.0 to 1.1.1 by @dependabot[bot] in #4245

chore(deps): bump protobufjs from 7.5.5 to 7.5.8 by @dependabot[bot] in #4249

Add AI Shell upsell card with animated preview by @rathboma in #4255

link to the proper docs page and add some tips for az by @not-night-but in #4253

fix: always allow selecting local workspace on connection screen by @rathboma in #4267

Fix export progress showing NaN and >100% percentages by @rathboma in #4254

upgrade modal style redo by @rathboma in #4270

Use the new upgrade panel everywhere by @rathboma in #4271

Query Edit History by @azmy60 in #4217

Add Amazon DynamoDB driver by @rathboma in #4120

fix: update greengage docs icon by @v-astakhov in #4284

Fix: named query params clobbered when the same parameter appears multiple times by @rathboma in #4264

Backup tests by @not-night-but in #4280

fix(mongo): add aws4 dep to fix MONGODB-AWS auth by @jim-fn in #4263

Fix yarn lint to actually lint by @rathboma in #4229

Update Identifier by @not-night-but in #4295

Feature: Show empty connection folders even when no connections exist by @vaibhavvikas in #4257

test(db): expand common driver coverage (Part A audit) by @rathboma in #4204

Add security exploit tests for shell execution vulnerabilities by @rathboma in #4213

Fix ESLint rules and code quality issues by @rathboma in #4293

chore(deps): bump uuid from 10.0.0 to 11.1.1 by @dependabot[bot] in #4290

chore(deps): bump ws from 8.19.0 to 8.20.1 by @dependabot[bot] in #4281

chore(deps): bump js-cookie from 3.0.5 to 3.0.7 by @dependabot[bot] in #4291

Improve idle detection by combining system and app input tracking by @rathboma in #4174

New Contributors

@NianJiuZst made their first contribution in #4180

@andreasarf made their first contribution in #4220

@jim-fn made their first contribution in #4263

@vaibhavvikas made their first contribution in #4257

Full Changelog: v5.7.1...v5.8.0-beta.1

Original source

Wow, this release got a little out of hand. Two major features and a looooot of bug fixes and tweaks in this release.

Headline Features

Folders for saved connections and saved queries. You can create folders and subfolders, drag-and-drop to reorder, pin and unpin, right-click for the common actions, and the expand/collapse state sticks across restarts. Fixes #799, #2981, #65.

Editable query results. Tweak data directly from the results of a SQL query - no more jumping over to the table view just to fix a typo. We analyze the SQL and map the result columns back to their source tables. Works alongside manual commit mode, and the Apply/Discard controls behave consistently with table edits. Fixes #3191, #2429.

New Database Support

BedrockDB from Expensify, which is a sharded SQLite behind a MySQL proxy.

ScyllaDB connection support with docs and integration tests.

Greengage (Postgres fork) integration.

DuckDB is out of beta.

Smaller Improvements

CockroachDB JWT auth. Lightweight JWT authentication with a re-prompt on new connections. Picked from the auth method dropdown. Thanks @hector833!

Windows Pageant agent forwarding works again. This was broken for folks using PuTTY's agent for SSH tunnel keys. Thanks @jeffcaiz!

SSH auth mode switching no longer leaks stale credentials when you flip between modes.

URL-encoded credentials are now decoded correctly when pasting connection URLs. Fixes #3840.

Redis connection URLs now accept redis:// and rediss:// schemes.

Folders for workspaces can now be deleted from inside the app (Cloud), so you don't have to hop over to the web dashboard for housekeeping. Fixes #1317.

Plugin system controls for admins. New [pluginSystem] config section lets you disable the plugin system entirely, disable community plugins only, or pin an allowlist of permitted plugin ids. Bundled first-party plugins keep working when the system is off. Fixes #3859.

Onboarding notification for new users to make it easier to find the getting-started guide. Fixes #3583.

Bug Fixes

SQL Server: dotted table names (e.g. dbo.my.table) are now bracket-wrapped on export so they don't get mis-split. Fixes #3722.

MySQL: CHARACTER SET and COLLATE clauses are stripped from non-string ALTER statements.

MySQL: friendlier error text when you hit "access denied for user".

Oracle: fixed a crash in the utility process when the thick client hit a connection retry, and fixed connecting through an SSH tunnel.

Cassandra: the driver client now shuts down cleanly on disconnect.

Mac: delete row keyboard shortcut works again. Fixes #3629.

Delete multiple selected rows is fixed. Fixes #3550.

Add relations shortcut no longer also adds a column. Fixes #3521.

Copy column name from the sidebar was copying the table name. Fixed.

Structural table cells now have right-click copy.

JSON viewer search is now case-insensitive. Fixes #3547.

SQL export converts bit column values to integers. Fixes #3673.

Drag handle cursor now shows grab on hover. Fixes #3165.

Drag-and-drop to root in the connection list works correctly, with visual feedback when a move completes.

Imported connections land in the personal folder rather than at an ambiguous root.

Auto-disconnect now notifies you when it happens, so you're not left wondering why a query failed.

Mac menu icons render correctly (fixed by assigning proper roles), and the app menu order on non-Mac platforms is also tidied up.

Bastion/jump host config is tucked into an expandable section so the connection form is less noisy, with a missing config added back.

Flatpak users get a platform warning system explaining file permission behavior, plus SQLite-specific docs.

Pin/unpin and duplicate are now available as right-click actions on connections and queries.

Under the Hood

CI: ARM64 builds moved from self-hosted to GitHub-hosted runners. node_modules is now cached across test, build, and Windows jobs, which should speed up pipelines noticeably.

Windows integration tests now cover Pageant agent forwarding end-to-end.

Bedrock integration tests are wired up via testcontainers.

Security: doc updates plus a pile of dependency bumps (handlebars, dompurify, node-forge, brace-expansion, protobufjs, basic-ftp, axios, rollup, lodash, electron, happy-dom, ajv, qs, yaml, path-to-regexp, @xmldom/xmldom, picomatch, tar-fs).

AWS SDK packages upgraded to drop the fast-xml-parser advisory.

trino-client updated to clear the axios advisory.

Electron bumped to 39.8.5.

Thank You to Our Contributors!

Big thanks to the community folks who sent PRs for this release, including @hector833 (CockroachDB JWT), @jeffcaiz (Pageant fix), @andrii-kysylevskyi (ScyllaDB), @v-astakhov (Greengage), @ManelRibeiro, @boergeson, @austinwilcox, @PedroBarataIST, @antoniogmello, @yogasw, @scrlkx, and everyone else who filed issues and helped us track things down.

What's Changed

Update workflow permissions by @not-night-but in #3911

Rc 56 by @not-night-but in #3912

chore(deps): bump rollup from 3.29.5 to 3.30.0 in /apps/ui-kit/examples/html by @dependabot[bot] in #3909

Bump rollup from 4.40.0 to 4.59.0 in /apps/ui-kit/examples/react by @dependabot[bot] in #3914

chore(deps): bump basic-ftp from 5.0.5 to 5.2.0 by @dependabot[bot] in #3908

chore(deps): bump qs from 6.14.1 to 6.14.2 by @dependabot[bot] in #3878

add permissions to all workflows by @not-night-but in #3913

chore(deps): bump ajv from 6.12.6 to 6.14.0 by @dependabot[bot] in #3896

Rc 56 by @not-night-but in #3925

docs: remove anchor/span wrapping from code blocks for clipboard compatibility by @scrlkx in #3862

Rc 56 by @not-night-but in #3942

feat: folder support for saved connections and queries by @rathboma in #3903

Feature/1317 delete workspace by @wmontgomery in #3820

Rc 56 by @rathboma in #3955

feat: support redis:// and rediss:// protocol schemes by @yogasw in #3948

remove component resolver by @not-night-but in #3915

Bump immutable from 4.3.7 to 4.3.8 by @dependabot[bot] in #3944

chore(deps): bump dompurify from 3.2.4 to 3.3.2 by @dependabot[bot] in #3950

ci: cache node_modules across test jobs to speed up CI by @rathboma in #3952

Rc 56 by @not-night-but in #3963

Fix SSH auth mode switch leaking stale credentials by @azmy60 in #3974

Update RDS Docs by @not-night-but in #3966

Fix #3550: fix deleting multiple selected rows by @PedroBarataIST in #3967

chore(deps): bump rollup from 2.79.2 to 2.80.0 by @dependabot[bot] in #3977

update tarfs to patched version by @not-night-but in #3978

upgrade brace-expansion by @not-night-but in #3979

Update supported databases in README files by @github-actions[bot] in #3969

feat: implement greengage integration by @v-astakhov in #3945

fix: URL-encoded passwords, bit(1) SQL export NaN, case-sensitive JSON search by @rathboma in #3990

chore(deps): bump picomatch from 2.3.1 to 2.3.2 by @dependabot[bot] in #4000

chore(deps): bump picomatch from 2.3.1 to 2.3.2 in /apps/ui-kit/examples/react by @dependabot[bot] in #4001

chore(deps): bump yaml from 2.7.0 to 2.8.3 by @dependabot[bot] in #4004

chore(deps): bump brace-expansion from 1.1.11 to 1.1.12 by @dependabot[bot] in #4005

reorder app menu by @azmy60 in #3996

chore(deps-dev): bump happy-dom from 20.0.10 to 20.8.8 by @dependabot[bot] in #4007

chore(deps): bump path-to-regexp from 8.3.0 to 8.4.0 by @dependabot[bot] in #4021

chore(deps): bump node-forge from 1.3.3 to 1.4.0 by @dependabot[bot] in #4017

chore(deps): bump brace-expansion from 1.1.12 to 1.1.13 by @dependabot[bot] in #4016

chore(deps-dev): bump happy-dom from 20.8.8 to 20.8.9 by @dependabot[bot] in #4022

fix oracle connection using ssh tunnel by @azmy60 in #4026

Add troubleshooting docs for cloud IP allowlist idle timeout by @rathboma in #4029

fix menu for platforms other than mac by @not-night-but in #4036

Add Flatpak detection and config-driven platform warnings by @rathboma in #4034

Add Flatpak file permission docs for SQLite users by @rathboma in #4030

add missing bastion config by @azmy60 in #3988

Add menu icons for macOS by assigning the role to some menu items by @azmy60 in #3998

fix #3629: fix delete row command on Mac by @antoniogmello in #4025

chore(deps): bump @xmldom/xmldom from 0.8.10 to 0.8.12 by @dependabot[bot] in #4037

chore(deps): bump lodash from 4.17.23 to 4.18.1 by @dependabot[bot] in #4047

chore(deps-dev): bump electron from 39.5.2 to 39.8.4 by @dependabot[bot] in #4048

fix: change cursor to grab on drag handle hover by @boergeson in #4045

update vim docs by @austinwilcox in #4050

Add right-click copy to structural table cells by @boergeson in #4049

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

Fix Copy Name on sidebar columns copying table name by @boergeson in #4057

Rc 56 by @azmy60 in #4063

chore(deps): bump basic-ftp from 5.2.0 to 5.2.1 by @dependabot[bot] in #4076

onboarding notification by @azmy60 in #3587

Fix password getter by @not-night-but in #3916

Aws dependabot fixes by @rathboma in #4080

[CHORE] Add cross-platform E2E smoke tests by @JeanPaiva42 in #3919

chore(deps): bump basic-ftp from 5.2.1 to 5.2.2 by @dependabot[bot] in #4084

Fix Oracle thick client crashing utility process on connection retry by @rathboma in #4028

Fix surreal by @not-night-but in #3999

ci: migrate ARM64 CI to GitHub-hosted runners by @rathboma in #3956

Fix #3521 : Add relations shortcut is also adding a column by @ManelRibeiro in #3959

fix: Windows Pageant SSH agent forwarding silently fails since v3.9.0 by @jeffcaiz in #4093

feat: Add CockroachDB JWT connection support by @hector833 in #4039

Update supported databases in README files by @github-actions[bot] in #4098

Fix fuzzy search by @not-night-but in #4104

troubleshoot mysql access denied for user by @azmy60 in #4106

Feat/editable results by @not-night-but in #3964

chore(deps): bump dompurify from 3.3.3 to 3.4.0 by @dependabot[bot] in #4105

Pr bedrock support by @rathboma in #4101

[3661] Added ScyllaDB docs and runner by @andrii-kysylevskyi in #3662

Add Windows integration test for Pageant agent forwarding by @rathboma in #4099

Support disabling community plugins and plugin system entirely by @azmy60 in #3894

Plugin System 1.0 Docs by @azmy60 in #3541

Notify user when auto-disconnected for idle/lock/suspend by @rathboma in #4112

chore(deps): bump basic-ftp from 5.1.0 to 5.3.0 by @dependabot[bot] in #4113

chore(deps): bump protobufjs from 7.5.4 to 7.5.5 by @dependabot[bot] in #4114

chore(deps): bump handlebars from 4.7.8 to 4.7.9 by @dependabot[bot] in #4110

Update supported databases in README files by @github-actions[bot] in #4111

Code Style Guide: Input by @azmy60 in #4066

fix(mysql): strip CHARACTER SET and COLLATE from non-string ALTER by @rathboma in #4121

fix(mssql): bracket-wrap qualified names so dotted table names aren't mis-split by @rathboma in #4122

Fix flaky e2e tests by @not-night-but in #4081

Fix idle-disconnect notifications firing on every interval tick by @rathboma in #4133

Fix license check loop creating duplicate rows by @rathboma in #4132

Fix read-only editor context menu by @azmy60 in #4137

Some editing fixes by @not-night-but in #4136

Fix unit tests by @not-night-but in #4165

make it clear that "editing result mode" is activated by @azmy60 in #4138

Prevent duplicate folder names within the same parent by @rathboma in #4163

Feature/4065 privacy mode by @wmontgomery in #4090

fix: include PKs in demo query so Edit Data works (#4141) by @rathboma in #4166

Fix logo import in NotificationManager component by @rathboma in #4167

Validate SavedConnection name field is not empty by @rathboma in #4168

Remove MongoDB alpha warning and update documentation by @rathboma in #4173

Add a shortcut for json viewer and search field in the shortcuts modal by @azmy60 in #4159

letter-spacing makes titles look off by @azmy60 in #4169

Docs for editable query results by @not-night-but in #4175

Add safeOpenExternal to prevent RCE via file:// URLs by @rathboma in #4181

only allow official plugins for now by @azmy60 in #4183

bump @beekeeperstudio/bks-ai-shell to 3.0.9 by @azmy60 in #4179

remove popup by @not-night-but in #4184

disable entire plugin system, and whitelist bundled plugins by @azmy60 in #4187

disable in read only mode, don't kick out of edit mode on apply by @not-night-but in #4186

Feature/1679 run all to run current by @wmontgomery in #3985

New Contributors

@scrlkx made their first contribution in #3862

@yogasw made their first contribution in #3948

@PedroBarataIST made their first contribution in #3967

@antoniogmello made their first contribution in #4025

@boergeson made their first contribution in #4045

@ManelRibeiro made their first contribution in #3959

@jeffcaiz made their first contribution in #4093

@hector833 made their first contribution in #4039

@andrii-kysylevskyi made their first contribution in #3662

Full Changelog: v5.6.5...v5.7.1

Original source

Wow, this release got a little out of hand. Two major features and a looooot of bug fixes and tweaks in this release.

Headline Features

• Folders for saved connections and saved queries. You can create folders and subfolders, drag-and-drop to reorder, pin and unpin, right-click for the common actions, and the expand/collapse state sticks across restarts.

• Editable query results. Tweak data directly from the results of a SQL query - no more jumping over to the table view just to fix a typo. We analyze the SQL and map the result columns back to their source tables. Works alongside manual commit mode, and the Apply/Discard controls behave consistently with table edits.

New Database Support

• BedrockDB from Expensify, which is a sharded SQLite behind a MySQL proxy.
• ScyllaDB connection support with docs and integration tests.
• Greengage (Postgres fork) integration.
• DuckDB is out of beta.

Smaller Improvements

• CockroachDB JWT auth. Lightweight JWT authentication with a re-prompt on new connections. Picked from the auth method dropdown. Thanks @hector833!
• Windows Pageant agent forwarding works again. This was broken for folks using PuTTY’s agent for SSH tunnel keys. Thanks @jeffcaiz!
• SSH auth mode switching no longer leaks stale credentials when you flip between modes.
• URL-encoded credentials are now decoded correctly when pasting connection URLs. Fixes #3840.
• Redis connection URLs now accept redis:// and rediss:// schemes.
• Folders for workspaces can now be deleted from inside the app (Cloud), so you don’t have to hop over to the web dashboard for housekeeping. Fixes #1317.
• Plugin system controls for admins. New [pluginSystem] config section lets you disable the plugin system entirely, disable community plugins only, or pin an allowlist of permitted plugin ids. Bundled first-party plugins keep working when the system is off. Fixes #3859.
• Onboarding notification for new users to make it easier to find the getting-started guide. Fixes #3583.

Bug Fixes

• SQL Server: dotted table names (e.g. dbo.my.table) are now bracket-wrapped on export so they don’t get mis-split. Fixes #3722.
• MySQL: CHARACTER SET and COLLATE clauses are stripped from non-string ALTER statements.
• MySQL: friendlier error text when you hit “access denied for user”.
• Oracle: fixed a crash in the utility process when the thick client hit a connection retry, and fixed connecting through an SSH tunnel.
• Cassandra: the driver client now shuts down cleanly on disconnect.
• Mac: delete row keyboard shortcut works again. Fixes #3629.
• Delete multiple selected rows is fixed. Fixes #3550.
• Add relations shortcut no longer also adds a column. Fixes #3521.
• Copy column name from the sidebar was copying the table name. Fixed.
• Structural table cells now have right-click copy.
• JSON viewer search is now case-insensitive. Fixes #3547.
• SQL export converts bit column values to integers. Fixes #3673.
• Drag handle cursor now shows grab on hover. Fixes #3165.
• Drag-and-drop to root in the connection list works correctly, with visual feedback when a move completes.
• Imported connections land in the personal folder rather than at an ambiguous root.
• Auto-disconnect now notifies you when it happens, so you’re not left wondering why a query failed.
• Mac menu icons render correctly (fixed by assigning proper roles), and the app menu order on non-Mac platforms is also tidied up.
• Bastion/jump host config is tucked into an expandable section so the connection form is less noisy, with a missing config added back.
• Flatpak users get a platform warning system explaining file permission behavior, plus SQLite-specific docs.
• Pin/unpin and duplicate are now available as right-click actions on connections and queries.

Under the Hood

• CI: ARM64 builds moved from self-hosted to GitHub-hosted runners. node_modules is now cached across test, build, and Windows jobs, which should speed up pipelines noticeably.
• Windows integration tests now cover Pageant agent forwarding end-to-end.
• Bedrock integration tests are wired up via testcontainers.
• Security: doc updates plus a pile of dependency bumps (handlebars, dompurify, node-forge, brace-expansion, protobufjs, basic-ftp, axios, rollup, lodash, electron, happy-dom, ajv, qs, yaml, path-to-regexp, @xmldom/xmldom, picomatch, tar-fs).
• AWS SDK packages upgraded to drop the fast-xml-parser advisory.
• trino-client updated to clear the axios advisory.
• Electron bumped to 39.8.5.

Thank You to Our Contributors!

Big thanks to the community folks who sent PRs for this release, including @hector833 (CockroachDB JWT), @jeffcaiz (Pageant fix), @andrii-kysylevskyi (ScyllaDB), @v-astakhov (Greengage), @ManelRibeiro, @boergeson, @austinwilcox, @PedroBarataIST, @antoniogmello, @yogasw, @scrlkx, and everyone else who filed issues and helped us track things down.

Original source