Beekeeper Studio is a free, open source databases project written in TypeScript and released under a custom open-source licence. It has 23,623 GitHub stars, 1,630 forks and 1,168 open issues, and was last pushed 8 hours ago. On this registry it ranks #24 of 81 tracked projects in Databases, with 5 head-to-head comparisons available. It gained 18 stars over the last 6 tracked days.

What is Beekeeper Studio?

Beekeeper Studio is a cross-platform, open-source SQL editor and database manager for Linux, macOS, and Windows that gives developers and data teams one graphical client for many different database engines.

What it is

Beekeeper Studio is a desktop application that combines a SQL editor with a database manager. It is built with Electron, written largely in TypeScript, and published as binaries for macOS, Windows, and Linux. From a single interface it connects to relational and non-relational engines including PostgreSQL, MySQL, SQLite, SQL Server, MariaDB, CockroachDB, TiDB, Amazon Redshift, Google BigQuery, Redis, Cassandra, ScyllaDB, Oracle Database, Firebird, LibSQL, ClickHouse, DuckDB, and GreengageDB. The project lives in the same ecosystem as the database servers it fronts rather than in the server stack itself, and it is aimed at anyone who has to open more than one engine on a given day.

The concrete problem it solves is client sprawl. Rather than installing and learning a separate vendor-specific graphical client for each engine, a user installs one application and points it at whichever connection is relevant. The free edition carries no sign-up, registration, or credit card requirement, so the friction of trying it is a download. Most of the repository is open source under the GPLv3 licence; the paid features are also present in the same repository under a commercial source-available licence.

Key capabilities

  • One client covers a long engine list, with full support marked for PostgreSQL, MySQL, SQLite, SQL Server, MariaDB, CockroachDB, TiDB, Amazon Redshift, Google BigQuery, Redis, and GreengageDB in the community edition.
  • Oracle Database, Cassandra, ScyllaDB, Firebird, LibSQL, ClickHouse, and DuckDB are listed as full support in the paid editions only; ScyllaDB works through the Cassandra driver as a drop-in compatible target.
  • Cross-platform binaries are published for macOS, Windows, and Linux, with the README linking downloads from beekeeperstudio.io/get-community.
  • Per-engine connection documentation is published at paths such as docs.beekeeperstudio.io/user_guide/connecting/sqlite, .../cockroachdb, .../bigquery, .../redis, .../oracle, .../firebird, and .../clickhouse.
  • The README is maintained in translation, with files including README.pt-br.md, README-es.md, README-de.md, README-fr.md, README-el.md, README-ja.md, README-it.md, README-ko.md, README-id.md, and README-sw.md alongside the English original.
  • The project welcomes community contributions, and the free and paid feature sets coexist in one repository rather than splitting into separate codebases.
  • The Electron and TypeScript stack is listed among the repository topics together with bigquery, cassandra, cockroachdb, firebird, mariadb, mssql, mysql, and postgresql.

Who uses it and how

  • Teams that run several engines at once — for example MySQL or MariaDB alongside PostgreSQL — use a single installed client instead of maintaining a separate tool per engine.
  • Analytics-oriented users connect to Google BigQuery, ClickHouse, or DuckDB from the same application they use for transactional databases.
  • Users of distributed systems such as CockroachDB and TiDB have dedicated connection guidance in the documentation.
  • Redis users can work with a key-value store in the same client that opens their relational databases.
  • Developers working with local file databases such as SQLite and LibSQL can open them directly in a desktop application with no server component to run.
  • Non-English-speaking teams are served by the translated README files covering Portuguese, Spanish, German, French, Greek, Japanese, Italian, Korean, Indonesian, and Swahili.

Getting started

Download the free binaries for macOS, Windows, or Linux from the link given in the README at beekeeperstudio.io/get-community. No sign-up, registration, or credit card is required for the free edition; premium features are unlocked with a paid licence described on the project's pricing page.

How it compares

No comparable tool and no list of replaced paid products appears in the facts provided, so Beekeeper Studio stands alone in this registry entry. The distinguishing facts available are its dual licensing model — GPLv3 for most of the code and a commercial source-available licence for the paid features kept in the same repository — and a cost model where the free tier is unlimited in time but restricted in engine coverage.

When to use it — and when not to

This is a desktop client, not a service: the facts describe no server, database, or mail component that a self-hoster must operate, which makes adoption cheap but also means there is nothing to deploy for a team that wants browser-based or headless access. Anyone who needs every feature under one uniform open-source licence should look carefully, because the repository mixes GPLv3 code with commercially licensed paid features, and the registry metadata reports the licence as NOASSERTION rather than a clean identifier. The repository also carries 1,168 open issues, so a prospective user should weigh the free-tier engine limits and the maintenance backlog against the convenience of a single cross-platform client.

project readme (upstream, from github) — read inline

🌐 EN | PT-BR | ES | DE | FR | EL | JA | IT | KO | ID | SW

Beekeeper Studio

Beekeeper Studio is a cross-platform SQL editor and database manager available for Linux, Mac, and Windows.

Download Beekeeper Studio

We publish binaries for MacOS, Windows, and Linux.

image

Beekeeper Studio is free to download and provides a lot of features for free, no sign-up, registration, or credit card required. The app provides some premium features for a reasonable cost license fee. Learn more here

Most of the code in this repo is open source under the GPLv3 license. Paid features are also in this repository under a commercial source-available license.

We welcome community contributions!

Supported Databases

Database Support Community Paid Editions Beekeeper Links
PostgreSQL ⭐ Full Support Features
MySQL ⭐ Full Support Features
SQLite ⭐ Full Support Features, Docs
SQL Server ⭐ Full Support Features
Amazon Redshift ⭐ Full Support Features
CockroachDB ⭐ Full Support Features, Docs
MariaDB ⭐ Full Support Features
TiDB ⭐ Full Support Features
Google BigQuery ⭐ Full Support Features, Docs
Redis ⭐ Full Support Features, Docs
GreengageDB ⭐ Full Support Docs
Oracle Database ⭐ Full Support Features, Docs
Cassandra ⭐ Full Support Features
ScyllaDB ⭐ Full Support (via Cassandra driver) Drop-in compatible with Cassandra
Firebird ⭐ Full Support Features, Docs
LibSQL ⭐ Full Support Features
ClickHouse ⭐ Full Support Features, Docs
DuckDB ⭐ Full Support Features, Docs
SQL Anywhere ⭐ Full Support Features
MongoDB ⭐ Full Support Features, Docs
Trino / Presto ⭐ Full Support Features, Docs
SurrealDB ⭐ Full Support Docs
DynamoDB 🧪 Beta Support Features, Docs
Snowflake ⏳ Coming Soon --

Editions of Beekeeper Studio

Beekeeper Studio is a single download with in-app upgrades for premium features.

We'd love to make Beekeeper Studio totally free for everyone, but building good software is hard work and expensive. We think our paid editions are fairly priced, I hope you do too.

👉 Compare Beekeeper Studio Editions

Beekeeper Studio Features

Top feature: It's smooth 🍫, fast 🏎, and you'll actually enjoy using it 🥰

  • Truly cross-platform: Windows, MacOS, and Linux
  • Autocomplete SQL query editor with syntax highlighting
  • Tabbed interface, so you can multitask
  • Sort and filter table data to find just what you need
  • Sensible keyboard-shortcuts
  • Save queries for later
  • Query run-history, so you can find that one query you got working 3 days ago
  • Great dark theme
  • Import/export
  • Backup/restore
  • View data as JSON
  • Loads more

Our approach to UX

One of our frustrations with other open-source SQL editors and database managers is that they take a 'kitchen sink' approach to features, adding so many features that the UI becomes cluttered and hard to navigate. We wanted a good looking, open source SQL workbench that's powerful, but also easy to use. We couldn't find one, so we created Beekeeper Studio!

Generally our guiding star is to only build software that 'feels good' to use. That means at the very least we value Beekeeper being fast, straightforward to use, and modern. If a new feature compromises this vision, we kill it.

Supporting Beekeeper Studio

We love working on Beekeeper Studio, and we'd love to keep growing and improving it forever. To do that I need your help.

The best way to support Beekeeper Studio is to purchase a paid license. Every purchase directly supports our work on Beekeeper Studio.

If you're at a business and using Beekeeper Studio for your job, you should probably get your boss to buy you a license.

If you can't afford a license, please use the free version, that's why we make a free version!

Thank you for your continued support!

Documentation

Check out docs.beekeeperstudio.io for user guides, FAQs, troubleshooting tips, and more.

Licens

readme truncated — read the full docs on github

Frequently asked questions

Is Beekeeper Studio free to use?

Beekeeper Studio is open source. There is no licence fee and no seat count — you can self-host it or, where the project offers one, pay a vendor for a managed version instead.

What does Beekeeper Studio do?

Modern and intuitive SQL client for multiple databases

What is Beekeeper Studio written in?

Beekeeper Studio is primarily written in TypeScript. Its source is publicly available at https://github.com/beekeeper-studio/beekeeper-studio, and it has 23,623 GitHub stars.