PluginBench
MCP Server
Active
MIT

ClickHouse MCP Server

io.github.alyiox/mcp-clickhousex

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

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.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "mcp-clickhousex": {
      "command": "uvx",
      "args": [
        "mcp-clickhousex"
      ],
      "env": {
        "MCP_CLICKHOUSE_DSN": "<YOUR_MCP_CLICKHOUSE_DSN>"
      }
    }
  }
}

Related MCP servers

Local RAG MCP for markdown documentation. Retrieval only; host synthesizes answers.

0
Python
MIT
View repository →

Read-only-by-default SQL Server: schema, parameterized SELECT, execution plans; writes opt-in.

6
C#
MIT
View repository →

MCP server that fronts any OpenAPI service: discover operations from its spec and call them

0
Python
MIT
View repository →

Deprecated; use io.github.alyiox/mcp-walmart-ads.

1
Python
MIT
View repository →

MCP server for Walmart Connect Ads, Sam's Club Sponsored Ads, and Walmart Marketplace APIs

1
Python
MIT
View repository →

Deprecated; use io.github.alyiox/mcp-walmart-ads.

1
Python
MIT
View repository →