How to Install Beekeeper Studio on Debian 11 Bullseye

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.

Update Debian

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

Example output:

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.

beekeeper-studio

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

Example:

Once launched, you will land on the default landing screen to select a connection type to proceed.

Example:

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.