Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
Start or download DbVisualizer
DbVisualizer is available at https://www.dbvis.com/download/
- Gather your connection details
To connect to ClickHouse with HTTP(S) you need this information:
| Parameter(s) | Description |
|---|---|
HOST and PORT | Typically, the port is 8443 when using TLS or 8123 when not using TLS. |
DATABASE NAME | Out of the box, there is a database named default, use the name of the database that you want to connect to. |
USERNAME and PASSWORD | Out of the box, the username is default. Use the username appropriate for your use case. |
curl command.
If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.
- Built-in JDBC driver management
DbVisualizer has the most up-to-date JDBC drivers for ClickHouse included. It has full JDBC driver management built right in that points to the latest releases as well as historical versions for the drivers.
- Connect to ClickHouse
To connect a database with DbVisualizer, you must first create and setup a Database Connection.
- Create a new connection from Database->Create Database Connection and select a driver for your database from the popup menu.
- An Object View tab for the new connection is opened.
- Enter a name for the connection in the Name field, and optionally enter a description of the connection in the Notes field.
- Leave the Database Type as Auto Detect.
- If the selected driver in Driver Type is marked with a green check mark then it is ready to use. If it isn’t marked with a green check mark, you may have to configure the driver in the Driver Manager.
- Enter information about the database server in the remaining fields.
- Verify that a network connection can be established to the specified address and port by clicking the Ping Server button.
- If the result from Ping Server shows that the server can be reached, click Connect to connect to the database server.