Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more.
Beekeeper Studio Description
Beekeeper Studio is a modern and easy-to-use SQL client designed for seamless database management across MySQL, Postgres, SQLite, SQL Server, and more. It supports multiple databases, offering developers, database administrators, data engineers, analysts, and educators a powerful yet user-friendly tool.
Key features include an autocomplete editor with syntax highlighting, a tabbed interface for multitasking, query saving, run history tracking, and a dark theme. Users can import/export data, perform backups/restores, view data as JSON, and utilize keyboard shortcuts for efficiency.
Beekeeper Studio enhances productivity by providing a smooth, user-friendly experience without clutter, making it ideal for professionals seeking a reliable SQL client. It is available on Linux, Mac, and Windows and can be installed via winget.
README
Beekeeper Studio
Beekeeper Studio is a cross-platform SQL editor and database manager available for Linux, Mac, and Windows.
We publish binaries for MacOS, Windows, and Linux.
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.
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server.
MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
The graphical interface supports all PostgreSQL features and makes administration easy.
The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.
Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security.
No additional drivers are required to communicate with the database server.
HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained.
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server.
MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
pgAdmin is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
The graphical interface supports all PostgreSQL features and makes administration easy.
The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.
Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security.
No additional drivers are required to communicate with the database server.
HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained.
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 🥰
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!
Beekeeper Studio's trademarks (words marks and logos) are not open source. See our trademark guidelines for more information.
Trademark Guidelines
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.
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 git@github.com:/beekeeper-studio.git beekeeper-studio
cd beekeeper-studio/
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.
On Ubuntu/Debian:
sudo apt-get update
sudo apt-get upgrade openssl
On CentOS/RHEL:
sudo yum update openssl
On macOS (using Homebrew):
brew update
brew upgrade openssl
Where to make changes?
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':
ConnectionInterface - connecting to a DB
CoreInterface - interacting with a database
How to submit a change?
Push your changes to your repository and open a Pull Request from our github page (this page)
Make sure to write some notes about what your change does! A gif is always welcome for visual changes.
Maintainer notes (casual readers can ignore this stuff)
Upgrading Electron Gotchas
This is always a total pain and will break the build 9/10.
Some things you need to consider when upgrading Electron:
Does it use a different node version. Eg Electron-18 uses node 14, 22 uses node 16. So everyone needs to upgrade
Does node-abi need to be upgraded to be able to understand the electron version? This is used in the build to fetch prebuilt packages. You need to upgrade this in root/package.json#resolutions
Were any APIs deprecated or removed? Make sure all features that interact with the Electron APIs still work, stuff like - selecting a file, maximizing a window, running a query, etc.
Release Process
Up the version number in package.json
Replace build/release-notes.md with the latest release notes. Follow the format that is there.
run git log ..HEAD --oneline | grep 'Merge pull' to find PRs merged
Commit
Push to master
Create a tag git tag v. It must start with a 'v'
git push origin
Now wait for the build/publish action to complete on Github
Push the new release live
Go to the new 'draft' release on the releases tab of github, edit the notes, publish
Log into snapcraft.io, drag the uploaded release into the 'stable' channel for each architecture.
This should also publish the latest docs
Post Release:
Copy release notes to a blog post, post on website
Tweet link
Share on LinkedIn
Send to mailing list on SendInBlue
Big Thanks
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.
This webapp is a browser and desktop password manager compatible with KeePass databases.
It doesnt require any server or additional resources.
The app can run either in browser, or as a desktop app.
This webapp is a browser and desktop password manager compatible with KeePass databases.
It doesnt require any server or additional resources.
The app can run either in browser, or as a desktop app.
Tabby (formerly Terminus) is a highly configurable terminal emulator, SSH and serial client for Windows 10, macOS and Linux
- Integrated SSH and Telnet client and connection manager
- Integrated serial terminal
- Theming and color schemes
- Fully configurable shortcuts and multi-chord shortcuts
- Split panes
- Remembers your tabs
- PowerShell (and PS Core), WSL, Git-Bash, Cygwin, MSYS2, Cmder and CMD support
- Direct file transfer from/to SSH sessions via Zmodem
- Full Unicode support including double-width characters
- Doesn't choke on fast-flowing outputs
- Proper shell experience on Windows including tab completion (via Clink)
- Integrated encrypted container for SSH secrets and configuration
- SSH, SFTP and Telnet client available as a web app (also self-hosted)
Tabby (formerly Terminus) is a highly configurable terminal emulator, SSH and serial client for Windows 10, macOS and Linux
- Integrated SSH and Telnet client and connection manager
- Integrated serial terminal
- Theming and color schemes
- Fully configurable shortcuts and multi-chord shortcuts
- Split panes
- Remembers your tabs
- PowerShell (and PS Core), WSL, Git-Bash, Cygwin, MSYS2, Cmder and CMD support
- Direct file transfer from/to SSH sessions via Zmodem
- Full Unicode support including double-width characters
- Doesn't choke on fast-flowing outputs
- Proper shell experience on Windows including tab completion (via Clink)
- Integrated encrypted container for SSH secrets and configuration
- SSH, SFTP and Telnet client available as a web app (also self-hosted)
Tabby (formerly Terminus) is a highly configurable terminal emulator, SSH and serial client for Windows 10, macOS and Linux
- Integrated SSH and Telnet client and connection manager
- Integrated serial terminal
- Theming and color schemes
- Fully configurable shortcuts and multi-chord shortcuts
- Split panes
- Remembers your tabs
- PowerShell (and PS Core), WSL, Git-Bash, Cygwin, MSYS2, Cmder and CMD support
- Direct file transfer from/to SSH sessions via Zmodem
- Full Unicode support including double-width characters
- Doesn't choke on fast-flowing outputs
- Proper shell experience on Windows including tab completion (via Clink)
- Integrated encrypted container for SSH secrets and configuration
- SSH, SFTP and Telnet client available as a web app (also self-hosted)
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
