Official ClickHouse MCP Server
Official ClickHouse MCP Server.
9.5K
2
3 Tools
Signed
Built by Docker
Requires Secrets
Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
About
Official ClickHouse MCP Server MCP Server
Official ClickHouse MCP Server.
Characteristics
| Attribute | Details |
|---|---|
| Docker Image | mcp/clickhouse |
| Author | ClickHouse |
| Repository | https://github.com/ClickHouse/mcp-clickhouse |
| Dockerfile | https://github.com/ClickHouse/mcp-clickhouse/blob/main/Dockerfile |
| Docker Image built by | Docker Inc. |
| Docker Scout Health Score | |
| Verify Signature | COSIGN_REPOSITORY=mcp/signatures cosign verify mcp/clickhouse --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub |
| Licence | Apache License 2.0 |
Available Tools (3)
| Tools provided by this Server | Short Description |
|---|---|
list_databases | List available ClickHouse databases |
list_tables | List available ClickHouse tables in a database, including schema, comment, row count, and column count. |
run_select_query | Run a SELECT query in a ClickHouse database |
Tools Details
Tool: list_databases
List available ClickHouse databases
Tool: list_tables
List available ClickHouse tables in a database, including schema, comment, row count, and column count.
| Parameters | Type | Description |
|---|---|---|
database | string | |
like | stringoptional | |
not_like | stringoptional |
Tool: run_select_query
Run a SELECT query in a ClickHouse database
| Parameters | Type | Description |
|---|---|---|
query | string |
Use this MCP Server
{
"mcpServers": {
"clickhouse": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"CLICKHOUSE_HOST",
"-e",
"CLICKHOUSE_PORT",
"-e",
"CLICKHOUSE_USER",
"-e",
"CLICKHOUSE_SECURE",
"-e",
"CLICKHOUSE_VERIFY",
"-e",
"CLICKHOUSE_CONNECT_TIMEOUT",
"-e",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT",
"-e",
"CLICKHOUSE_PASSWORD",
"mcp/clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "sql-clickhouse.clickhouse.com",
"CLICKHOUSE_PORT": "8443",
"CLICKHOUSE_USER": "demo",
"CLICKHOUSE_SECURE": "true",
"CLICKHOUSE_VERIFY": "true",
"CLICKHOUSE_CONNECT_TIMEOUT": "30",
"CLICKHOUSE_SEND_RECEIVE_TIMEOUT": "30",
"CLICKHOUSE_PASSWORD": "<YOUR_CLICKHOUSE_PASSWORD_HERE>"
}
}
}
}
Manual installation
You can install the MCP server using:
Installation for