DBeaver

Use DBeaver with Hydrolix

DBeaver is a free cross-platform database tool which supports many popular SQL databases.

This page describes the steps to connect a DBeaver client to the native HTTP (ClickHouse) interface in a Hydrolix cluster.

Overview of steps

• Create a new connection object
• Select ClickHouse driver
• Enter JDBC URL and credentials
• Set the SSL Toggle
• Complete configuration

Prerequisites

Local software and configuration

• Download DBeaver and install. These instructions cover version 25.0.x
• Be ready with your cluster hostname and authentication credentials

Hydrolix cluster configuration

• Ensure that you've allowed inbound access to your cluster
• Ensure your cluster is running the ClickHouse HTTP server. By default, Hydrolix clusters run a ClickHouse HTTP server that listens on port 8088. That server won't be running if your Hydrolix cluster configuration contains disable_traefik_clickhouse_http_port: true

Connect using DBeaver

Create a new connection object

Open General and right click Connections. From the context menu, select Create, then Connection.

Select ClickHouse driver

Select ClickHouse database driver. Don't use the ClickHouse (Legacy) driver.

Enter JDBC URL and credentials

1. Select the URL radio button in the Connect by field.
2. Enter the entire JDBC URL.
   • Scheme is jdbc:clickhouse
   • Replace {myhost}.hydrolix.live with your cluster name
   • Use 8088 as the port
   • Suffix the JBDC URL with the /query path
3. Enter your authentication credentials.

Set the Use SSL toggle

Select Use SSL.

Complete configuration

1. Select OK.
2. You can now query your Hydrolix cluster using your DBeaver client.

Example query

The hydro.logs table contains log event data from the local cluster and will always be present.

Select menu item SQL Editor > New SQL script and test your DBeaver configuration using the following query.

SELECT COUNT() FROM hydro.logs WHERE timestamp > NOW() - INTERVAL 24 HOUR

The query should succeed, showing the number of log events collected in the last day.