> ## Documentation Index
> Fetch the complete documentation index at: https://docs.resolve.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickHouse

The ClickHouse integration can be configured via Resolve's UI. Resolve AI can query ClickHouse for **metrics**, **logs**, and **database** data.

## Prerequisites

* A reachable ClickHouse HTTPS endpoint. ClickHouse Cloud exposes this on port `8443` (e.g., `https://<host>.clickhouse.cloud:8443`). Self-hosted ClickHouse typically listens on `8443` (HTTPS) or `8123` (HTTP). See [ClickHouse network ports](https://clickhouse.com/docs/guides/sre/network-ports).
* A **read-only user** with `SELECT` access on the databases Resolve AI should query. See [Permissions for queries](https://clickhouse.com/docs/operations/settings/permissions-for-queries) for the recommended `readonly` settings profile.

## Connect ClickHouse

1. Open [ClickHouse Integration](https://app0.resolve.ai/integrations/clickhouse/connect) in Resolve AI.
2. Click **Add Connection**.
3. Enter a **Name** (e.g., `ClickHouse-Main`).
4. Leave **Environments** blank to ingest data from all environments, or list specific ones that match your Satellite config.
5. Enter the **URL** of your ClickHouse HTTPS endpoint, including the port (e.g., `https://<host>.clickhouse.cloud:8443`).
6. Enter the **Username** and **Password** of the read-only user.
7. Click **Save**.

## Verify the integration

Once saved, the connection status is shown on the integration page. A green status indicates Resolve AI can reach ClickHouse and run test queries. If the check fails:

* **Network**: confirm the ClickHouse URL is reachable from Resolve AI's cloud, or from your [Resolve Satellite](/resolve-satellite) if you deploy on-prem.
* **Credentials**: test the username and password with `clickhouse-client` or `curl` against the HTTPS endpoint.
* **Permissions**: confirm the ClickHouse user has `SELECT` on the databases Resolve AI should query.