Connecting Draxlr to ClickHouse

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/integrations/data-visualization/community_integrations/draxlr-and-clickhouse.md)

Community Maintained

Draxlr offers an intuitive interface for connecting to your ClickHouse database, enabling your team to explore, visualize, and publish insights within minutes. This guide will walk you through the steps to establish a successful connection.

## 1. Get your ClickHouse credentials[​](#1-get-your-clickhouse-credentials "Direct link to 1. Get your ClickHouse credentials")

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

The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console.
Select a service and click **Connect**:

Choose **HTTPS**. Connection details are displayed in an example `curl` command.

If you're using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.

## 2. Connect Draxlr to ClickHouse[​](#2--connect-draxlr-to-clickhouse "Direct link to 2. Connect Draxlr to ClickHouse")

1. Click on the **Connect a Database** button on the navbar.
2. Select **ClickHouse** from the list of available databases and click next.
3. Choose one of the hosting services and click next.
4. Use any name in the **Connection Name** field.
5. Add the connection details in the form.

6. Click on the **Next** button and wait for the connection to be established. You will see the tables page if the connection is successful.

## 4. Explore your data[​](#4-explore-your-data "Direct link to 4. Explore your data")

1. Click on one of the tables in the list.
2. It will take you to the explore page to see the data in the table.
3. You can start adding the filters, make joins and add sort to your data.

4. You can also use the **Graph** button and select the graph type to visualize the data.

## 4. Using SQL queries[​](#4-using-sql-queries "Direct link to 4. Using SQL queries")

1. Click on the Explore button on the navbar.
2. Click the **Raw Query** button and enter your query in the text area.

3. Click on the **Execute Query** button to see the results.

## 4. Saving you query[​](#4-saving-you-query "Direct link to 4. Saving you query")

1. After executing your query, click on the **Save Query** button.

2. You can name to query in **Query Name** text box and select a folder to categories it.
3. You can also use **Add to dashboard** option to add the result to dashboard.
4. Click on the **Save** button to save the query.

## 5. Building dashboards[​](#5-building-dashboards "Direct link to 5. Building dashboards")

1. Click on the **Dashboards** button on the navbar.

2. You can add a new dashboard by clicking on the **Add +** button on the left sidebar.
3. To add a new widget, click on the **Add** button on the top right corner.
4. You can select a query from the list of saved queries and choose the visualization type then click on the **Add Dashboard Item** button.

## Learn more[​](#learn-more "Direct link to Learn more")

To know more about Draxlr you can visit [Draxlr documentation](https://draxlr.notion.site/draxlr/Draxlr-Docs-d228b23383f64d00a70836ff9643a928) site.

- [1. Get your ClickHouse credentials](#1-get-your-clickhouse-credentials)- [2. Connect Draxlr to ClickHouse](#2--connect-draxlr-to-clickhouse)- [4. Explore your data](#4-explore-your-data)- [4. Using SQL queries](#4-using-sql-queries)- [4. Saving you query](#4-saving-you-query)- [5. Building dashboards](#5-building-dashboards)- [Learn more](#learn-more)

Was this page helpful?