Beekeeper Studio might be a perfect choice for an easy-to-use and comprehensive GUI electron front end for database management. This open-source database GUI can easily connect with any MariaDB or Postgres and works well alongside popular databases such as MySQL, CockroachDB, Amazon Redshift, SQLite, and SQL DB. Currently, Beekeeper Studio only supports TCP connections for PSQL or MySQL, not the Unix socket connections.
Beekeeper Studio comes equipped with all sorts of useful features you would expect in a quality SQL program: autocomplete functionality includes completable queries without having to make multiple trips back and forth between programs; there’s even live reflection on what your question will do right before it finishes running so that minor mistakes don’t go unnoticed while typing.
In the following tutorial, you will learn how to install Beekeeper Studio on Debian 11 Bullseye by importing the official repository and installing the application from it with the command line terminal.
Table of Contents
First, update your system using the following command to ensure all packages are up-to-date.
sudo apt update && sudo apt upgrade -y
Install Required Packages
To complete the installation, you will need to install the following software packages by using the following command in your terminal.
sudo apt install software-properties-common apt-transport-https wget ca-certificates gnupg2 -y
Import Beekeeper Studio Repository
By default, Beekeeper is not available on Debian’s repository; luckily, you can import the Beekeeper Studio PPA.
First, import the GPG key using the following command.
sudo wget -O- https://deb.beekeeperstudio.io/beekeeper.key | gpg --dearmor | sudo tee /usr/share/keyrings/beekeeper.gpg
Next, import the repository.
echo 'deb [signed-by=/usr/share/keyrings/beekeeper.gpg] https://deb.beekeeperstudio.io stable main' | sudo tee /etc/apt/sources.list.d/beekeeper-studio-app.list
Lastly, run an APT update.
sudo apt update
Install Beekeeper Studio
With the GPG key and repository now imported and added securely, you can begin the installation of Beekeeper using the following terminal command.
sudo apt install beekeeper-studio
Next, confirm the installation by using the apt-cache policy command.
apt-cache policy beekeeper-studio
As above, the latest Beekeeper Studio is installed. Also listed are alternative backward installations that you can install if you had to back-track to any alternative versions of the latest that had a severe bug.
How to Launch Beekeeper Studio
Launching the application can use the terminal command in your console.
For desktop users, using the following path to Beekeeper would be much preferred if you do not have a terminal window open.
Activities > Show Applications > Beekeeper Studio
Once launched, you will land on the default landing screen to select a connection type to proceed.
How to Update/Upgrade Beekeeper Studio
You can run your standard apt update or upgrade commands to receive updates.
sudo apt update && sudo apt upgrade
How to Remove (Uninstall) Beekeeper Studio
When you no longer require Beekeeper installed on your system, use the following command to remove it.
sudo apt autoremove beekeeper-studio --purge -y
Next, remove the GPG key.
sudo rm /usr/share/keyrings/beekeeper.gpg
Lastly, remove the repository.
sudo rm /etc/apt/sources.list.d/beekeeper.list
Comments and Conclusion
The Beekeeper Studio software is a powerful tool for learning SQL or monitoring SQL without making multiple trips back and forth between programs. It has all the features you would expect from a quality program and will quickly help you become more skilled in this field.