How to Install Beekeeper Studio on Ubuntu 24.04/22.04/20.04

BeeKeeper Studio, an intuitive and powerful SQL editor and database manager, enriches the experience of managing databases on your Ubuntu server. Let’s delve into what makes BeeKeeper Studio a go-to choice for database management:

• Simplified SQL Editing: Craft and run SQL queries with an intelligent SQL editor that supports syntax highlighting and auto-completion.
• Database Management Efficiency: Easily manage multiple databases, whether SQLite, MySQL, PostgreSQL, or others.
• Data Visualization Tools: Visualize query results instantly, making data analysis more accessible and understandable.
• Cross-Platform Compatibility: Use BeeKeeper Studio across various operating systems, ensuring a consistent experience regardless of your platform.
• Secure Connections: Prioritize data security with SSL support for database connections.
• Open Source Advantage: Benefit from a community-driven development model focusing on continuous improvement and transparency.

The ease of use and powerful tools make BeeKeeper Studio an essential asset for any developer or database administrator. Now, we will demonstrate the installation steps for BeeKeeper Studio.

Update Ubuntu Before Beekeeper Studio Installation

It is important to note that before starting the installation process, you must update your system to ensure that all packages are up-to-date to prevent any potential conflicts that may arise.

sudo apt update

To proceed with upgrading any outdated packages, use the following command.

sudo apt upgrade

Import Beekeeper Studio APT Repository

Beekeeper Studio is not available on Ubuntu’s repository. However, it can be imported using the Beekeeper Studio official APT repository. Before proceeding with the installation, it is essential to install the following packages to facilitate the process.

sudo apt install dirmngr software-properties-common apt-transport-https curl -y

Next, import the GPG key using the following command:

curl -fSsL https://deb.beekeeperstudio.io/beekeeper.key | sudo gpg --dearmor | sudo tee /usr/share/keyrings/beekeeper.gpg > /dev/null

The next step is to import the Beekeeper Studio repository with the following command:

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

Finally, execute an APT update to refresh the APT repository cache:

sudo apt update

Finalize Beekeeper Studio Installation APT Command

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

Launch Beekeeper Studio

Now that you have installed Beekeeper Studio, you can immediately launch the software on your terminal utilizing the following command:

beekeeper-studio

Alternatively, you can use the following path to launch the application and access the graphical user interface by clicking its icon.

Activities > Show Applications > Beekeeper Studio

Additional Beekeeper Studio Commands

Update Beekeeper Studio

You can use the standard apt update or upgrade commands to receive updates for Beekeeper Studio on your system.

sudo apt update
sudo apt upgrade

These commands will check for any updates for Beekeeper Studio and any other packages on your system and install any updates found.

Remove Beekeeper Studio

When you no longer need Beekeeper Studio installed on your Ubuntu system, you can use the following command to remove it.

sudo apt remove beekeeper-studio

Lastly, removing the repository with the following command is recommended if you do not plan to re-install Beekeeper Studio.

sudo rm /etc/apt/sources.list.d/beekeeper.list

Conclusion

We’ve just walked through the simple yet comprehensive steps to install BeeKeeper Studio on Ubuntu 24.04, 22.04, or 20.04. From setting it up using the command-line terminal to exploring some basic usage commands, you can now manage your databases more efficiently. My final piece of advice? Dive in and start experimenting with BeeKeeper Studio’s features. The more you use it, the more you’ll appreciate its sleek interface and powerful capabilities.