How to install DBeaver on Ubuntu OS


For ease of access and work with databases, it’s always good to have the GUI. Working with a large number of databases sometimes requires us to use GUI solutions. In scenarios with a focus on the underlying cause, any GUI is welcome. Today, we will run through the process of how to install DBeaver on Ubuntu OS.

DBeaver is the database management tool and if you are installing it on a remote Ubuntu OS server, make sure you have the RDP service installed first and ready to work on it! Otherwise, just continue from here.

Specification:

OS Version: Ubuntu 20.04 (LTS) x64

Pre-requirements

Before we can install DBeaver on Ubuntu OS let’s make sure that we have at least one of the database engines installed. This is a list of DBeaver supported database engines:

  • MySQL
  • PostgreSQL
  • MariaDB
  • SQLite
  • Oracle
  • DB2
  • SQL Server
  • Sybase
  • MS Access
  • Teradata
  • Firebird
  • Derby

We are going to use the MariaDB server as it’s already installed on our test server. If you don’t have it, follow these steps to install MariaDB on the Ubuntu OS server and set up the MariaDB server for work to be done on it.

Ok, let’s install unavoidable JAVA support:

$ sudo apt-get -y  install openjdk-11-jdk openjdk-11-jre

Now that we have hit it off with JAVA, let’s add a repository required for DBeaver packages:

$ wget -O - https://dbeaver.io/debs/dbeaver.gpg.key | sudo apt-key add -
$ echo "deb https://dbeaver.io/debs/dbeaver-ce /" | sudo tee /etc/apt/sources.list.d/dbeaver.list
$ sudo apt-get update

Install DBeaver now:

$ sudo apt-get -y  install dbeaver-ce

That’s about it. Now, let’s fire it up and see how it works with previously installed MariaDB on this box:

DBeaver | Ubuntu
DBeaver | Ubuntu

To connect to our MariaDB database server we need to create a new database connection like this:

DBeaver connecting to database | Ubuntu
DBeaver connecting to database | Ubuntu

Connection process require us to select which database engine we are using. In this case, we’ll select MariaDB:

DBeaver connecting to MariaDB | Ubuntu
DBeaver connecting to MariaDB | Ubuntu

And now the connection details. These are the details we used in the process of setting up the MariaDB server:

DBeaver database connection details
DBeaver database connection details

If we didn’t mess up anything the next window should be:

DBeaver connected to database | Ubuntu
DBeaver connected to database | Ubuntu

That’s it! The database GUI is installed and we can now proceed to actual work 😁.

Share this post

Share this link via

Or copy link