DBeaver is a free (and open source) multi-platform, cross-platform database tool for developers, SQL programmers, database administrators, and analysts. DBeaver is written in Java, based on the Eclipse platform, and supports supports any database that ha a JDBC driver, including PostgreSQL, MariaDB, and MySQL. And, using the PostgreSQL JDBC driver, you can use DBeaver with YugabyteDB.
The DBeaver Community Edition includes these features:
- Open source
- Connection and metadata browser
- SQL query editor and executor
- Rich in-line data editor
- Entity relationship (ER) diagrams
The DBeaver Enterprise Edition adds support for non-JDBC data sources, including MongoDB, Cassandra, and Redis.
Before you begin
Before getting started with DBeaver, make sure you meet the following prerequisites.
Your YugabyteDB cluster should be up and running. If you’re new to YugabyteDB, create a local cluster in less than five minutes following the steps in Quick Start.
Java Runtime Environment (JRE)
DBeaver requires a Java runtime (or JDK) for Java 8 or later. Some of the installers include a JRE, accessible only to DBeaver.
PostgreSQL JDBC driver
The PostgreSQL JDBC driver can be used with DBeaver to work with YugabyteDB databases.
To connect DBeaver to a YugabyteDB cluster, you need the PostgreSQL JDBC driver installed. To download the current version that supports Java 8 or later, go to the PostgreSQL JDBC Driver download page.
- Download the distribution package for the operating system on your client computer from the DBeaver downloads page.
- Install DBeaver following the steps on the DBeaver Installation page.
Configure the JDBC driver
- Start the DBeaver application. The DBeaver application window appears.
- On the menu, select Database > Driver Manager. The Driver Manager window appears.
- Select PostgreSQL and then click Copy. The Create new driver window appears with a copy of the default PostgreSQL driver settings.
Make the following changes in the Settings:
YugabyteDB— Default name is “PostgreSQL”, but using “YugabyteDB” might help you not confuse this driver’s settings with PostgreSQL connections using the PostgreSQL port of
- Driver Type:
- Class Name:
- URL Template:
- Default Port:
In the Libraries tab, select the PostgreSQL JDBC driver JAR file to be used.
Click OK. The Create new driver window closes.
Verify that the new “YugabyteDB” driver appears in the Driver Manager listing and then click Close.
Create a database connection
On the DBeaver menu, select Database > New Connection. The Connect to database window appears.
In the Select your database listing, select YugabyteDB and then click Next.
In the Connection Settings, add the following settings:
- Database: Clear the default value (
- Password: Leave blank if YSQL authentication is not enabled. If enabled, add the password for
- Show all databases: Select this option.
Click Test Connection to verify that the connection is successful.
In the DBeaver application, you should now see “Yugabyte - localhost” in the Database Navigator panel.
You can now expand the listing and see a listing of all databases available to the
If you’re looking for sample databases to explore YugabyteDB using DBeaver, see Sample data.