addrbookFor publishers
← The evidence ledger

Evidence row 26956

Observed , by baseline/1.

Kind
listing
About
source_record mcp_registry:io.github.ClickHouse/mcp-clickhouse
Recorded
Previous row
None: the first of its kind about this subject
Body SHA-256
c4c6a75318db04ab8b7cda29831df40fe5aadad46b45fb0320544707dfe3e398
Leaf
0x2bc2c9fc689781339f4ece81909ca41887a0211cacc8d21c81bc245a727e1fbd

What was observed

{
  "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."
}

What the leaf hashes

{"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"}

Proof

Fold these into the leaf in order, hashing each sorted pair with keccak256, to reach the root of (296695 rows).

  1. 0x2bc309f001e2038e61b62ff911c0d0e4acb8f6378fbed9e4269487f9b41dce9f
  2. 0x10b1871f1413eb26255d7a4cad3fcffb1d068cbd5d225cba84dd68f020ad9da9
  3. 0xf5487a09d7366d57a8f049fe16ce61bcd00f068ed84e642eb5aca6d2df9f9c6c
  4. 0x5466d561c5ad49e9742d3187a8d8b89e1656d2c8f58488e9364929eca66ed760
  5. 0xe90b77fa20ed3e0d9b8116e42f8b73c4ee839acf2f9b4277c2b3580e1d1e2cbe
  6. 0x39975e9558dd64238563e2fc8c8e835333a69cacd8b899d8fa70122eeb8868b4
  7. 0x0c4c2b6693753e5a7e5d1dc9d634556ee080c7b711bde985d0e7ef5154162109
  8. 0x2d2ef57652a8c1949588d05180154bcbf5f4bd34af826443b6a2b7146b7bece0
  9. 0x4b56b343294e474466fb86e0e07b807748a7fd58f1bcc4c4d158844fcd53480b
  10. 0x1849abdab9b306191ae2d658697793afbb80090da1dc820f6ee0aacd338f8578
  11. 0x9c1d7a3e2abd583b1dff8bd25a4baee5982930fe95a180a1a8b26c3f7e8c93f2
  12. 0xe8bf822fd6c66b233e3e13e08596e8fb41c1ed9b85be0e4d50cfc9b740c0e206
  13. 0xb87e8b32cda179c9e632e227bbd8a6d1f6f61d9d81bb92dbd4dd835d2b3b5caa
  14. 0x683955a5b2250ad50568d022a6580d8739b6aff1356779d72a773b088e7c289c
  15. 0x610738e0c43687aded83c613c73de8b5226c73c375858a167436461c522ea213
  16. 0x06d71bfa7d8b41d62c8836efc2c601e1cc3772d9453596b2ae4950887f3310ca
  17. 0x8c756542e482157df0c36464d75c937b845e4423dbbcfad08f0cf8d5a16b9a13
  18. 0x20704208aa6923d6b2450ef74ede87a6e0265d46447926038fe9506e9e154b2d
  19. 0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a
Day root
0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8
Chained
0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a
Published
On Arc Testnet, block 69251483: 0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae

How to check it · This row as JSON