Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
        "CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
        "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  }
}

claude mcp add mcp-clickhouse -e "CLICKHOUSE_HOST=${CLICKHOUSE_HOST}" -e "CLICKHOUSE_USER=${CLICKHOUSE_USER}" -e "CLICKHOUSE_PASSWORD=${CLICKHOUSE_PASSWORD}" -e "CLICKHOUSE_SECURE=true" -e "CLICKHOUSE_VERIFY=true" -e "CLICKHOUSE_ALLOW_WRITE_ACCESS=false" -e "CLICKHOUSE_ALLOW_DROP=false" -e "CLICKHOUSE_MCP_QUERY_TIMEOUT=30" -e "CLICKHOUSE_MCP_MAX_WORKERS=10" -- uvx mcp-clickhouse==0.7.0

[mcp_servers.mcp-clickhouse]
command = "uvx"
args = ["mcp-clickhouse==0.7.0"]
env = { "CLICKHOUSE_HOST" = "${CLICKHOUSE_HOST}", "CLICKHOUSE_USER" = "${CLICKHOUSE_USER}", "CLICKHOUSE_PASSWORD" = "${CLICKHOUSE_PASSWORD}", "CLICKHOUSE_SECURE" = "true", "CLICKHOUSE_VERIFY" = "true", "CLICKHOUSE_ALLOW_WRITE_ACCESS" = "false", "CLICKHOUSE_ALLOW_DROP" = "false", "CLICKHOUSE_MCP_QUERY_TIMEOUT" = "30", "CLICKHOUSE_MCP_MAX_WORKERS" = "10" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-clickhouse": {
      "type": "local",
      "command": [
        "uvx",
        "mcp-clickhouse==0.7.0"
      ],
      "enabled": true,
      "environment": {
        "CLICKHOUSE_HOST": "{env:CLICKHOUSE_HOST}",
        "CLICKHOUSE_USER": "{env:CLICKHOUSE_USER}",
        "CLICKHOUSE_PASSWORD": "{env:CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
        "CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
        "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-clickhouse&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtY3AtY2xpY2tob3VzZT09MC43LjAiXSwiZW52Ijp7IkNMSUNLSE9VU0VfSE9TVCI6IiR7Q0xJQ0tIT1VTRV9IT1NUfSIsIkNMSUNLSE9VU0VfVVNFUiI6IiR7Q0xJQ0tIT1VTRV9VU0VSfSIsIkNMSUNLSE9VU0VfUEFTU1dPUkQiOiIke0NMSUNLSE9VU0VfUEFTU1dPUkR9IiwiQ0xJQ0tIT1VTRV9TRUNVUkUiOiJ0cnVlIiwiQ0xJQ0tIT1VTRV9WRVJJRlkiOiJ0cnVlIiwiQ0xJQ0tIT1VTRV9BTExPV19XUklURV9BQ0NFU1MiOiJmYWxzZSIsIkNMSUNLSE9VU0VfQUxMT1dfRFJPUCI6ImZhbHNlIiwiQ0xJQ0tIT1VTRV9NQ1BfUVVFUllfVElNRU9VVCI6IjMwIiwiQ0xJQ0tIT1VTRV9NQ1BfTUFYX1dPUktFUlMiOiIxMCJ9fQ%3D%3D"
}

{
  "servers": {
    "mcp-clickhouse": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
        "CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
        "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "env": {
        "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}",
        "CLICKHOUSE_USER": "${CLICKHOUSE_USER}",
        "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}",
        "CLICKHOUSE_SECURE": "true",
        "CLICKHOUSE_VERIFY": "true",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
        "CLICKHOUSE_ALLOW_DROP": "false",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30",
        "CLICKHOUSE_MCP_MAX_WORKERS": "10"
      }
    }
  }
}

extensions:
  "mcp-clickhouse":
    enabled: true
    name: "mcp-clickhouse"
    type: stdio
    cmd: "uvx"
    args:
      - "mcp-clickhouse==0.7.0"
    envs:
      "CLICKHOUSE_HOST": "${CLICKHOUSE_HOST}"
      "CLICKHOUSE_USER": "${CLICKHOUSE_USER}"
      "CLICKHOUSE_PASSWORD": "${CLICKHOUSE_PASSWORD}"
      "CLICKHOUSE_SECURE": "true"
      "CLICKHOUSE_VERIFY": "true"
      "CLICKHOUSE_ALLOW_WRITE_ACCESS": "false"
      "CLICKHOUSE_ALLOW_DROP": "false"
      "CLICKHOUSE_MCP_QUERY_TIMEOUT": "30"
      "CLICKHOUSE_MCP_MAX_WORKERS": "10"
    timeout: 300

Placeholders to fill from your own secret store: ${CLICKHOUSE_PASSWORD}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependencies100 · weight 15

pass
deps.known_vulnsno known advisory in 74 resolved packages
pass
deps.mcp_sdk_versionmcp 2.2.0, no known advisory
pass
deps.resolvable[email protected] resolved: 74 packages

Tool list unknown · checked 2026-10-20 03:05 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 94 / 100

provenance90

livenessn/a

freshness100

hygiene95

+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-29d-ago -unpinned-packages(1)

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] PyPI73 dependencies, resolved · MCP SDK mcp 2.2.0 · advisories checked 2026-10-19

No known advisory affects this dependency graph.

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`mcp-clickhouse`	pypi	0.7.0	uvx	`CLICKHOUSE_PASSWORD`
`ghcr.io/clickhouse/mcp-clickhouse:0.7.0`	oci	unpinned	–	`CLICKHOUSE_PASSWORD`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.ClickHouse/mcp-clickhouse",
  "title": "ClickHouse",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.7.0",
  "packages": [
    {
      "version": "0.7.0",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mcp-clickhouse",
      "runtimeHint": "uvx",
      "registryType": "pypi",
      "environmentVariables": [
        {
          "name": "CLICKHOUSE_HOST",
          "isRequired": true,
          "description": "Hostname of the ClickHouse server"
        },
        {
          "name": "CLICKHOUSE_USER",
          "isRequired": true,
          "description": "Username for ClickHouse authentication"
        },
        {
          "name": "CLICKHOUSE_PASSWORD",
          "isSecret": true,
          "description": "Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode"
        },
        {
          "name": "CLICKHOUSE_PORT",
          "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
        },
        {
          "name": "CLICKHOUSE_SECURE",
          "format": "boolean",
          "default": "true",
          "description": "Use HTTPS to connect to ClickHouse"
        },
        {
          "name": "CLICKHOUSE_VERIFY",
          "format": "boolean",
          "default": "true",
          "description": "Verify SSL certificates"
        },
        {
          "name": "CLICKHOUSE_CA_CERT",
          "format": "filepath",
          "description": "Path to a PEM CA bundle for ClickHouse server certificate verification"
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT",
          "format": "filepath",
          "description": "Path to a PEM client certificate for the ClickHouse HTTPS connection"
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT_KEY",
          "format": "filepath",
          "description": "Path to the PEM private key for CLICKHOUSE_CLIENT_CERT"
        },
        {
          "name": "CLICKHOUSE_TLS_MODE",
          "choices": [
            "mutual",
            "proxy",
            "strict"
          ],
          "description": "Client certificate mode: mutual, proxy, or strict"
        },
        {
          "name": "CLICKHOUSE_DATABASE",
          "description": "Default database to use"
        },
        {
          "name": "CLICKHOUSE_ROLE",
          "description": "ClickHouse role to activate for the session"
        },
        {
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
          "format": "boolean",
          "default": "false",
          "description": "Allow write operations (DDL and DML). Queries run read-only by default"
        },
        {
          "name": "CLICKHOUSE_ALLOW_DROP",
          "format": "boolean",
          "default": "false",
          "description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
        },
        {
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
          "format": "number",
          "default": "30",
          "description": "Query tool timeout in seconds"
        },
        {
          "name": "CLICKHOUSE_MCP_MAX_WORKERS",
          "format": "number",
          "default": "10",
          "description": "Maximum query worker thread pool size"
        }
      ]
    },
    {
      "transport": {
        "type": "stdio"
      },
      "identifier": "ghcr.io/clickhouse/mcp-clickhouse:0.7.0",
      "registryType": "oci",
      "environmentVariables": [
        {
          "name": "CLICKHOUSE_HOST",
          "isRequired": true,
          "description": "Hostname of the ClickHouse server"
        },
        {
          "name": "CLICKHOUSE_USER",
          "isRequired": true,
          "description": "Username for ClickHouse authentication"
        },
        {
          "name": "CLICKHOUSE_PASSWORD",
          "isSecret": true,
          "description": "Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode"
        },
        {
          "name": "CLICKHOUSE_PORT",
          "description": "ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise"
        },
        {
          "name": "CLICKHOUSE_SECURE",
          "format": "boolean",
          "default": "true",
          "description": "Use HTTPS to connect to ClickHouse"
        },
        {
          "name": "CLICKHOUSE_VERIFY",
          "format": "boolean",
          "default": "true",
          "description": "Verify SSL certificates"
        },
        {
          "name": "CLICKHOUSE_CA_CERT",
          "format": "filepath",
          "description": "Path to a PEM CA bundle for ClickHouse server certificate verification"
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT",
          "format": "filepath",
          "description": "Path to a PEM client certificate for the ClickHouse HTTPS connection"
        },
        {
          "name": "CLICKHOUSE_CLIENT_CERT_KEY",
          "format": "filepath",
          "description": "Path to the PEM private key for CLICKHOUSE_CLIENT_CERT"
        },
        {
          "name": "CLICKHOUSE_TLS_MODE",
          "choices": [
            "mutual",
            "proxy",
            "strict"
          ],
          "description": "Client certificate mode: mutual, proxy, or strict"
        },
        {
          "name": "CLICKHOUSE_DATABASE",
          "description": "Default database to use"
        },
        {
          "name": "CLICKHOUSE_ROLE",
          "description": "ClickHouse role to activate for the session"
        },
        {
          "name": "CLICKHOUSE_ALLOW_WRITE_ACCESS",
          "format": "boolean",
          "default": "false",
          "description": "Allow write operations (DDL and DML). Queries run read-only by default"
        },
        {
          "name": "CLICKHOUSE_ALLOW_DROP",
          "format": "boolean",
          "default": "false",
          "description": "Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled"
        },
        {
          "name": "CLICKHOUSE_MCP_QUERY_TIMEOUT",
          "format": "number",
          "default": "30",
          "description": "Query tool timeout in seconds"
        },
        {
          "name": "CLICKHOUSE_MCP_MAX_WORKERS",
          "format": "number",
          "default": "10",
          "description": "Maximum query worker thread pool size"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/ClickHouse/mcp-clickhouse",
    "source": "github"
  },
  "websiteUrl": "https://clickhouse.com",
  "description": "Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB."
}