Beekeeper Studio

Beekeeper Studio is a SQL editor and database manager that ships as a desktop app for Linux, Mac and Windows. It exists because its authors could not find an open source workbench that stayed pleasant to use once the feature list grew, and the kitchen-sink alternatives had cluttered themselves into unusability.

The guiding rule is stated plainly by the project: if a new feature compromises speed or clarity, they kill it. The app is free to download with no sign-up, registration or credit card, and premium features live in the same repository under a separate commercial license.

Day to day work happens through a small set of tools.

• Query editor: autocomplete and syntax highlighting, in a tabbed interface so several pieces of work stay open.
• Saved queries and history: store queries for later, and dig the working one back out of the run history days afterwards.
• Table browsing: sort and filter table data to find what you need, and read rows as JSON.
• Import and export: move data in and out of a database, with backup and restore alongside.
• Free database coverage: PostgreSQL, MySQL, SQLite, SQL Server, Redshift, CockroachDB, MariaDB, TiDB, BigQuery, Redis and GreengageDB.

Paid editions extend that list to Oracle, Cassandra, ClickHouse, DuckDB, MongoDB, Trino, Firebird and others, with DynamoDB in beta and Snowflake announced. The community edition is GPLv3, and building it locally needs Node.js, Yarn in classic mode and an up-to-date OpenSSL.