{"id":26956,"recorded_at":"2026-10-26T14:35:56.749065Z","observed_at":"2026-10-26T14:35:56.749010Z","subject_kind":"source_record","subject":"mcp_registry:io.github.ClickHouse/mcp-clickhouse","kind":"listing","method":"baseline/1","body":{"endpoints":[["web","https://clickhouse.com/"]],"name":"ClickHouse","owner_address":null,"raw":{"_meta":{"io.modelcontextprotocol.registry/official":{"isLatest":true,"publishedAt":"2026-09-21T14:02:19.431473Z","status":"active","statusChangedAt":"2026-09-21T14:02:19.431473Z","updatedAt":"2026-09-21T14:02:19.431473Z"}},"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","description":"Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.","name":"io.github.ClickHouse/mcp-clickhouse","packages":[{"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. Required unless a client certificate uses the default or mutual TLS mode","isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"default":"true","description":"Use HTTPS to connect to ClickHouse","format":"boolean","name":"CLICKHOUSE_SECURE"},{"default":"true","description":"Verify SSL certificates","format":"boolean","name":"CLICKHOUSE_VERIFY"},{"description":"Path to a PEM CA bundle for ClickHouse server certificate verification","format":"filepath","name":"CLICKHOUSE_CA_CERT"},{"description":"Path to a PEM client certificate for the ClickHouse HTTPS connection","format":"filepath","name":"CLICKHOUSE_CLIENT_CERT"},{"description":"Path to the PEM private key for CLICKHOUSE_CLIENT_CERT","format":"filepath","name":"CLICKHOUSE_CLIENT_CERT_KEY"},{"choices":["mutual","proxy","strict"],"description":"Client certificate mode: mutual, proxy, or strict","name":"CLICKHOUSE_TLS_MODE"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"default":"false","description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"default":"false","description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","name":"CLICKHOUSE_ALLOW_DROP"},{"default":"30","description":"Query tool timeout in seconds","format":"number","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"default":"10","description":"Maximum query worker thread pool size","format":"number","name":"CLICKHOUSE_MCP_MAX_WORKERS"}],"identifier":"mcp-clickhouse","registryType":"pypi","runtimeHint":"uvx","transport":{"type":"stdio"},"version":"0.7.0"},{"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. Required unless a client certificate uses the default or mutual TLS mode","isSecret":true,"name":"CLICKHOUSE_PASSWORD"},{"description":"ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise","name":"CLICKHOUSE_PORT"},{"default":"true","description":"Use HTTPS to connect to ClickHouse","format":"boolean","name":"CLICKHOUSE_SECURE"},{"default":"true","description":"Verify SSL certificates","format":"boolean","name":"CLICKHOUSE_VERIFY"},{"description":"Path to a PEM CA bundle for ClickHouse server certificate verification","format":"filepath","name":"CLICKHOUSE_CA_CERT"},{"description":"Path to a PEM client certificate for the ClickHouse HTTPS connection","format":"filepath","name":"CLICKHOUSE_CLIENT_CERT"},{"description":"Path to the PEM private key for CLICKHOUSE_CLIENT_CERT","format":"filepath","name":"CLICKHOUSE_CLIENT_CERT_KEY"},{"choices":["mutual","proxy","strict"],"description":"Client certificate mode: mutual, proxy, or strict","name":"CLICKHOUSE_TLS_MODE"},{"description":"Default database to use","name":"CLICKHOUSE_DATABASE"},{"description":"ClickHouse role to activate for the session","name":"CLICKHOUSE_ROLE"},{"default":"false","description":"Allow write operations (DDL and DML). Queries run read-only by default","format":"boolean","name":"CLICKHOUSE_ALLOW_WRITE_ACCESS"},{"default":"false","description":"Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled","format":"boolean","name":"CLICKHOUSE_ALLOW_DROP"},{"default":"30","description":"Query tool timeout in seconds","format":"number","name":"CLICKHOUSE_MCP_QUERY_TIMEOUT"},{"default":"10","description":"Maximum query worker thread pool size","format":"number","name":"CLICKHOUSE_MCP_MAX_WORKERS"}],"identifier":"ghcr.io/clickhouse/mcp-clickhouse:0.7.0","registryType":"oci","transport":{"type":"stdio"}}],"repository":{"source":"github","url":"https://github.com/ClickHouse/mcp-clickhouse"},"title":"ClickHouse","version":"0.7.0","websiteUrl":"https://clickhouse.com"}},"source":"mcp_registry","summary":"Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB."},"body_sha256":"c4c6a75318db04ab8b7cda29831df40fe5aadad46b45fb0320544707dfe3e398","prev_id":null,"leaf":"0x2bc2c9fc689781339f4ece81909ca41887a0211cacc8d21c81bc245a727e1fbd","leaf_text":"{\"body\":\"c4c6a75318db04ab8b7cda29831df40fe5aadad46b45fb0320544707dfe3e398\",\"id\":26956,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025356749010,\"prev\":null,\"subject\":\"mcp_registry:io.github.ClickHouse/mcp-clickhouse\",\"subject_kind\":\"source_record\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0x2bc309f001e2038e61b62ff911c0d0e4acb8f6378fbed9e4269487f9b41dce9f","0x10b1871f1413eb26255d7a4cad3fcffb1d068cbd5d225cba84dd68f020ad9da9","0xf5487a09d7366d57a8f049fe16ce61bcd00f068ed84e642eb5aca6d2df9f9c6c","0x5466d561c5ad49e9742d3187a8d8b89e1656d2c8f58488e9364929eca66ed760","0xe90b77fa20ed3e0d9b8116e42f8b73c4ee839acf2f9b4277c2b3580e1d1e2cbe","0x39975e9558dd64238563e2fc8c8e835333a69cacd8b899d8fa70122eeb8868b4","0x0c4c2b6693753e5a7e5d1dc9d634556ee080c7b711bde985d0e7ef5154162109","0x2d2ef57652a8c1949588d05180154bcbf5f4bd34af826443b6a2b7146b7bece0","0x4b56b343294e474466fb86e0e07b807748a7fd58f1bcc4c4d158844fcd53480b","0x1849abdab9b306191ae2d658697793afbb80090da1dc820f6ee0aacd338f8578","0x9c1d7a3e2abd583b1dff8bd25a4baee5982930fe95a180a1a8b26c3f7e8c93f2","0xe8bf822fd6c66b233e3e13e08596e8fb41c1ed9b85be0e4d50cfc9b740c0e206","0xb87e8b32cda179c9e632e227bbd8a6d1f6f61d9d81bb92dbd4dd835d2b3b5caa","0x683955a5b2250ad50568d022a6580d8739b6aff1356779d72a773b088e7c289c","0x610738e0c43687aded83c613c73de8b5226c73c375858a167436461c522ea213","0x06d71bfa7d8b41d62c8836efc2c601e1cc3772d9453596b2ae4950887f3310ca","0x8c756542e482157df0c36464d75c937b845e4423dbbcfad08f0cf8d5a16b9a13","0x20704208aa6923d6b2450ef74ede87a6e0265d46447926038fe9506e9e154b2d","0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a"]}