Skip to main content
Glama
wtkid

mcp-clickhouse-multids

by wtkid
OverviewSchemaRelated ServersScoreDiscussions
Python
Hybrid

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
CLICKHOUSE_HOSTNoClickHouse host for legacy single datasource
CLICKHOUSE_PORTNoClickHouse HTTP port. Default: 8123 (secure=false) or 8443 (secure=true)
CLICKHOUSE_ROLENoClickHouse role
CLICKHOUSE_USERNoClickHouse user for legacy single datasource
CLICKHOUSE_SECURENoUse HTTPS for ClickHouse connection. Default: false
CLICKHOUSE_VERIFYNoVerify TLS certificate. Default: false
CLICKHOUSE_DATABASENoDefault database
CLICKHOUSE_PASSWORDNoClickHouse password for legacy single datasource
CLICKHOUSE_ALLOW_DROPNoAllow DROP/TRUNCATE (requires ALLOW_WRITE_ACCESS=true). Default: false
CLICKHOUSE_PROXY_PATHNoHTTP proxy path prefix
MCP_MIDDLEWARE_MODULENoPython module path for custom middleware
CLICKHOUSE_MCP_BIND_HOSTNoBind host for HTTP/SSE. Default: 127.0.0.1
CLICKHOUSE_MCP_BIND_PORTNoBind port for HTTP/SSE. Default: 8000
CLICKHOUSE_MCP_AUTH_TOKENNoStatic Bearer token for HTTP/SSE authentication
CLICKHOUSE_CONNECT_TIMEOUTNoConnection timeout in seconds. Default: 30
CLICKHOUSE_SERVER_HOST_NAMENoSNI / certificate hostname
CLICKHOUSE_MCP_AUTH_DISABLEDNoSet to 'true' to disable HTTP/SSE authentication (development only)
CLICKHOUSE_MCP_QUERY_TIMEOUTNoQuery timeout in seconds. Default: 30
CLICKHOUSE_ALLOW_WRITE_ACCESSNoAllow write operations. Default: false
CLICKHOUSE_MCP_SERVER_TRANSPORTNoTransport mode: stdio, http, or sse. Default: stdio
CLICKHOUSE_SEND_RECEIVE_TIMEOUTNoSend/receive timeout in seconds. Default: 300
MCP_CLICKHOUSE_DATASOURCES_FILENoPath 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

CapabilityDetails
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

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

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