ClickHouse FAQs

Question 1

What can I do with the ClickHouse MCP Server?

Accepted Answer

You can execute SQL queries with read-only restrictions for safety, list databases on your ClickHouse cluster, and list tables within a specific database.

Question 2

What environment variables are required to configure the ClickHouse connection?

Accepted Answer

You need to set `CLICKHOUSE_HOST`, `CLICKHOUSE_USER`, and `CLICKHOUSE_PASSWORD`. `CLICKHOUSE_PORT`, `CLICKHOUSE_SECURE`, `CLICKHOUSE_VERIFY`, `CLICKHOUSE_CONNECT_TIMEOUT`, `CLICKHOUSE_SEND_RECEIVE_TIMEOUT`, and `CLICKHOUSE_DATABASE` are optional.

Question 3

Is it safe to use the ClickHouse MCP Server for querying?

Accepted Answer

Yes, all queries are run with `readonly = 1`, ensuring they are safe and cannot modify your database.

Question 4

What is the ClickHouse MCP Server?

Accepted Answer

It's an MCP server that allows you to interact with ClickHouse databases. It provides tools for querying, listing databases, and listing tables.

Question 5

How do I configure the ClickHouse MCP Server?

Accepted Answer

You configure it by modifying the Claude Desktop configuration file and adding the `mcp-clickhouse` configuration block, including your ClickHouse connection details (host, port, user, password).

ClickHouse

Key Features

Use Cases

ClickHouse

Key Features

Use Cases