# Beekeeper Studio v5.9.0

- Product: Beekeeper Studio (https://whatsnew.fyi/product/beekeeper-studio)
- Vendor: Beekeeper Studio
- Date: 2026-07-06
- Version: v5.9.0
- Original notes: https://github.com/beekeeper-studio/beekeeper-studio/releases/tag/v5.9.0
- Permalink: https://whatsnew.fyi/product/beekeeper-studio/releases/v5.9.0
- Labels: Platforms: Desktop

What's New is an index, not a publisher: every entry below links to the vendor's own release notes, which are the authoritative source. Entries are labelled where they are hand-curated sample data, pre-releases, or drawn from a secondary source such as a developer blog.

Reuse: the summaries, labels and curation here are © What's New. Quote freely with attribution and a link back; wholesale republication of the corpus is not permitted — terms: https://whatsnew.fyi/terms. The vendors' own release notes remain their publishers'.

---

- **added** — Add Snowflake driver with connections, schema browsing, views and materialized views, keys, indexes, DDL retrieval, table cloning, transactional writes, streaming and cancellation
- **added** — Add SQL Server integrated Windows and Kerberos authentication with Encrypt toggle and optional SPN override
- **added** — Add ability to paste copied data as new rows with a dedicated keybinding
- **added** — Add dropdown selection of enum values in PostgreSQL, CockroachDB, MySQL/MariaDB, DuckDB, and ClickHouse
- **added** — Add unified move-to dialog for connections, saved queries, and folders
- **added** — Add inline renaming of queries, connections, and folders in the sidebar
- **added** — Add configurable keyboard shortcuts for plugin menu items
- **added** — Add unix-timestamp query magic to convert Unix timestamps to readable date strings
- **added** — Add ClickHouse custom SSL certificate support
- **added** — Add DynamoDB beta support
- **added** — Persist last-open sidebar tab across restarts and make default sidebar selection configurable
- **changed** — Make backspace clear a selected range in tables
- **changed** — Improve SSH config handling with warning toasts for unparseable config, bad ownership/permissions, or missing IdentityFile
- **changed** — Use ssh-config native Match exec handling instead of stripping Match blocks
- **fixed** — Fix restoring edited text of a saved query
- **fixed** — Fix auto-refresh when making table alterations from the query editor
- **fixed** — Fix BigQuery NUMERIC and BIGNUMERIC values display
- **fixed** — Fix SQL Server autocomplete handling of bracket-quoted identifiers
- **fixed** — Fix editing PostgreSQL array of enums throwing a JSON error
- **fixed** — Fix SSH tunneling for ClickHouse and Firebird and add bastion/jump-host support for MongoDB

#### 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 defa

_[Truncated at 4000 characters — full notes: https://github.com/beekeeper-studio/beekeeper-studio/releases/tag/v5.9.0]_