Skip to main content

Setting up DBeaver

DBeaver is an open source graphical SQL client that supports PostgreSQL, among multiple other Relational Database Management Systems (RDBMS).

It can be greatly helpful in exploring the data in the parsomics relational database, as it allows users to:

  • Read the data in interactive tables (whose columns can be filtered, sorted, etc)
  • Generate, view, and edit an Entity-Relationship diagram for the database schema
  • Create, view, edit, and execute SQL scripts, that you can reuse later
  • Glance at the indexes, constraints, and data types in the database
  • View statistics, such as the number of rows in each table
  • Etc...
info

The parsomics project is not affiliated with the DBeaver project in any way.

Guide​

Step 1: Install DBeaver​

Follow the official instructions at DBeaver's website.

Step 2: Install the PostgreSQL driver for DBeaver​

To enable compatibility with PostgreSQL, you must install the PostgreSQL driver for DBeaver. To do that, start setting up a new database connection and DBeaver will ask which database driver you want to use. Select "PostgreSQL".

DBeaver's connection setup screen, showing the option to install the PostgreSQL driver

Step 3: Setup the connection​

Finish setting up the connection to the parsomics database by entering the credentials, as documented in the previous section.

DBeaver's connection setup screen, showing the input fields for database host, port, username, and password

Step 4: Explore the database​

Now you are off! Use DBeaver to explore the data in the parsomics database.