ClickHouse

§1What it does

The official ClickHouse MCP server exposes tools for listing databases and tables and running queries against ClickHouse, plus optional chDB embedded queries.

§2Setup

{
  "mcpServers": {
    "mcp-clickhouse": {
      "command": "uvx",
      "args": ["mcp-clickhouse"],
      "env": { "CLICKHOUSE_HOST": "<host>", "CLICKHOUSE_USER": "<user>", "CLICKHOUSE_PASSWORD": "<password>" }
    }
  }
}

Snippets adapted from the official documentation. Check the official page for current options and auth requirements.

§3Prompts to try

1. “Which pages had the most views yesterday?”Copy
2. “List the tables in the events database.”Copy