Installing database GUIs on your Virtual Machine

PostgreSQL Graphical User Interface (GUI) tools allow users to easily interact with the workspace database from the Virtual Machine. These graphical database management tools help users manipulate, visualize, and manage the data stored in the database.

dbeaver_zoom.png DBeaver GUI

Installing database GUIs

1. Download drivers

Database drivers are needed to connect the GUIs with the workspace database. A driver is a computer program that will connect a generic interface to a specific database implementation.

Most database GUIs require a JDBC (Java Database Connectivity) driver. Please download the PostgreSQL JDBC driver from here.

2. Download GUI

DBeaver and DBVisualizer are examples of database GUIs that you can install in your workspace in either a Windows or Linux Virtual Machine in your workspace.

dbvis-1.png DBVisualizer GUI

First, download the installation files of a preferred database GUI for your Virtual Machine operating system on your local computer:

Then, upload them to the workspace together with the previously downloaded JDBC driver.

3. Install GUI

If you are working in a Windows Virtual Machine, simply run the installation file and follow the installation instructions.

To run the installation in a Linux Virtual Machine, move to the same folder as the installation file and run:

sudo dpkg -i <installation_file>.deb

Once installed, you can start it by typing dbeaver or dbvis for DBeaver and DBVisualizer, respectively.

4. Configure the database connection

The credentials of the database are needed to connect the GUI with the workspace database. For security reasons, please contact the Service Desk to finish the configuration.

Working with database GUIs

Once the connection is set up, you can explore the workspace database using the database navigator found in the left-hand sidebar in both of the GUIs.


You can also easily view the table data, create and run SQL queries, and view Entity-Relationship diagrams using these tools. To find out how to do this, please visit the DBeaver and DBVisualizer documentation sites.

Updated on August 31, 2023

Was this article helpful?