Beekeeper Studio is a free(MIT license), open-source and cross-platform SQL editor and database manager application available for Linux, Mac, and Microsoft Windows. This applicaion works great with MariaDB, but also works with other relational databases like Postgres, SQL Server, Amazon Redshift, CockroachDB, and more.
It may not be as snappy or as resource friendly as a native app of this sort, but it looks and feels a lot more modern and smoother to work with. Unlike most other open source database managers and SQL editors, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need.
This includes SQL auto completion, Syntax Highlighting, sensible keyboard shortcuts, and It allows you to connect to the aforementioned supported databases, encrypt your connections with SSL, or tunnel through SSH if you prefer to. A nice feature is that you can also save all your connections, including the encrypted ones.
Things that make Beekeeper Studio uniquely awesome is its totally open source and free, Privacy respecting, Modern and easy to use and user-friendly SQL editor and database manager that still boasts a decent array of features.
Key Features of Beekeeper Studio
- Cross Platform: Available for Microsoft Windows, Mac and Linux
- Autocomplete SQL query editor with syntax highlighting
- Sensible keyboard-shortcuts
- Tabbed interface for multitasking
- Export a table to CSV, JSON, JSONL, or SQL with just a few clicks
- Sort and filter table data to find just what you need
- SSH tunneling
- Fast and simple table editing with the ability to stage changes.
- Save queries for later
- Edit Table Schemas
- Default dark theme
- Query run-history, so you can find that one query you got working 3 days ago
This article explains three methods of installing Beekeeper Studio on Ubuntu 20.04. Choose the installation method that is most appropriate for your environment.
Method 1: Installing Beekeeper Studio as a Snap Package
The easiest way to install Beekeeper Studio on Ubuntu 20.04 is by using the snap packaging system.
A snap package is a type of universal Linux package that you can enjoy irrespective of the distro. Its an self-contained software packages that include the binary all dependencies needed to run the application.
All you need is the snap service pre-configured, In the case of Ubuntu 20.04, it comes with snap pre-installed.
If snapd package is not already installed then you can install it by running following command.
$ sudo apt install snapd
Note: Snap packages can be installed from either the command-line or via the Ubuntu Software application.
This is actually the Snap version of the Beekeeper Studio. It can be used on any Linux distribution that has Snap support.
Open your terminal (
Ctrl+Alt+T) and type the following command to install the Beekeeper Studio package.
$ sudo snap install beekeeper-studio
At this step, you have successfully installed Beekeeper Studio on Ubuntu 20.04 system.
Type the following command to update Beekeeper Studio package.
$ sudo snap refresh --list
Method 2: Installing Beekeeper Studio using deb package
Beekeeper Studio has provided a repo for Debian and Ubuntu 16.04+ operating systems. Refer the following steps to install the application using deb package.
Install the GPG key.
$ wget --quiet -O - https://deb.beekeeperstudio.io/beekeeper.key | sudo apt-key add -
Add the repo to your apt lists directory.
$ echo "deb https://deb.beekeeperstudio.io stable main" | sudo tee /etc/apt/sources.list.d/beekeeper-studio-app.list
Now type the following command to Update apt and install the Beekeeper Studio package.
$ sudo apt update && sudo apt install beekeeper-studio
That’s it, Beekeeper Studio has been installed on your Ubuntu System, and you can start using it.
Method 3: Installing Beekeeper Studio via AppImage
Before installation let’s understand what is AppImage.
What is AppImage?
.deb packages for Debian/Ubuntu based Linux distributions and
.rpm for Fedora/SUSE based Linux distributions.
While these packages provide a convenient way of installing software to their respective distribution users, it is not the most convenient for the application developer.
The developers have to create multiple packages for multiple distributions. This is where AppImage comes into picture. AppImage is a universal software package format.
By packaging the software in AppImage, the developer provides just one file to rule them all. End user can use it in most modern Linux distributions.
Click on following button to download the latest stable version of Beekeeper Studio AppImage executable file for Linux.
The downloaded file name would be something like:
By default, the downloaded AppImage file won’t have the execution permission. You will have to change the permission on the file to make it executable and You don’t need root privilege to do that.
Now type the following command to make the AppImage executable.
$ chmod u+x Beekeeper-Studio-2.1.5-arm64.AppImage
Once you have made the AppImage file executable, just double click on it to run it Or run the following command to install through terminal.
Starting Beekeeper Studio
In the Activities search bar type “Beekeeper Studio” and click on the icon to launch the application.
Beekeeper Studio User Interface:
How to Uninstall Beekeeper Studio from Ubuntu 20.04
For some reason, If you want to uninstall Beekeeper Studio, refer following methods.
If you have installed Beekeeper Studio via Snap type the following command:
$ sudo snap remove beekeeper-studio
If you have installed the appication using
.deb then uninstall by running the below command:
$ sudo apt-get remove beekeeper-studio
If you have installed the application via AppImage:
Since the software is never installed, there is no need of uninstalling it. Just delete the associated Beekeeper Studio file and your software is removed from the system.
I hope that now you have a good understanding of How to install Beekeeper Studio on Ubuntu 20.04 LTS Focal Fossa.
If anyone does have any questions about what we covered in this guide then feel free to ask in the comment section below and I will do my best to answer those.