clickhouse-mcp-serverServer

burakdirin
GitHub
databaseAI integrationClickHouse

Loading subscription status...

💡 Description

An MCP server that allows AI to interact with ClickHouse databases, providing secure connections, query execution, and support for read-only mode.

📝 JSON Entries

{
  "mcpServers": [
    {
      "clickhouse-mcp-server": {
        "env": {
          "CLICKHOUSE_HOST": "localhost",
          "CLICKHOUSE_USER": "root",
          "CLICKHOUSE_DATABASE": "[optional]",
          "CLICKHOUSE_PASSWORD": "password",
          "CLICKHOUSE_READONLY": "true"
        },
        "args": [
          "--directory",
          "/Users/burakdirin/Projects/clickhouse-mcp-server",
          "run",
          "clickhouse-mcp-server"
        ],
        "command": "uv"
      }
    }
  ]
}

🛠️ Tools

connect_databaseexecute_query

Features

  • Connects to ClickHouse databases
  • Executes SQL queries
  • Supports multiple queries
  • Returns results in JSON format