Beekeeper Studio is an open-source completely free cross-platform SQL editor and database manager. It is available for Mac, Linux, and Windows. It is an SQL client for managing MySQL, Postgres, SQLite, SQL Server, etc that is easier to use and very smooth. Being MIT licensed, it is completely free to use.
Beekeeper Studio comes with a UI that allows you to enter the connection details for your database. However, it doesn’t support Unix socket connections for PSQL or MYSQL but only TCP connections.
Key Features of Beekeeper Studio
Beekeeper Studio SQL Database Manager has many features which include the following:
- It has SQL auto-completion abilities with syntax highlighting to help worker faster.
- It allows the developers to open multiple tabs to make it easy to switch between tabs.
- It alows you to save queries for later use across all the tabs.
- It is cross-platform
- It is easier to sort and filter table data for easy search.
- With Beekeeper Studio, it is very easy to edit table data and schemas.
- Exporting data from other sources is pretty easy. e.g CSV, JSON, JSONL, or SQL files.
- Connecting through firewall via SSL or tunnelling through SSH is very easy.
- It has Nice looking dark mode and light mode themes.
Install Beekeeper Studio on Rocky Linux 9|AlmaLinux 9
To install Beekeeper Studio SQL Database Manager in your Rocky / Alma Linux, ensure your system meets the following requirements:
Pre-requisites:
- Minimum memory of 4GB.
- 500GB hard disk.
We now briefly look at the installation in this section.
Step 1: Update your system.
Refresh your system packages
sudo dnf update -y Step 2: Install snapd package on Rocky / Alma Linux 9
Beekeeper packages are not available for download on Rocky / Alma Linux repository and must be installed via snap.
To install snapd:
2.1: Add EPEL repository to Rocky / Alma Linux.
We will add the Fedora EPEL repository.
sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpmThe output:
Last metadata expiration check: 0:08:21 ago on Fri 21 Feb 2025 11:37:21 AM EAT.
epel-release-latest-9.noarch.rpm 21 kB/s | 19 kB 00:00
Dependencies resolved.
==================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================
Installing:
epel-release noarch 9-9.el9 @commandline 19 k
Transaction Summary
==================================================================================================================================================
Install 1 Package
Total size: 19 k
Installed size: 26 k
Is this ok [y/N]: y2.2: Upgrade Rocky / Alma Linux system:
Once the EPEL repository from Fedora is added to your system, upgrade your system to effect and refresh packages.
sudo dnf upgrade2.3: Add recommended optional extras repositories (RHEL system)
sudo dnf install subscription-manager -y
sudo subscription-manager repos --enable "rhel-*-optional-rpms" --enable "rhel-*-extras-rpms"
sudo dnf update -y2.4: Install snapd package on Rocky / Alma Linux 9:
Finally, install snapd:
sudo dnf install snapdThe output:
Last metadata expiration check: 0:02:12 ago on Fri 21 Feb 2025 11:47:12 AM EAT.
Dependencies resolved.
==================================================================================================================================================
Package Architecture Version Repository Size
==================================================================================================================================================
Installing:
snapd x86_64 2.67-0.el9 epel 18 M
Installing dependencies:
snap-confine x86_64 2.67-0.el9 epel 2.9 M
snapd-selinux noarch 2.67-0.el9 epel 82 k
xdelta x86_64 3.1.0-17.el9 epel 87 k
Transaction Summary
==================================================================================================================================================
Install 4 Packages
Total download size: 21 M
Installed size: 69 M
Is this ok [y/N]: y
Downloading Packages:
(1/4): snapd-selinux-2.67-0.el9.noarch.rpm 653 kB/s | 82 kB 00:00
(2/4): xdelta-3.1.0-17.el9.x86_64.rpm 1.4 MB/s | 87 kB 00:00
(3/4): snap-confine-2.67-0.el9.x86_64.rpm 4.3 MB/s | 2.9 MB 00:00
(4/4): snapd-2.67-0.el9.x86_64.rpm 14 MB/s | 18 MB 00:01
--------------------------------------------------------------------------------------------------------------------------------------------------
Total 8.9 MB/s | 21 MB 00:02
Extra Packages for Enterprise Linux 9 - x86_64 1.6 MB/s | 1.6 kB 00:00
Importing GPG key 0x3228467C:
Userid : "Fedora (epel9) <[email protected]>"
Fingerprint: FF8A D134 4597 106E CE81 3B91 8A38 72BF 3228 467C
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-9
Is this ok [y/N]: y2.5: Enable snapd.socket
To make snapd available on the next boot:
sudo systemctl enable --now snapd.socket2.6: Enable classic snap support
To enable classic snap support, create a symbolic link between /var/lib/snapd/snap and snap.
sudo ln -s /var/lib/snapd/snap /snapSnap package is now successfully installed.
Step 3: Install Beekeeper Studio via snap
To install Beekeeper Studio via snap, run the command:
sudo snap install beekeeper-studioThe output :
2025-02-21T11:55:17+03:00 INFO Waiting for automatic snapd restart...
beekeeper-studio 5.0.9 from Beekeeper Studio (matthew-rathbone) installedStep 4: Launch Beekeeper Studio
To launch Beekeeper Studio, navigate to Activities on the App Manager and search for Beekeeper Studio.
On double-clicking on the icon, it opens another window where you choose the connection type:
For this guide, I will demonstrate how to connect to the MariaDB instance. Install MariaDB on Rocky / AlmaLinux 9 as below.
sudo yum install mariadb-server -yStart and enable MariaDB:
sudo systemctl enable --now mariadbHarden the Instance:
sudo mariadb-secure-installationLogin to the MariaDB shell:
sudo mysql -u root -pNow create a sample database and user as below:
CREATE DATABASE sampleDB;
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'Passw0rd';
GRANT ALL PRIVILEGES ON sampleDB . * TO 'admin'@'localhost';
FLUSH PRIVILEGES;
EXIT;Now we will connect to the database using Beekeeper as below. Fill in the appropriate details for the database.
Now connect to the database. You can save the connection for later use, you won’t be required to provide credentials. On successful authentication, you will be connected to the database as shown above. Here, you can run SQL queries.
SSH Key Access For The Snap
If you wish to use SSH tunneling you need to manually enable access to the .ssh directory due to the snap security model. Run the command:
sudo snap connect beekeeper-studio:ssh-keys :ssh-keysUnfortunately, Snaps have no way to access your SSH Agent. To use SSH Agent use deb or AppImage version of the app.
Conclusion
That sums up our article and we do hope it has been helpful to you. Always feel free to leave a comment below. We thank you sincerely for making us your first stop blog.
Check out more resources:
