Install Beekeeper Studio SQL Manager on Ubuntu 24.04|22.04

CloudSpinx
February 25, 2025
8:42 am
No Comments

This guide demonstrate how to install Beekeeper Studio SQL Database Manager on Ubuntu 24.04|22.04. Beekeeper Studio is a free SQL editor and database manager that runs on Linux, Mac OS X, and Windows. Beekeeper Studio is created with the Vue.js web framework and is MIT (Massachusetts Institute of Technology) licensed.

The following databases are supported by Beekeeper Studio:

MySQL
MariaDB
Postgres
SQLite
CockroachDB
SQL Server
Amazon Redshift

Benefits of Using Beekeeper Studio

Here are the advantages of using Beekeeper Studio:

It’s quite easy to use.
Beekeeper is a free and open-source program.
It has a Dark/Light color scheme.
It’s portable.

Features of Beekeeper Studio

The following are the cool features of Beekeeper Studio:

SQL query editor with autocomplete and syntax highlighting.
You may multitask with the tabbed UI.
To discover exactly what you need, sort and filter table data.
It’s fairly simple to connect across a firewall using SSL or to tunnel through SSH.
Keyboard shortcuts that make sense.
Queries can be saved for later use.
It’s simple to export data from other sources. CSV, JSON, JSONL, or SQL files, for example.
Query run-history, so you can track down that one query that worked three days ago.
Dark is the default theme.

Install Beekeeper Studio SQL Database Manager on Ubuntu 24.04|22.04

The following are the requirements for successful installation of Beekeeper Studio on Ubuntu 24.04|22.04.

Ubuntu 24.04|22.04 Desktop.
Minimum Ram of 4GB.
A user account with root access.
500GB Disk Drive.

There are two methods to Install Beekeeper Studio on Ubuntu:

From its repo.
Using Snapd.

Method 1: Install Beekeeper Studio on Ubuntu from its repo

Follow the steps outlined in this section to install and use Beekeeper Studio on Ubuntu.

Step 1: System Update

You may confirm that all existing packages on Ubuntu are up to date by executing the following command:

sudo apt update && sudo apt upgrade

Step 2: Add Beekeeper repository to Ubuntu 24.04|22.04.

Enable Beekeepe Studio repo as follows.

Install Beekeer Studio GPG key, and add Beekeeper Studio repo to Ubuntu apt lists directory:

# Install our GPG key
curl -fsSL https://deb.beekeeperstudio.io/beekeeper.key | sudo gpg --dearmor --output /usr/share/keyrings/beekeeper.gpg \
  && sudo chmod go+r /usr/share/keyrings/beekeeper.gpg \
  && 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 > /dev/null

Now, update your repository list:

sudo apt update -y

Step 3: Install Beekeeper Studio on Ubuntu 24.04|22.04.

To install Beekeeper Studio on Ubuntu, use the command below:

$ sudo apt install beekeeper-studio
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following NEW packages will be installed:
  beekeeper-studio
0 upgraded, 1 newly installed, 0 to remove and 9 not upgraded.
Need to get 128 MB of archives.

Method 2: Install Beekeeper on Ubuntu 24.04|22.04 using Snapd.

Enable snapd on Ubuntu system.

sudo apt update -y
sudo apt install snapd

Install Beekeeper Studio by running the following command:

sudo snap install beekeeper-studio

Launch Beekeeper Studio on Ubuntu

To start Beekeeper Studio, go to the App Manager’s Activities section and search for Beekeeper Studio.

The Beekeeper Studio will begin with the page shown below. Click connect and selecting the database to link to.

For this guide, we will link MariaDB database instance. Install MariaDB on Ubuntu 24.04|22.04 as shown below.

sudo apt install mariadb-server mariadb-client

Sample Output:

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libfcgi-bin libfcgi-perl libfcgi0t64
  libhtml-template-perl libmariadb3 libmysqlclient21 libsnappy1v5 liburing2 mariadb-client-core mariadb-common mariadb-plugin-provider-bzip2
  mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo mariadb-plugin-provider-snappy mariadb-server-core
  mysql-common pv socat
Suggested packages:
  libmldbm-perl libnet-daemon-perl libsql-statement-perl libipc-sharedcache-perl mailx mariadb-test doc-base
The following NEW packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libconfig-inifiles-perl libdbd-mysql-perl libdbi-perl libfcgi-bin libfcgi-perl libfcgi0t64
  libhtml-template-perl libmariadb3 libmysqlclient21 libsnappy1v5 liburing2 mariadb-client mariadb-client-core mariadb-common
  mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo
  mariadb-plugin-provider-snappy mariadb-server mariadb-server-core mysql-common pv socat
0 upgraded, 27 newly installed, 0 to remove and 9 not upgraded.
Need to get 18.7 MB of archives.
After this operation, 196 MB of additional disk space will be used.
Do you want to continue? [Y/n] y

Now, Start and enable MariaDB as below:

sudo systemctl enable --now mariadb

Secure MariaDB database:

$ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): <ENTER>
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password: <ENTER PASSWORD>
Re-enter new password: <RE-ENTER PASSWORD>
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

sudo mysql -u root -p

Now, as shown below, establish a sample database and user.

CREATE DATABASE HiveDB;
CREATE USER 'Bee'@'localhost' IDENTIFIED BY 'StrongPassw0rd';
GRANT ALL PRIVILEGES ON HiveDB . * TO 'Bee'@'localhost';
FLUSH PRIVILEGES;
QUIT;

Now we’ll use Beekeeper to connect to the database, as shown below. Fill in the required database information.

Now Click Test to check and verify if everything is in working order. If everything is in order, you should see the pop-up below. Now you’ll need to connect to the database. You will not be prompted to input credentials if you save the connection for subsequent use.