How to Install Beekeeper Studio on Ubuntu 22.04 or 20.04

Beekeeper Studio is a cross-platform SQL client for managing databases, including MySQL, Postgres, SQLite, and SQL Server. It is designed to make it easy for developers and data analysts to work with databases by providing a modern, user-friendly interface. Some benefits of using Beekeeper Studio include the ability to easily navigate and manage multiple databases, perform advanced SQL operations, and quickly visualize and export data.

When incorporated into Ubuntu, Beekeeper Studio can manage databases running on the same system or remotely, making it a powerful tool for data management and analysis. Additionally, it can be integrated with other tools and systems, such as version control systems, to facilitate collaboration and data management workflow.

Features of Beekeeper Studio include:

• SQL editor with syntax highlighting and autocomplete
• Intuitive database navigator
• Support for multiple database types
• Advanced SQL operations, such as explaining plans and query history
• Visualization and export of query results
• Collaboration features such as query sharing and version control integration
• Data import and export capabilities
• Multi-platform support for Windows, Mac, and Linux

Benefits of using Beekeeper Studio:

• Improved efficiency and productivity in working with databases
• User-friendly interface for managing and analyzing data
• Compatibility with multiple database types and platforms
• Advanced SQL capabilities
• Ability to visualize and export data
• Support for collaboration and data management workflows

This guide will provide detailed instructions on installing Beekeeper Studio, a cross-platform SQL client, on Ubuntu 22.04 (Jammy Jellyfish) and 20.04 (Focal Fossa) operating systems. Users can quickly and effectively install Beekeeper Studio on their Ubuntu systems by importing the official repository and utilizing command-line interface (CLI) commands.

Step 1: Update Ubuntu

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 during the installation process.

sudo apt update

As an optional step, you can list the updates for those users who wish to review them or are simply curious about what updates are available.

sudo apt --list upgradable

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

sudo apt upgrade

Step 2: Import Beekeeper Studio Repository

By default, 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 important to ensure that the following packages are installed to facilitate the process.

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

The following software packages are commonly found on nearly all Linux distributions.

To import the GPG key, use 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.

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.

sudo apt update

Step 3: 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

Step 4: Launch Beekeeper Studio

You can use the following path to launch the application using its icon to access the graphical user interface.

Activities > Show Applications > Beekeeper Studio

Example:

Upon launching Beekeeper Studio for the first time, you will be directed to the default landing screen, where you can select the type of connection you want to establish. This could be a connection to a local or remote database, a connection to a cloud-based service, or a connection to a specific data source. Once you have made your selection, you can proceed to connect to the desired data source and begin managing and querying your data using the various tools and features provided by Beekeeper Studio. It’s also a good idea to configure settings like the color scheme, font size, and keyboard shortcuts to your preference and explore the tools and features of Beekeeper Studio.

Example:

Additional Commands & Tips

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 available updates for Beekeeper Studio and any other packages on your system and install any updates that are found. It’s a good practice to run these commands regularly to ensure that you are running the latest version of Beekeeper Studio and other packages on your system.

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

This command will remove the Beekeeper Studio package and all of its dependencies from your system. Additionally, if you want to remove the configuration files and any other data created during Beekeeper Studio usage, you may also run.

sudo apt-get purge beekeeper-studio

Please note that once you remove the package, you will lose access to the software and any associated data. It’s always recommended to back up the data before removing the package.

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

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

Conclusion

Installing Beekeeper Studio on Ubuntu can be simple when following the proper steps. You can easily install Beekeeper Studio on your Ubuntu system by importing the official repository and installing the latest version, along with how to update and remove the software in the future. Overall, Beekeeper Studio can benefit your system, and with these steps, you can easily install and manage the software on your Ubuntu system.