cosmic-mcp

All servers

ClickHouse

io.github.ClickHouse/mcp-clickhouse ยท version 0.7.0

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.

https://github.com/ClickHouse/mcp-clickhouse

Quick facts

  • Listing: Community
  • Published Sep 21, 14:02 UTC
  • Transport: stdio
  • Package: pypi mcp-clickhouse 0.7.0
  • Listed by cosmic-mcp: Nov 9, 04:25 UTC

Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (pypi)

uvx 'mcp-clickhouse==0.7.0'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_ALLOW_DROP": "<your clickhouse allow drop>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your clickhouse allow write access>",
        "CLICKHOUSE_CA_CERT": "<your clickhouse ca cert>",
        "CLICKHOUSE_CLIENT_CERT": "<your clickhouse client cert>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your clickhouse client cert key>",
        "CLICKHOUSE_DATABASE": "<your clickhouse database>",
        "CLICKHOUSE_HOST": "<your clickhouse host>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your clickhouse mcp max workers>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your clickhouse mcp query timeout>",
        "CLICKHOUSE_PASSWORD": "<your clickhouse password>",
        "CLICKHOUSE_PORT": "<your clickhouse port>",
        "CLICKHOUSE_ROLE": "<your clickhouse role>",
        "CLICKHOUSE_SECURE": "<your clickhouse secure>",
        "CLICKHOUSE_TLS_MODE": "<your clickhouse tls mode>",
        "CLICKHOUSE_USER": "<your clickhouse user>",
        "CLICKHOUSE_VERIFY": "<your clickhouse verify>"
      }
    }
  }
}

Claude Code

claude mcp add 'mcp-clickhouse' -- uvx 'mcp-clickhouse==0.7.0'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_ALLOW_DROP": "<your clickhouse allow drop>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your clickhouse allow write access>",
        "CLICKHOUSE_CA_CERT": "<your clickhouse ca cert>",
        "CLICKHOUSE_CLIENT_CERT": "<your clickhouse client cert>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your clickhouse client cert key>",
        "CLICKHOUSE_DATABASE": "<your clickhouse database>",
        "CLICKHOUSE_HOST": "<your clickhouse host>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your clickhouse mcp max workers>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your clickhouse mcp query timeout>",
        "CLICKHOUSE_PASSWORD": "<your clickhouse password>",
        "CLICKHOUSE_PORT": "<your clickhouse port>",
        "CLICKHOUSE_ROLE": "<your clickhouse role>",
        "CLICKHOUSE_SECURE": "<your clickhouse secure>",
        "CLICKHOUSE_TLS_MODE": "<your clickhouse tls mode>",
        "CLICKHOUSE_USER": "<your clickhouse user>",
        "CLICKHOUSE_VERIFY": "<your clickhouse verify>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "mcp-clickhouse": {
      "args": [
        "mcp-clickhouse==0.7.0"
      ],
      "command": "uvx",
      "env": {
        "CLICKHOUSE_ALLOW_DROP": "<your clickhouse allow drop>",
        "CLICKHOUSE_ALLOW_WRITE_ACCESS": "<your clickhouse allow write access>",
        "CLICKHOUSE_CA_CERT": "<your clickhouse ca cert>",
        "CLICKHOUSE_CLIENT_CERT": "<your clickhouse client cert>",
        "CLICKHOUSE_CLIENT_CERT_KEY": "<your clickhouse client cert key>",
        "CLICKHOUSE_DATABASE": "<your clickhouse database>",
        "CLICKHOUSE_HOST": "<your clickhouse host>",
        "CLICKHOUSE_MCP_MAX_WORKERS": "<your clickhouse mcp max workers>",
        "CLICKHOUSE_MCP_QUERY_TIMEOUT": "<your clickhouse mcp query timeout>",
        "CLICKHOUSE_PASSWORD": "<your clickhouse password>",
        "CLICKHOUSE_PORT": "<your clickhouse port>",
        "CLICKHOUSE_ROLE": "<your clickhouse role>",
        "CLICKHOUSE_SECURE": "<your clickhouse secure>",
        "CLICKHOUSE_TLS_MODE": "<your clickhouse tls mode>",
        "CLICKHOUSE_USER": "<your clickhouse user>",
        "CLICKHOUSE_VERIFY": "<your clickhouse verify>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • spotdb Verified domain
    Ephemeral data sandbox for AI workflows with guardrails and security
  • Reasonbook Verified domain
    Reasonbook: decisions that survive the session, in a local record AI agents keep.
  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • AI2SQL Verified domain
    Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
  • AICasePredict Verified domain
    Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts.
  • APC Security Reference Server
    Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...