ClickHouse MCP Server

Name: ClickHouse MCP Server
Author: io.github.alyiox

io.github.alyiox/mcp-clickhousex

Repository Registry

What is the ClickHouse MCP server?

Read-only MCP server for ClickHouse metadata, parameterized queries, and plan analysis.

How to install ClickHouse

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

MCP_CLICKHOUSE_DSN
secret
Optional shortcut DSN for the default profile, for example http://user:password@host:8123/database. For multiple profiles, use ~/.config/mcp-clickhousex/config.json or MCP_CLICKHOUSE_PROFILES_<NAME>_DSN.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mcp-clickhousex": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}

Claude Code

claude mcp add mcp-clickhousex --env MCP_CLICKHOUSE_DSN=<YOUR_MCP_CLICKHOUSE_DSN> -- uvx mcp-clickhousex

Related MCP servers

Microsoft SQL Server

Active

Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.

MIT

View repository →

Walmart Connect Advertising APIs

Active

MCP server for Walmart Connect Ads APIs (Sponsored Search + Display)

Python

MIT

View repository →

Atlassian Attachments

Active

MCP server for downloading Jira and Confluence Cloud attachments by attachment ID.

Python

MIT

View repository →