Beekeeper Studio Release Notes

What's Changed

• Fixes for table issues by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4787
• tables don't use Command key in macOS by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4789
• Start editing a cell by typing into it by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4805
• upgrade tabulator 6.6.0 by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4820
• Persist table copy highlights by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4803
• enable selectableRangeFill by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4806
• fix styles for edited cells when in a range selection by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4817
• fix cannot paste with keyboard shortcut in result table by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4822
• fix marking as edited when dragging a range by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4826
• fix result table columns resizing by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4829
• Fix more table issues by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4831
• remove old readonly license check by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4832 …

What's Changed

• Add transient IDs for tabs on unsaved connections by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4807
• add option to enable cleartext by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4780

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v6.1.2...v6.1.4

What's Changed

• fix trigger preventing queries from being deleted by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4760
• Fix ssh tunnels when IdentityFile points to a public key only by @lode in https://github.com/beekeeper-studio/beekeeper-studio/pull/4761

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v6.1.0...v6.1.1

Bit of a smaller release focused on some maintenance, but to tide you over we have made Folders and Read Only Mode community features!

What's Changed

• Merge rc-60 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4659
• Respect column visibility when generating table queries by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4663
• fix(tabletable): make Add row reachable via right-click when table is full by @Fraianni in https://github.com/beekeeper-studio/beekeeper-studio/pull/4667
• Block cloud workspace access for lifetime licenses by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4646
• add updated by status to query editor by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4660
• Merge rc-60 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4671
• fix: add empty state to quick switcher panel (#4150) by @ChihebBENCHEIKH1 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4155
• Phantom tabs by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4675
• SQLite and LibSQL flakiness fixes (hopefully) by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4679
• Enhancements to Table Properties tab by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4670 …

What's Changed

• Merge rc-60 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4659
• Respect column visibility when generating table queries by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4663
• fix(tabletable): make Add row reachable via right-click when table is full by @Fraianni in https://github.com/beekeeper-studio/beekeeper-studio/pull/4667
• Block cloud workspace access for lifetime licenses by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4646
• add updated by status to query editor by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4660
• Merge rc-60 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4671
• fix: add empty state to quick switcher panel (#4150) by @ChihebBENCHEIKH1 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4155
• Phantom tabs by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4675
• SQLite and LibSQL flakiness fixes (hopefully) by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4679
• Enhancements to Table Properties tab by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4670
• Vim mode: fix focus, ex commands, and .beekeeper.vimrc by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4669 …

What's Changed

• Fix typing transaction commands in manual commit by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4664
• fix(ssh): treat agent errors as non-fatal so publickey auth can proceed by @stephaneminisini-fps in https://github.com/beekeeper-studio/beekeeper-studio/pull/4681

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v6.0.4...v6.0.5

What's Changed

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

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v6.0.1...v6.0.4

What's Changed

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

What's Changed

• Workflow job to make sure we don't have rc branches with changes hidden from view by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4453
• Merge rc-57 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4454
• ci: upgrade GitHub Actions off deprecated Node 20 runtime by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4458
• chore(deps): bump js-yaml from 3.14.2 to 3.15.0 by @dependabot[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4445
• Decouple snap publishing from build matrix by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4470
• CI: Remove temporary branch from SQL Server Kerberos tests by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4473
• Update ssh-config dependency to published version 5.2.0 by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4474
• V5.9 release branch back to Master by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4452
• Merge rc-59 into master by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4479
• More kerberos by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4446
• Query, connection, and folder sharing by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4396 …

What's Changed

• fix: fix inability to discover or launch az cli on windows by @jasonnutter in https://github.com/beekeeper-studio/beekeeper-studio/pull/4538
• bump erd plugin: fix unsupported mariadb and libsql by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4545

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v5.9.2...v5.9.3

What's Changed

• Fix window clipping by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4472
• fix exporting query from favourites by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4471
• Fix parameter detection on initial query load by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4478
• Fix Sql Server Schema by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4477

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v5.9.1...v5.9.2

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. …

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. …

Happy summer everyone! Well here in Texas things are getting a little toasty, so thought we'd celebrate with an equally hot Beekeeper Studio release 🔥🔥.

Included: A brand new database driver, query edit history for workspaces, automatic driver downloads, better SSH config support, and a long tail of bug fixes, security hardening, and UI polish.

Highlights

• Amazon DynamoDB support. Connect to DynamoDB and browse your tables, right inside Beekeeper Studio. Our 18th database engine.

• Query Edit History. When connected to a cloud workspace, every change you make to your query now gets recorded, so you can compare versions and roll-back if desired.

• Automatic driver downloads. Some database engines need heavy native drivers that we'd rather not ship with every build. There's now a framework that downloads the right driver dependency on demand, the first time you need it, instead of bloating the installer for everyone.

Lowlights

Day has been working hard on a Snowflake driver, it's almost done, but wasn't ready in time for this release like we expected.

Azmi has been working on multi-hop SSH support so you can connect to your database via 2+ different jump hosts. Again, it just missed our release cutoff.

Smaller Improvements

• New upgrade panel and modal used consistently across the app, with an animated AI Shell upsell card so it's clearer what you get with a paid plan.
• Bundled AI Shell upgraded to v3.1.0. …

What's Changed

• Fix SSH agent mode attempting to read non-existent private key files by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4194
• chore(deps): bump @xmldom/xmldom from 0.8.12 to 0.8.13 by @dependabot[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4156
• chore(deps): bump follow-redirects from 1.15.11 to 1.16.0 by @dependabot[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/4097
• add [DEV] Make Fake Remote Change context menu item to query editor by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4176
• fix context menu showing on non-text inputs by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4191
• Disable write action shortcuts in readonly mode by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4198
• fix(autocomplete): suggest columns for quoted tables and joins by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/4203
• Fix clickhouse rawExecuteQuery by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4207
• chore: add BaseModal wrapper component by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4131
• fix: preserve column layout when refreshing table by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4211 …

What's Changed

• Fix clickhouse rawExecuteQuery by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/4207
• fix: preserve column layout when refreshing table by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4211
• Prevent calling persistence write function before the table is ready by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4209
• fix: persist tabulator column state in app.db instead of localStorage by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4160
• fix double encoded jsonb values when inserting a new row from table view by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/4222

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v5.7.2...v5.7.3

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. …