{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.ClickHouse/mcp-clickhouse","description":"Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.","title":"ClickHouse","repository":{"url":"https://github.com/ClickHouse/mcp-clickhouse","source":"github"},"version":"0.6.0","websiteUrl":"https://clickhouse.com","packages":[{"registryType":"pypi","identifier":"mcp-clickhouse","version":"0.6.0","runtimeHint":"uvx","transport":{"type":"stdio"},"environmentVariables":[{"description":"Hostname of the ClickHouse server","isRequired":true,"name":"CLICKHOUSE_HOST"},{"description":"Username for ClickHouse authentication","isRequired":true,"name":"CLICKHOUSE_USER"},{"description":"Password for ClickHouse authentication","isRequired":true,"isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"description":"Use HTTPS to connect to ClickHouse","format":"boolean","default":"true","name":"CLICKHOUSE_SECURE"},{"description":"Verify SSL certificates","format":"boolean","default":"true","name":"CLICKHOUSE_VERIFY"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_DROP"},{"description":"Query tool timeout in seconds","format":"number","default":"30","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"description":"Maximum query worker thread pool size","format":"number","default":"10","name":"CLICKHOUSE_MCP_MAX_WORKERS"}]},{"registryType":"oci","identifier":"ghcr.io/clickhouse/mcp-clickhouse:0.6.0","transport":{"type":"stdio"},"environmentVariables":[{"description":"Hostname of the ClickHouse server","isRequired":true,"name":"CLICKHOUSE_HOST"},{"description":"Username for ClickHouse authentication","isRequired":true,"name":"CLICKHOUSE_USER"},{"description":"Password for ClickHouse authentication","isRequired":true,"isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"description":"Use HTTPS to connect to ClickHouse","format":"boolean","default":"true","name":"CLICKHOUSE_SECURE"},{"description":"Verify SSL certificates","format":"boolean","default":"true","name":"CLICKHOUSE_VERIFY"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","default":"false","name":"CLICKHOUSE_ALLOW_DROP"},{"description":"Query tool timeout in seconds","format":"number","default":"30","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"description":"Maximum query worker thread pool size","format":"number","default":"10","name":"CLICKHOUSE_MCP_MAX_WORKERS"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-09-03T14:14:06.822531Z","publishedAt":"2026-09-03T14:14:06.822531Z","updatedAt":"2026-09-03T14:14:06.822531Z","isLatest":true}}}