Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

0
186

Follow through this tutorial to learn how to install DBeaver on Ubuntu 22.04/Ubuntu 20.04. DBeaver is free and open source universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is free and open-source (ASL).
  • It is multiplatform.
  • It is based on opensource framework and allows writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for different databases and different database management utilities (e.g. ERD, data transfer, compare, data export/import, mock data generation, etc).
  • It has a great number of features.

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

DBeaver is available as community edition and an enterprise edition. Based on your requirements, feel free choose your preferred edition.

This guide however focuses on the installation of the Dbeaver CE version.

There are two ways in which you can install DBeaver on Ubuntu 22.04/Ubuntu 20.04;

  1. Install DBeaver on Ubuntu using the DEB Binary Package
  2. Install DBeaver on Ubuntu from Snap Store

Install DBeaver on Ubuntu the Linux Ubuntu Binary Package

Navigate to DBeaver download’s page and grab the DBeaver Linux Ubuntu binary package;

You can also copy the link to the installer and download using curl or wget commands;

wget https://dbeaver.io/files/dbeaver-ce_latest_amd64.deb

Once the download is complete, execute the commands below to install DBeaver on Ubuntu 22.04/Ubuntu 20.04;

sudo apt update
sudo apt install ./dbeaver-ce_latest_amd64.deb

Install DBeaver on Ubuntu from Snap Store

You can also be able to install DBeaver on Ubuntu 22.04/Ubuntu 20.04 from Snap store.

Snaps is installed by default on Ubuntu.

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04 from Snap store;

sudo snap install dbeaver-ce

Running DBeaver on Ubuntu 22.04/Ubuntu 20.04

You can now launch DBeaver from your system activities;

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

Dbeaver UI;

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

You can choose to load the sample database, by clicking Yes.

Sample SQLite database is loaded. When you click on it, you will be prompted to download the driver.

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

The driver will then be downloaded and installed. After which you can now see the database profile setup.

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

You can now administer your database.

For example, you can your SQL queries against your database tables right from DBeaver. Just right click on the database profile > SQL Editor > Open SQL Script.

Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

This opens up a query editor. Enter the queries you want to run against your database tables;

See for example, to select everything from the Employees tables;

select * from Employees
Install DBeaver on Ubuntu 22.04/Ubuntu 20.04

Hover the mouse over the other icons to see what they can do.

You can add more databases into your DBeaver for easy administration. That completes our guide on how to install DBeaver on Ubuntu 22.04/Ubuntu 20.04.

Read more on the DBeaver Wiki Page.

Other Tutorials

Install Couchbase Server on CentOS/Rocky Linux

Enable MSSQL Server and Database Level Auditing

LEAVE A REPLY

Please enter your comment!
Please enter your name here