> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-detect-table-modification.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
> Draxlr is a Business intelligence tool with data visualization and analytics.
# Connecting Draxlr to ClickHouse
export const CommunityMaintainedBadge = () => {
return ;
};
export const Image = ({img, alt, size = "lg"}) => {
const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
return
;
};
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.
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.
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.
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.
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.
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.
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
To know more about Draxlr you can visit [Draxlr documentation](https://draxlr.notion.site/draxlr/Draxlr-Docs-d228b23383f64d00a70836ff9643a928) site.
