Beekeeper Studio Files

The primary feature of this release is a new tab type -- the AI SQL Shell.

Modeled after Claude Code and Aider, our AI integration requires zero fiddling, and can 'get to work' without a lot of hand holding. I've been using it myself for a month or so. It's good. Really good.

YouTube Walkthrough

Powerful, but transparent

The AI shell is private. No data is sent to our servers, the shell connects directly to your agent using an API key that you provide.

The Shell is smart and self-directed. You don't need to provide context, the AI will figure stuff out on its own. It can examine tables, run SQL (with your permission), and look at the results.

The shell is transparent. It shows you everything it does, and asks your permission before running custom SQL code.

The shell is optional. You can totally disable the AI shell if you don't want to see it, or just completely uninstall it. If you're an IT administrator you can disable (or enable) it for all your users.

Just to be explicit about this: By using the AI shell you will be sending code (SQL) and data (query results) to your AI agent.

Some notes

What's Changed

• fix: jsonb with number by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3036
• fix-3024: Process JSON View records using JSON.stringify and JsonSourceMap since JsonSourceMap does not support replacer by @mslosarek in https://github.com/beekeeper-studio/beekeeper-studio/pull/3025
• fix font build in UI Kit by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3020
• feat: add search for query results by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/3037
• Upgrade SQLTextEditor to use CM6 with LSP support by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3032
• fix columnsGetter error, and docs by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3048
• CHORE: Add load test container to Docker Compose by @JeanPaiva42 in https://github.com/beekeeper-studio/beekeeper-studio/pull/2958
• Fix [#2774]: Show export success modal only after all files are exported by @tomasmbrito in https://github.com/beekeeper-studio/beekeeper-studio/pull/3001
• fix: disable connection menu items when bks isnot connected with db by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3040
• hotfix: can't trigger autocompletion after an empty character by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3090
• Bugfix/2734 json columns load error by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/3111
• 5.2 post release merge back by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3015
• Bump vite from 5.4.15 to 5.4.19 by @dependabot[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/3092
• fix: excel sheet naming errors by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3132
• testcontainers upgrade by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3121
• fix: close all not removing tabs from appdb by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3161
• fix: macos disable connection menu items when all windows are closed by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3089
• fix: use a tooltip instead of adding a "title" to the html by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/3069
• Update supported databases in README files by @github-actions[bot] in https://github.com/beekeeper-studio/beekeeper-studio/pull/3193
• feat: support regex filter in json viewer by @mrsimb in https://github.com/beekeeper-studio/beekeeper-studio/pull/3181
• Plugin System Support by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/2857
• Feat [#2826]: Improve pagination/navigation by @joaovicente3 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3216
• add JSON, HTML, and JavaScript hints for text editor v2 by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3124
• Add typing support to UI Kit by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3019
• add vimConfig, vimKeymaps and clipboard props to text editor v2 by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3112
• fix cm6 vim keymap by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3241
• Issue [#3218] - added timer to display during execution by @Landro3 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3225
• New tab type for AI plugin by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3219
• fix codemirror theme by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3246
• Fix [#2809]: Improve JSON Row Viewer Truncated Text by @DanielFF2 in https://github.com/beekeeper-studio/beekeeper-studio/pull/2983
• INI Configuration Docs by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3245
• CHORE: Add initial E2E Tests code and tests for Database Connection and Query Execution by @JeanPaiva42 in https://github.com/beekeeper-studio/beekeeper-studio/pull/2950
• plugin system fails to get columns if the db does not support schema by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3254
• Add Claude Code GitHub Workflow by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3264
• Fix [#3251] by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3258
• remove deprecated height prop by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3270
• feat: add databases refreshing indicator by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3183
• feat: add copy column name right click menu by @therealrinku in https://github.com/beekeeper-studio/beekeeper-studio/pull/3103
• remove unused types, add getViewState/setViewState plugin APIs by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3276
• feat [#2431]: Connection Quick Switcher by @SMV-21 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3275
• Upgrade JSON Viewer to use UI Kit by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3268
• Remake query magics autocompletion for cm6 by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3272
• use ui kit in EditorModal by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3273
• fix merge conflict by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3278
• fix: handle schema drops correctly in PostgreSQL client by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3283
• add show table in plugin shell by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3280
• table result text is not centered by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3289
• Open table filter by shortcut in query tab by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3269
• use query editor status bar in plugin tab by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3291
• Fix [#2695]: Unable to Export Queries from Saved Queries by @tcctr in https://github.com/beekeeper-studio/beekeeper-studio/pull/2925
• Rc 52 by @rathboma in https://github.com/beekeeper-studio/beekeeper-studio/pull/3133
• Fix [#2907]: Prevent "ß" from printing when toggling the sidebar by @SMV-21 in https://github.com/beekeeper-studio/beekeeper-studio/pull/2948
• feat/fix: Privacy mode for SSH Tunnel by @pvlvld in https://github.com/beekeeper-studio/beekeeper-studio/pull/3296
• Mongo Shell CM6 by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/3290
• feat: toggle devtools hotkey by @pvlvld in https://github.com/beekeeper-studio/beekeeper-studio/pull/3299
• FEAT: Persist privacy mode setting by @pvlvld in https://github.com/beekeeper-studio/beekeeper-studio/pull/3297
• FIX: plugins manager styles by @pvlvld in https://github.com/beekeeper-studio/beekeeper-studio/pull/3298
• fix disconnect connection by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3304
• disable plugins from config files by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3302
• fix query selection for cm6 by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3303
• fix disabled plugins by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3308
• Parse JSON data in table detail view sidebar by @fightbulc in https://github.com/beekeeper-studio/beekeeper-studio/pull/2888
• json mutator should not throw errors to avoid breaking the table by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3319
• fix initial query tab that wasn't showing up by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3318
• fix cm6 keybinding issues and disable fold gutter in query editor by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3313
• Fix autocompletion after typing partial column names by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3314
• add open external API by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3300
• Fix the gpg referred to in our rpm postinstall script by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/3305
• fix table properties frozen cells style by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3325
• fix: do not convert empty arrays to (NULL) for display by @wrheinheimer in https://github.com/beekeeper-studio/beekeeper-studio/pull/3328
• fix editor focus by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3329
• add plugin data table by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3333
• Fix incorrect information in license-types docs by @JeanPaiva42 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3330
• Fix E2E tests by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/3337
• add clipboard APIs for plugins, fix plugin cache, right clicking tab by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3338
• fix text editor font by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3355
• build: update windows-2019 to 2022 for github actions by @wmontgomery in https://github.com/beekeeper-studio/beekeeper-studio/pull/3359
• remove v1 components in ui kit by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3360
• fix global status bar height by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3367
• fix draggable cell color by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3368
• fix ui kit css variables for plugins by @azmy60 in https://github.com/beekeeper-studio/beekeeper-studio/pull/3369
• Make allowing jumping to last page configurable, and add defaults for… by @not-night-but in https://github.com/beekeeper-studio/beekeeper-studio/pull/3364

New Contributors

• @JeanPaiva42 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/2958
• @tomasmbrito made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3001
• @mrsimb made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3181
• @Landro3 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3225
• @DanielFF2 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/2983
• @SMV-21 made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3275
• @tcctr made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/2925
• @pvlvld made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3296
• @fightbulc made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/2888
• @wrheinheimer made their first contribution in https://github.com/beekeeper-studio/beekeeper-studio/pull/3328

Full Changelog: https://github.com/beekeeper-studio/beekeeper-studio/compare/v5.2.12...v5.3.0