Add to Docker Desktop
Version 4.43 or later needs to be installed to add the server automatically
About
Official ClickHouse MCP Server
Official ClickHouse MCP Server.
MCP Info
| Attribute | Details |
|---|---|
| Docker Image | mcp/clickhouse |
| Author | ClickHouse |
| Repository | https://github.com/ClickHouse/mcp-clickhouse |
Image Building Info
| Attribute | Details |
|---|---|
| Dockerfile | https://github.com/ClickHouse/mcp-clickhouse/blob/21e6cb2b0758150e8fd0627b699fbfd78e31837b/Dockerfile |
| Commit | 21e6cb2b0758150e8fd0627b699fbfd78e31837b |
| 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>"
}
}
}
}