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

# ClickHouse

> Connect Mora to a ClickHouse instance via its HTTP interface.

## Prerequisites

* A ClickHouse server with the HTTP interface enabled (typically port 8443 for TLS or 8123 for plaintext).
* A user with read access to the target database.

## Required fields

| Field | Description | Example |
| - | - | - |
| **Name** | A display name for this datasource. | `Mora warehouse` |
| **URL** | The full HTTP(S) URL of your ClickHouse instance. | `https://your-instance.clickhouse.cloud:8443` |
| **Username** | The ClickHouse user. | `default` |
| **Password** | The user's password. | |

## Optional fields

| Field | Description | Example |
| - | - | - |
| **Database** | The default database to query. If omitted, ClickHouse uses its configured default (usually `default`). | `default` |

## Steps

1. Open **Settings → Datasources → New**.
2. Enter a name and select **ClickHouse** as the type.
3. Fill in the URL, username, and password.
4. Optionally specify a default database.
5. Click **Test connection** to verify.
6. Click **Create**.

## Troubleshooting

* **Connection refused**: Confirm the URL includes the correct port (8443 for ClickHouse Cloud, 8123 for self-hosted without TLS).
* **Authentication failed**: Verify the username and password. The default ClickHouse user is `default`.

## Related

* [Catalog sync](/datasources/catalog)
* [Managing datasources](/datasources/manage)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.