ClickHouse MCP Server vs InstantDB MCP

A side-by-side comparison of two Databases servers — tools, transport, auth, maintenance, and copy-paste config for each.

	ClickHouse MCP Server Official ClickHouse server: read-only SQL queries plus database/table exploration and chDB support. Verified stdio (local) API key Python	InstantDB MCP Create, manage, and query your InstantDB apps, schemas, permissions, and data from your AI editor. Unverified HTTP (remote) OAuth TypeScript
Category	Databases	Databases
Language	Python	TypeScript
Transport	stdio (local)	HTTP (remote)
Auth	API key	OAuth
GitHub stars	1.0k	10k
Last commit	2 months ago	1 month ago
Verified
Actively maintained
Install	`uvx mcp-clickhouse`	`npx -y @instantdb/mcp --token <token>`
Repo	Open	Open

Verdict

Pick ClickHouse MCP Server if you want the official, vendor-maintained server, and you want a local (stdio) server that keeps data on your machine.

Pick InstantDB MCP if you prefer the more popular, battle-tested option, and you want a hosted/remote server with nothing to install.

Add ClickHouse MCP Server

Install / run

uvx mcp-clickhouse

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

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

Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.

Add InstantDB MCP

Install / run

npx -y @instantdb/mcp --token <token>

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

{
  "mcpServers": {
    "instantdb-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://mcp.instantdb.com/mcp"
      ]
    }
  }
}

Claude Desktop connects to remote servers through the `mcp-remote` proxy (installed on first run via npx). Restart Claude Desktop after saving.

FAQ

ClickHouse MCP Server or InstantDB MCP — which is better?

Pick ClickHouse MCP Server if you want the official, vendor-maintained server, and you want a local (stdio) server that keeps data on your machine. Pick InstantDB MCP if you prefer the more popular, battle-tested option, and you want a hosted/remote server with nothing to install.

Can I use both ClickHouse MCP Server and InstantDB MCP?

Yes — MCP clients let you enable multiple servers at once. Add both configs to your client's mcpServers and use whichever tool fits the task.

Do ClickHouse MCP Server and InstantDB MCP work with Claude, Cursor and Windsurf?

Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.

View ClickHouse MCP Server →View InstantDB MCP →More comparisons →