Beekeeper Studio 6.1 - Folders and read-only mode are now free

We’re making some paid features free as part of v6.1 which you can Download from our website right now.

We routinely move features from the paid tiers to the free tier as a way to make our community edition really, genuinely good.

Strangly, this is also a benefit to our paid users, as we tend to release most new features to our paid users first, so they get the benefit of first access, even if we eventually make a feature free.

Remember, that if a community member (like you) contributes a major feature and we merge it, we’ll make it free for everyone, just like we did with Redis and Valkey support.

Highlights

• Folders are free. Organize saved connections and queries into nested folders on the free tier, drag-and-drop included. This works in local workspaces, so you don’t need any sort of Beekeeper account to use it.

• Read-only mode is free. Mark a connection as read-only and Beekeeper Studio stops you running ‘destructive’ SQL - like UPDATE,DELETE,ALTER,etc. This means you can poke around production without worrying about a stray click. This used to be a paid feature, now everyone gets it.

• Create things from a folder. Right-click a folder in the sidebar to create a new query or a new connection directly inside it. Seems simple, but man was it frustrating not to have this button where we expected it.

Other Improvements

• Vim mode improvements. Ex commands go where they should, the editor stops stealing focus from the save dialog, the Vim status line respects dark themes, and .beekeeper.vimrc parsing is more reliable.

• Table Properties tab tidy-up. A more compact, more sensible layout for the table properties view.

• Active line highlighting. The query editor now highlights the line you’re on and its line number. Thanks @Srijal-SS!

• JSON sidebar indent guides. Indentation markers make deeply nested JSON easier to follow.

• Disable autocomplete pieces individually. Turn off schema completion or keyword completion on their own instead of all or nothing.

• “Updated by” in the query editor. In a cloud workspace you can see who last edited a saved query.

• MySQL cleartext auth. New Enable Cleartext Plugin option on MySQL connections, for servers that use mysql_clear_password (e.g. some proxy and LDAP setups). This was previously enabled by default, but was disabled as a default by the driver maintainers, so that’s why we needed the option to turn it on.

• Copy SQL respects hidden columns. Generating SELECT or other queries from a table now only includes the columns you have visible.

Everything Else

A big thanks to everyone who contributed, including five first-time contributors this release!

• Fixed “phantom tabs” caused by recently used connections clashing with saved ones (#4675)
• Tabs on an unsaved connection can be switched between properly (#4807)
• SQLite and LibSQL stability fixes (#4679)
• Add Row is reachable via right-click when the table is full. Thanks @Fraianni! (#4667)
• Quick switcher shows an empty state when nothing matches. Thanks @ChihebBENCHEIKH1! (#4155)
• SSH agent errors are non-fatal, so public key auth can still go ahead. Thanks @stephaneminisini-fps! (#4681)
• Fixed the tab switching shortcut on macOS. Thanks @gruberlu! (#4226)
• PostgreSQL drop errors include the details from the server. Thanks @bnquon! (#4650)
• Tables use the Command key on macOS instead of Ctrl (#4789)
• Data grid upgraded to Tabulator 6.6, with fixes for pasting via keyboard shortcut, range fill marking cells as edited, edited cell styles inside a range selection, result column resizing, and copy highlights that now persist (#4820, #4822, #4826, #4817, #4829, #4803, #4831)
• Fixed a trigger that prevented some saved queries from being deleted (#4760)
• ER diagram menu item is pinned, and plugin menu items are disabled when disconnected (#4747)
• Plugin shortcuts fixed, and plugin themes now follow the system theme (#4700, #4705)
• Simpler keyboard hints and a fixed shortcuts modal (#4685)
• Global shortcut binding fixed (#4836)
• A cleaner, calmer upgrade dialog (#4692)
• Missing build dependencies added for ARM builds (#4751)
• AI Shell updated to v3.3.4 (#4726, #4727)
• Dependency updates including mysql2, qs, fast-uri, and @xmldom/xmldom