Beekeeper Studio 是一款跨平台 SQL 编辑器与数据库管理器，支持 PostgreSQL、MySQL、SQLite、SQL Server、MariaDB、CockroachDB、BigQuery、Redis、MongoDB 等二十多种数据库，同时提供 MacOS、Windows、Linux 安装包。它提供带语法高亮和自动补全的查询编辑器、多标签页、表数据排序筛选、查询保存与运行历史、导入导出、备份恢复、JSON 查看等常用能力。项目刻意避免同类开源工具功能堆砌导致界面混乱的问题，界面现代简洁，操作响应快，并带深色主题。社区版以 GPLv3 开源且可免费使用，部分高级功能需付费授权。
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!
| 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 | ⭐ Full Support | ✅ | Docs | |
| SAP HANA | ⏳ Coming Soon | ✅ | -- |
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.
Top feature: It's smooth 🍫, fast 🏎, and you'll actually enjoy using it 🥰
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.
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!
Check out docs.beekeeperstudio.io for user guides, FAQs, troubleshooting tips, and more.
Beekeeper Studio Community Edition (the code in this repository) is licensed under the GPLv3 license.
Beekeeper Studio Ultimate Edition contains extra features and is licensed under a commercial end user agreement (EULA).
Beekeeper Studio's trademarks (words marks and logos) are not open source. See our trademark guidelines for more information.
Third party assets bundled with the app, such as the database icons, are credited in ATTRIBUTIONS.md.
Trademarks can be complicated with open source projects, so we have adapted a set of standard guidelines for using our trademarks that are common to many open source projects.
If you are just using the Beekeeper Studio app, and you are not forking or distributing Beekeeper Studio code in any way, these probably don't apply to you.
We love any community engagement. Even if you're complaining because you don't like something about the app!
Building an inclusive and welcoming community is important to us, so please follow our code of conduct as you engage with the project.
By contributing to the project you agree to the terms of our contributor guidelines.
We have you covered, read our guide to contributing in 10 minutes without coding.
Want to write some code and improve Beekeeper Studio? Getting set-up is easy on Mac, Linux, or Windows.
# First: Install NodeJS 20, NPM, and Yarn
# ...
# 1. Fork the Beekeeper Studio Repo (click fork button at top right of this screen)
# 2. Check out your fork:
git clone [email protected]:<your-username>/beekeeper-studio.git beekeeper-studio
cd beekeeper-studio/
yarn set version classic
nvm use 22
yarn install # installs dependencies
# Now you can start the app:
yarn run electron:serve ## the app will now start
If you get error:03000086:digital envelope routines::initialization error, you'll have to update openssl.
sudo apt-get update
sudo apt-get upgrade openssl
sudo yum update openssl
brew update
brew upgrade openssl
This repo is now a monorepo, we have several places with code, but only really a couple of important entry points.
All app code lives in apps/studio, some shared code lives in shared/src. This is shared with other apps.
Beekeeper Studio has two entry points:
background.js - this is the electron-side code that controls native things like showing windows.main.js - this is the entry point for the Vue.js app. You can follow the Vue component breadcrumbs from App.vue to find the screen you need.Generally we have two 'screens':
This is always a total pain and will break the build 9/10.
Some things you need to consider when upgrading Electron:
build/release-notes.md with the latest release notes. Follow the format that is there.git log ..HEAD --oneline | grep 'Merge pull' to find PRs mergedgit tag v. It must start with a 'v'git push origin This should also publish the latest docs
Post Release:
Beekeeper Studio wouldn't exist without Sqlectron-core, the core database libraries from the Sqlectron project. Beekeeper Studio started as an experimental fork of that repository. A big thanks to @maxcnunes and the rest of the Sqlectron community.
The original license from sqlectron-core is included here:
Copyright (c) 2015 The SQLECTRON Team
Permission is hereby granted, free of charge, to any person obtaining
a copy of this software and associated documentation files (the
'Software'), to deal in the Software without restriction, including
without limitation the rights to use, copy, modify, merge, publish,
distribute, sublicense, and/or sell copies of the Software, and to
permit persons to whom the Software is furnished to do so, subject to
the following conditions:
The above copyright notice and this permission notice shall be
included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND,
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY
CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT,
TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
内容由编辑整理，部分信息来自 GitHub 与项目官网，版权归原作者所有。发现错误？报告问题