ClickHouse FAQs

Name: ClickHouse
Author: ClickHouse

Question 1

What is the ClickHouse MCP Server?

Accepted Answer

It's a server that allows you to interact with your ClickHouse databases through a simple interface. It provides tools to execute SQL queries with readonly access, list databases, and list tables.

Question 2

What are the key features of the ClickHouse MCP Server?

Accepted Answer

The server enables you to run SQL queries on ClickHouse with readonly protection, browse available databases, and explore the tables within each database.

Question 3

How do I configure the ClickHouse MCP Server?

Accepted Answer

Configuration involves modifying the Claude Desktop configuration file and adding the `mcp-clickhouse` server definition. You'll need to specify your ClickHouse host, port, user, and password. See the documentation for example configurations.

Question 4

Is the SQL execution safe?

Accepted Answer

Yes, all SQL queries are run with `readonly = 1` to ensure they are safe and prevent any modifications to your database.

Question 5

What environment variables are required to run the ClickHouse MCP Server?

Accepted Answer

You'll need to set `CLICKHOUSE_HOST`, `CLICKHOUSE_USER`, and `CLICKHOUSE_PASSWORD`. Optional variables include `CLICKHOUSE_PORT`, `CLICKHOUSE_SECURE`, `CLICKHOUSE_VERIFY`, `CLICKHOUSE_CONNECT_TIMEOUT`, `CLICKHOUSE_SEND_RECEIVE_TIMEOUT`, and `CLICKHOUSE_DATABASE`.

ClickHouse

About

Key Features

Use Cases