Beekeeper Studio software icon

Beekeeper Studio 6.0.1

A cross-platform SQL client for connecting to databases, browsing schemas, editing data, and organizing saved queries.

Updated August 14, 2026
191.38 MB
0.0

Use the arrow keys to choose a rating, then press Enter or Space to submit it.

Not rated yet 0 user ratings

App Specs

DeveloperBeekeeper Studio
LicenseFreeware
CategorySystem Tools
Available platformsWindows, macOS, Linux
Downloads173

Overview

Beekeeper Studio is a database client for Windows, macOS and Linux that combines SQL editing with a spreadsheet-style view of database records. It connects to engines such as PostgreSQL, MySQL, MariaDB, SQLite and SQL Server, letting you query data, change rows and define tables within the same desktop application. A free Community Edition provides the core editor and table tools; paid editions add functions such as file imports, editable query results and shared workspaces.

Connections can use SSL encryption or an SSH tunnel, and saved connection passwords are encrypted. Beekeeper Studio keeps connections and saved queries in folders, while separate tabs hold the tables and SQL you are working on. Database support varies by edition: for example, Oracle and Firebird require a paid plan, while PostgreSQL and SQLite are available in Community.

Beekeeper Studio’s SQL editor

The SQL editor draws its suggestions from the connected database. It suggests tables after a FROM or JOIN clause and columns after a table name or alias followed by a period. Syntax highlighting separates SQL elements, and identifier quoting follows the conventions of the selected engine.

You can execute an entire script, the statement at the cursor or only a selected passage. Results appear below the editor, with a selector for the separate result sets produced by multiple statements.

Beekeeper Studio also supports query parameters. Placeholders in the SQL prompt for values when the query runs, using the syntax supported by that database. A reusable lookup can therefore accept a different identifier without replacing a literal inside the statement each time. Named saved queries retain SQL for later use, and connection-specific history provides access to statements previously run against that database.

Filtering rows and staging cell edits

Opening a table displays its rows in a paginated grid. You can filter by values, write an SQL filter for more complex conditions and hide columns that are irrelevant to the current task. Foreign-key values act as links to the referenced records, opening the related data in another tab.

Cell editing uses an input suited to the field’s data type. Changes are staged so you can review them before applying them, discard them or generate the corresponding SQL for separate execution. Paid editions also allow changes directly in query results when the result contains enough information to identify and update the source record. This lets a filtered SELECT result become the starting point for a correction without reopening the whole table.

JSON sidebar

The paid JSON Sidebar presents an individual record as formatted JSON beside the table. Fields that are difficult to read across a wide row become a vertical structure, and foreign keys can expand into related records within that structure. You can follow further relationships without repeatedly leaving the original table.

Selecting another row updates the sidebar. Its search accepts field names, values and regular expressions, while JSON stored inside ordinary text columns is recognized and formatted.

Table structure

The table creator translates visual column definitions into a database table. You choose data types, default values and null constraints, with an auto-increment option for a generated key. The same controls can alter existing columns where the database supports those changes.

Indexes and relationships have their own controls. Selecting several columns creates a composite index, and foreign-key definitions use lists of available tables and columns. Copy to SQL generates the statement in an editor tab, allowing you to inspect or execute the SQL separately from the visual definition.

CSV imports, exports and Run To File

Paid import tools bring CSV rows into database tables. Beekeeper Studio detects the file’s formatting and maps its columns to the destination. You can append records, empty the existing table before importing or use an upsert to update matching records and insert new ones. Imports stream through the file rather than loading the entire input at once.

Exports can cover complete tables, several tables or a filtered view. Output options include CSV, Excel, JSON, JSON Lines and Markdown, while copying result rows produces a table suitable for pasting into Excel or Google Sheets.

The query grid limits its displayed output to 50,000 records. For a larger result, the commercial Run To File command sends the complete query output directly to CSV.

Shared queries

Professional and Business plans provide Cloud Workspaces for synchronizing connections and saved SQL across devices. Existing local items can be imported into an online workspace. Each member has personal storage alongside a shared team folder, so a query can remain private or be made available to colleagues by its placement.

Folder contents synchronize as they change. The shared material consists of connection details and saved queries, rather than a copy of the database rows returned by those queries. Workspace storage and communication are encrypted, with additional encryption for sensitive fields such as passwords.

AI Shell

The AI Shell in Professional and Business plans can inspect table structures and relationships, compose SQL and request permission to execute it. Execution gives the assistant database results to use when developing its response, while the user retains a decision over whether a proposed statement runs.

You choose the model and supply your own API key. Beekeeper Studio communicates directly with that provider or an OpenAI-compatible local or remote model; it does not require a single built-in AI service. The integration can also be disabled by a user or administrator.

Key Features

  • Tabbed SQL query editor
  • Schema and table browser
  • Editable data grid where permitted
  • Saved queries and connection profiles
  • Support for multiple database engines

Similar Apps