Last update: 2025-12-17T10:19:32.000Z
Content:
---
title: "ClickHouse Interface · Tinybird Docs"
theme-color: "#171612"
description: "Learn how to connect BI tools and SQL clients to Tinybird using the ClickHouse HTTP interface for data visualization and analysis."
inkeep:version: "forward"
---




# ClickHouse Interface [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#clickhouse-interface)

Copy as MD Tinybird is compatible with the ClickHouse® HTTP interface, enabling you to connect popular BI tools, SQL clients, and data visualization platforms directly to your Tinybird Data Sources.

This interface provides a standardized way to query your data using SQL, making it easy to integrate Tinybird with your existing analytics workflow and third-party tools.

The ClickHouse connection to Tinybird is read-only. You can use it to query, visualize, and analyze data from your Tinybird Data Sources, but you cannot modify data through this connection.

## Connection parameters [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#connection-parameters)

To connect any ClickHouse®-compatible tool to Tinybird, use these standard connection parameters:

### Basic connection settings [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#basic-connection-settings)

Protocol: HTTPS
Host: clickhouse.<REGION>.tinybird.co
Port: 443 (HTTPS)
SSL/TLS: Required (enabled) Replace `<REGION>` with your workspace region (e.g., `eu-west-1.aws`, `us-east-1` ).

### ClickHouse interface hosts [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#clickhouse-interface-hosts)

Here are the ClickHouse HTTP hosts for each Tinybird region:

| Region | Provider | Provider region | ClickHouse interface URL |
| --- | --- | --- | --- |
| Europe | GCP | europe-west2 | clickhouse.europe-west2.gcp.tinybird.co |
| Europe | GCP | europe-west3 | clickhouse.tinybird.co |
| US East | GCP | us-east4 | clickhouse.us-east.tinybird.co |
| North America | GCP | northamerica-northeast2 | clickhouse.northamerica-northeast2.gcp.tinybird.co |
| Europe | AWS | eu-central-1 | clickhouse.eu-central-1.aws.tinybird.co |
| Europe | AWS | eu-west-1 | clickhouse.eu-west-1.aws.tinybird.co |
| US East | AWS | us-east-1 | clickhouse.us-east.aws.tinybird.co |
| US West | AWS | us-west-2 | clickhouse.us-west-2.aws.tinybird.co |

### Authentication [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#authentication)

Username: <WORKSPACE_NAME>  # Optional, for identification purposes
Password: <TOKEN>           # Your Tinybird Auth Token The username field is not used for authentication but helps identify the connection. The actual authentication is done via the Auth Token in the password field.

### Auth Token requirements [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#auth-token-requirements)

Your Auth Token must have the following permissions:

- **  Read access**   to Workspace Data Sources
- **  Read access**   to Service Data Sources (if needed)
- **  Read access**   to Organization Data Sources (if needed)

You can create a token with these permissions with these commands:

**In Forward**

tb --cloud token create static <token_name> --scope "WORKSPACE:READ_ALL" --scope "ORG_DATASOURCES:READ" **In Classic**

tb token create <token_name> --scope "WORKSPACE:READ_ALL" --scope "ORG_DATASOURCES:READ"
### Tinybird Local [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#tinybird-local)

To connect to your local development environment using Tinybird Local, use these connection parameters:

Protocol: HTTP
Host: localhost
Port: 7182
SSL/TLS: Disabled You can test the connection using curl:

curl -H "X-ClickHouse-Key: your_token_here" \
     "http://localhost:7182/?query=SELECT%20*%20FROM%20system.tables"
## Available databases [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#available-databases)

The ClickHouse interface exposes four databases:

- ** `<your_workspace_name>`**   : Contains your Workspace's Data Sources.
- ** `tinybird`**   : Contains[  Workspace Service Data Sources](/docs/classic/monitoring/service-datasources#service-data-sources)   , such as `tinybird.datasources_ops_log`   and `tinybird.pipe_stats_rt`  .
- ** `organization`**   : Contains[  Organization Service Data Sources](/docs/classic/monitoring/service-datasources#organization-service-data-sources)   , such as `organization.workspaces`   and `organization.pipe_stats_rt`  .
- ** `system`**   : Contains a subset of system tables, including `system.tables`  , `system.columns`  , `system.parts`  , `system.part_log`  , `system.query_views_log`   , and `system.query_log`  .

Querying `system.query_log`, `system.query_views_log` or `system.part_log` without filters is too resource-intensive and will timeout. Always apply a time filter on the `event_time` column to query a reasonable time frame.

## Compatible tools [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#compatible-tools)

Tinybird's ClickHouse® interface enables integration with various BI tools and SQL clients:

### Business Intelligence platforms [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#business-intelligence-platforms)

- **[  Grafana](guides/connect-grafana)**
- **[  Hex](guides/connect-hex)**
- **[  Metabase](guides/connect-metabase)**
- **[  Superset](guides/connect-superset)**

### SQL clients and IDEs [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#sql-clients-and-ides)

- **[  DataGrip](guides/connect-datagrip)**
- **[  DBeaver](guides/connect-dbeaver)**

### Other compatible tools [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#other-compatible-tools)

Any tool that supports ClickHouse® HTTP interface can potentially work with Tinybird, including:

- Tableau (via its ClickHouse® connector)
- Looker (via custom connection)
- Other JetBrains IDEs
- Retool and other low-code platforms

## Limitations [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#limitations)

The interface is **read-only** . You cannot perform `INSERT`, `UPDATE`, `DELETE` , or any DDL operations ( `CREATE`, `ALTER`, `DROP` ).

## Observability [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#observability)

Queries made through the ClickHouse® interface are logged as [Query API](/docs/api-reference/query-api) requests in the pipe statistics Data Sources. You can monitor these queries using:

- `tinybird.pipe_stats_rt`   and `tinybird.pipe_stats`   - Workspace-level statistics
- `organization.pipe_stats_rt`   and `organization.pipe_stats`   - Organization-level statistics

ClickHouse® queries appear with `pipe_id` and `pipe_name` as `'query_api'` . The actual SQL query is available in the `parameters` column under the `q` field.

For more details, see [Service Data Sources](/docs/monitoring/service-datasources).

## Troubleshooting [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#troubleshooting)

**Invalid host or region**

Error: Connection refused Verify your region and use the correct host format: `clickhouse.<region>.tinybird.co`

**Authentication failures**

Error: Authentication failed
- Check your Auth Token is valid and not expired
- Ensure the token has read permissions for the workspace
- Verify the token is entered in the password field

**SSL/TLS errors**

Error: SSL connection error
- Ensure SSL/TLS is enabled in your client
- Use port 443 with HTTPS protocol
- Check that your client supports TLS 1.2 or higher.

**Query timeouts**

Error: Query timeout
- Add appropriate WHERE clauses to filter data
- Use LIMIT to reduce result set size
- Consider querying Materialized Views instead of raw data

### Getting help [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#getting-help)

If you encounter issues not covered here:

1. Check the specific tool integration guide
2. Review your[  Auth Token](https://cloud.tinybird.co/tokens)   permissions
3. Test the connection with a simple query
4. Contact Tinybird at support@tinybird.co for additional assistance

## Next steps [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/clickhouse-interface#next-steps)

Connect your BI tool and follow the specific integration guide to set up dashboards and visualizations with your Tinybird data

- [  Chartbrew](/docs/forward/work-with-data/publish-data/guides/connect-chartbrew)
- [  ClickHouse Go Client](/docs/forward/work-with-data/publish-data/guides/connect-clickhouse-go)
- [  ClickHouse JS Client](/docs/forward/work-with-data/publish-data/guides/connect-clickhouse-js)
- [  ClickHouse Python Client](/docs/forward/work-with-data/publish-data/guides/connect-clickhouse-python)
- [  DataGrip](/docs/forward/work-with-data/publish-data/guides/connect-datagrip)
- [  DBeaver](/docs/forward/work-with-data/publish-data/guides/connect-dbeaver)
- [  Deepnote](/docs/forward/work-with-data/publish-data/guides/connect-deepnote)
- [  Draxlr](/docs/forward/work-with-data/publish-data/guides/connect-draxlr)
- [  Fabi.ai](/docs/forward/work-with-data/publish-data/guides/connect-fabi)
- [  Grafana](/docs/forward/work-with-data/publish-data/guides/connect-grafana)
- [  Hex](/docs/forward/work-with-data/publish-data/guides/connect-hex)
- [  Holistics](/docs/forward/work-with-data/publish-data/guides/connect-holistics)
- [  Luzmo](/docs/forward/work-with-data/publish-data/guides/connect-luzmo)
- [  Metabase](/docs/forward/work-with-data/publish-data/guides/connect-metabase)
- [  Mitzu](/docs/forward/work-with-data/publish-data/guides/connect-mitzu)
- [  Power BI](/docs/forward/work-with-data/publish-data/guides/connect-powerbi)
- [  Redash](/docs/forward/work-with-data/publish-data/guides/connect-redash)
- [  Superset](/docs/forward/work-with-data/publish-data/guides/connect-superset)
- [  Tableau](/docs/forward/work-with-data/publish-data/guides/connect-tableau)


