mcp-clickhouse-multids
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| CLICKHOUSE_HOST | No | ClickHouse host for legacy single datasource | |
| CLICKHOUSE_PORT | No | ClickHouse HTTP port. Default: 8123 (secure=false) or 8443 (secure=true) | |
| CLICKHOUSE_ROLE | No | ClickHouse role | |
| CLICKHOUSE_USER | No | ClickHouse user for legacy single datasource | |
| CLICKHOUSE_SECURE | No | Use HTTPS for ClickHouse connection. Default: false | |
| CLICKHOUSE_VERIFY | No | Verify TLS certificate. Default: false | |
| CLICKHOUSE_DATABASE | No | Default database | |
| CLICKHOUSE_PASSWORD | No | ClickHouse password for legacy single datasource | |
| CLICKHOUSE_ALLOW_DROP | No | Allow DROP/TRUNCATE (requires ALLOW_WRITE_ACCESS=true). Default: false | |
| CLICKHOUSE_PROXY_PATH | No | HTTP proxy path prefix | |
| MCP_MIDDLEWARE_MODULE | No | Python module path for custom middleware | |
| CLICKHOUSE_MCP_BIND_HOST | No | Bind host for HTTP/SSE. Default: 127.0.0.1 | |
| CLICKHOUSE_MCP_BIND_PORT | No | Bind port for HTTP/SSE. Default: 8000 | |
| CLICKHOUSE_MCP_AUTH_TOKEN | No | Static Bearer token for HTTP/SSE authentication | |
| CLICKHOUSE_CONNECT_TIMEOUT | No | Connection timeout in seconds. Default: 30 | |
| CLICKHOUSE_SERVER_HOST_NAME | No | SNI / certificate hostname | |
| CLICKHOUSE_MCP_AUTH_DISABLED | No | Set to 'true' to disable HTTP/SSE authentication (development only) | |
| CLICKHOUSE_MCP_QUERY_TIMEOUT | No | Query timeout in seconds. Default: 30 | |
| CLICKHOUSE_ALLOW_WRITE_ACCESS | No | Allow write operations. Default: false | |
| CLICKHOUSE_MCP_SERVER_TRANSPORT | No | Transport mode: stdio, http, or sse. Default: stdio | |
| CLICKHOUSE_SEND_RECEIVE_TIMEOUT | No | Send/receive timeout in seconds. Default: 300 | |
| MCP_CLICKHOUSE_DATASOURCES_FILE | No | Path to YAML file with predefined datasources |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tasks | {
"list": {},
"cancel": {},
"requests": {
"tools": {
"call": {}
},
"prompts": {
"get": {}
},
"resources": {
"read": {}
}
}
} |
| tools | {
"listChanged": true
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| register_datasourceD | – |
| list_registered_datasourcesD | – |
| unregister_datasourceD | – |
| list_databasesD | – |
| list_tablesD | – |
| run_queryA | Execute SQL on a ClickHouse datasource (host:port). Read-only by default; set CLICKHOUSE_ALLOW_WRITE_ACCESS=true for writes. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 6 tools
Tool names like 'list_registered_datasources' and 'list_databases' suggest distinct purposes, but missing descriptions for most tools could cause ambiguity for an agent, especially between datasource and database/tables listing. However, the naming is sufficiently clear to differentiate them.
All tool names follow a consistent verb_noun pattern in snake_case (e.g., list_registered_datasources, register_datasource, run_query). No mixing of styles or conventions.
With 6 tools covering datasource management, database/table listing, and query execution, the count is well within the ideal range (3-15) for a focused multi-datasource ClickHouse server.
The tool set covers basic CRUD for datasources (list, register, unregister) and read operations (list databases/tables, run query). Missing update datasource and write operations (though run_query can be configured for writes). Notable gaps for a full lifecycle.