title_wip

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

Community Maintained

Querio is an AI-powered analytics and business intelligence workspace that lets teams query, explore, visualize, and generate insights from data using SQL, Python, and natural language. When you connect Querio to your ClickHouse database or warehouse, you can run live analytics at scale and build boards, notebooks, and AI-assisted reports on your ClickHouse data without moving it.

## Setup ClickHouse for Querio[​](#setup-clickhouse-for-querio "Direct link to Setup ClickHouse for Querio")

Create a Dedicated User

### Create a Dedicated User[​](#create-dedicated-user "Direct link to Create a Dedicated User")

For security best practices, create a dedicated user account exclusively for Querio with minimal required privileges:

```
CREATE USER querio_user IDENTIFIED BY 'STRONG_PASSWORD';
```

Tip

Use a long, random password (at least 16 characters), ideally generated by a password manager.

Grant Read-Only Database Access

### Grant Read-Only Database Access[​](#grant-read-only-access "Direct link to Grant Read-Only Database Access")

Limit Querio permissions to only the databases and tables it needs to query:

```
GRANT SELECT ON my_database.* TO querio_user;
```

For specific tables, use:

```
GRANT SELECT ON database.table_name TO querio_user;
```

Repeat this process for each database Querio requires access to.

Gather Connection Details

### Gather Connection Details[​](#gather-connection-details "Direct link to Gather Connection Details")

To connect Querio to ClickHouse you'll need the following connection info:

|  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Parameter Description|  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `HOST` The address of your ClickHouse server or cluster|  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | `PORT` Port 9440 (default for secure native protocol) or your configured port|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | `DATABASE` The database you want Querio to query|  |  |  |  | | --- | --- | --- | --- | | `USERNAME` `querio_user` (or your chosen username)| `PASSWORD` The password for the user account | | | | | | | | | | | |

Note

- For ClickHouse Cloud, connection details can be found in your cloud console
- For self-managed instances, if your ClickHouse uses a different port, check your server configuration
- Port 9440 is the default for secure native protocol connections

## Create your Querio account and connect ClickHouse[​](#create-account-and-connect "Direct link to Create your Querio account and connect ClickHouse")

Log in or create your Querio workspace at <https://app.querio.ai/>

1. In Querio, go to **Settings → Datasources** and click **Add Datasource**.
2. Select **ClickHouse** from the list of database options.
3. Enter your connection details from above and save the configuration.
4. Querio will validate your connection. Once successful, ClickHouse will be available as a data source across your workspace.

## Querying ClickHouse[​](#querying-clickhouse "Direct link to Querying ClickHouse")

After connecting Querio to ClickHouse, you can explore and analyze your data from anywhere in the platform. Create a SQL block or a Python cell in a Querio notebook, select ClickHouse as your data source, and run queries directly against your ClickHouse cluster. Use Querio visualization and AI tooling to surface insights, build boards, and share results.

## Additional Resources[​](#additional-resources "Direct link to Additional Resources")

- [Querio documentation](https://docs.querio.ai/integrations/clickhouse)
- [Querio getting started guides and tutorials](https://www.querio.ai)

- [Setup ClickHouse for Querio](#setup-clickhouse-for-querio)
  - [Create a Dedicated User](#create-dedicated-user)- [Grant Read-Only Database Access](#grant-read-only-access)- [Gather Connection Details](#gather-connection-details)- [Create your Querio account and connect ClickHouse](#create-account-and-connect)- [Querying ClickHouse](#querying-clickhouse)- [Additional Resources](#additional-resources)

Was this page helpful?