

Right click on your connection and choose SQL Editor > Open SQL Script to open a query editor:Īn example query against system.query_log: On the Main tab set the Host, Port, Username, and Password:
#Dbeaver download install
Select ClickHouse, this will add the ClickHouse JDBC driver to DBeaver:īy default the Driver properties > SSL will be set to false, if you are connecting to a ClickHouse server that requires SSL on the HTTP port, then set Driver properties > SSL to true:īuild the JDBC URL. Before we can install DBeaver on CentOS lets make sure that we have at least one of the database engines installed. Add a database Įither use the Database > New Database Connection menu or the New Database Connection icon in the Database Navigator to bring up the Connect to a database dialog: First, open your favorite Web browser, you can use Safari or any other Browser that you have Download the DBeaver installation file from the trusted link on. Gather your ClickHouse details ĭBeaver uses JDBC over HTTP(S) to connect to ClickHouse you will need:ĭBeaver is available at 3. DBeaver willĬonnect to ClickHouse using JDBC.

See the various offerings and capabilities here. DBeaver is available in multiple offerings.
