{"servers":[{"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.4.1","websiteUrl":"https://clickhouse.com","packages":[{"registryType":"pypi","identifier":"mcp-clickhouse","version":"0.4.1","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) 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"}]},{"registryType":"oci","identifier":"ghcr.io/clickhouse/mcp-clickhouse:0.4.1","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) 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"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-07-17T17:22:03.100012Z","publishedAt":"2026-07-17T17:22:03.100012Z","updatedAt":"2026-07-17T17:22:03.100012Z","isLatest":true}}}],"metadata":{"count":1}}