Skip to main content

Connecting to DBeaver

DBeaver is a professional-grade, multi-platform, open source, flexible and powerful database tool for developers, administrators and analysts. It can connect to dozens of databases—both open source and proprietary.

If you already use DBeaver, you might want to continue to use it as the database querying tool of choice or if you prefer to use a desktop application to query and manage queries, DBeaver is a great choice.

Since Zipstack supports JDBC connectivity, you can connect to any Data Sources or HyperTables you define in Zipstack via DBeaver. You then have a desktop-based, professional-grade database tool to manage and query your data.

Installing DBeaver​

DBeaver is available to download for all major platforms from https://dbeaver.io/. If you are on Linux, the easiest way to install it is via your package manager. If you use Homebrew on the Mac, you can install DBeaver using it.

Setting up DBeaver​

Step 1: Fire up DBeaver and choose Database > New Database Connection from the menu. Select All from the list of databases from in the side panel as shown below. In the search bar above, type “trino”. This filters the list of databases to relevant ones. Choose Trino from the list and click on the Next button.

Step 2: Now sign into the Zipstack Mesh console and navigate to Data Browser in the side panel. You’ll now see a tree view with HyperTables and Data Sources. Click on Data Sources. You’ll be able to see a JDBC string with which you can connect to your Zipstack Mesh cluster from any tool (like DBeaver) or programming language that supports JDBC.

Step 3: Now, switch back to DBeaver and continue entering information in the wizard. For the Connect by option, choose URL. Enter the JDBC URL you copied from the Zipstack UI into the JDBC URL field. Next, in the Authentication (Database Native) section, you’ll need to enter the same credentials you use to log into the Zipstack UI for the username and password fields. Clicking on Finish should configure DBeaver to connect to your Zipstack cluster. You might be prompted to download the Trino plugin for DBeaver so that DBeaver can successfully connect to your Zipstack cluster. You should complete this step if it does appear.

Congratulations! You’ve now successfully connected DBeaver to your Zipstack cluster and should be able to browse schema and data or query data from data sources and HyperTables. The catalog named “mesh” has all the data sources as tables under it, while HyperTables are found as views under the catalog named “hypertables”.