DBeaver is a database tool for building SQL queries, editing, and transferring data, viewing trees of objects, completing database administration tasks, monitoring database connection sessions, and a lot more.
DBeaver supports any database which has JDBC driver – MySQL/MariaDB, PostgreSQL, Oracle, DB2 LUW, Google BigQuery, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix, etc. If you need support for non-JDBC data sources such as WMI, MongoDB, Cassandra, Redis, then consider using DBeaver Enterprise Edition.
Follow steps below to Install DBeaver on Ubuntu 20.04|18.04 /16.04.
OpenJDK is the default Java development and runtime available on Debian repository. Run the following commands to have Java installed and set as default Java on your Ubuntu 22.04|20.04|18.04|16.04.
sudo apt update sudo apt -y install default-jdk
Confirm version:
saidul@saidul-Inspiron-5502:~$ java -version openjdk version "11.0.13" 2021-10-19 OpenJDK Runtime Environment (build 11.0.13+8-Ubuntu-0ubuntu1.20.04) OpenJDK 64-Bit Server VM (build 11.0.13+8-Ubuntu-0ubuntu1.20.04, mixed mode, sharing)
Add DBeaver repository to your Debian / Ubuntu by running the commands below:
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
After adding the repo, update the apt list and install DBeaver CE:
sudo apt update sudo apt install dbeaver-ce
Install DBeaver version can be checked using:
saidul@saidul-Inspiron-5502:~$ apt policy dbeaver-ce dbeaver-ce: Installed: 21.3.2 Candidate: 21.3.2 Version table: *** 21.3.2 500 500 https://dbeaver.io/debs/dbeaver-ce Packages 100 /var/lib/dpkg/status
Before launching and configuring DBeaver service, you may first need to create a database and database user to connect to. For this demonstration, I’ll use the MariaDB database server.