Skip to content

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⚓︎

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.

784

Select ClickHouse driver⚓︎

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

784

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.

784

Set the Use SSL toggle⚓︎

Select Use SSL.

784

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.

1
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.