mcp-clickhouse-multids
by wtkid
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 |
Capabilities
Features and capabilities supported by this server
| 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 | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/wtkid/mcp-clickhouse-multids'
If you have feedback or need assistance with the MCP directory API, please join our Discord server