ClickHouse documents a fully managed remote Model Context Protocol server for ClickHouse Cloud at clickhouse.com/docs/cloud/features/ai-ml/remote-mcp. Connect MCP clients to the HTTP endpoint `https://mcp.clickhouse.cloud/mcp` with OAuth 2.0 (browser sign-in with ClickHouse Cloud credentials; no separate API key required per docs). Agents can list databases and tables, inspect schemas, and run scoped read-only SELECT queries; the remote server also exposes richer ClickHouse Cloud integration such as service management, backup monitoring, ClickPipe visibility, and billing data per ClickHouse docs. Enable per service in the Cloud console (Connect → MCP). For self-hosted ClickHouse, ClickHouse maintains the separate open-source mcp-clickhouse project—distinct from this Cloud remote MCP.
Use cases
- Let agents explore ClickHouse Cloud schemas and run read-only analytics SQL
- Prototype agent-facing analytics over warehouse data without local mcp-clickhouse setup
- Monitor ClickHouse Cloud backups and ClickPipes from MCP clients
- Compare remote Cloud MCP against clickhouse-mcp-server for self-hosted instances
- Pair with bigquery-mcp when evaluating multi-warehouse agent workflows
Key features
- Claude Desktop
- Cursor
- ChatGPT
- VS Code
Frequently Asked Questions
- Is this the same as mcp-clickhouse on GitHub?
- No—ClickHouse docs distinguish the Cloud remote MCP from the open-source mcp-clickhouse server for self-hosted instances.
- Can agents run write SQL?
- Docs describe scoped read-only SELECT queries for analytical context; verify current tool specs in ClickHouse MCP docs.
- How do I authenticate?
- ClickHouse Cloud remote MCP uses OAuth 2.0 browser sign-in scoped to organizations and services your user can access.
Related
Related
3 Indexed items
ClickHouse MCP Server
The open-source ClickHouse MCP server (PyPI package `mcp-clickhouse`, repository ClickHouse/mcp-clickhouse) exposes MCP tools such as `run_query`, `list_databases`, and paginated `list_tables` against ClickHouse clusters, defaulting to read-only SQL unless `CLICKHOUSE_ALLOW_WRITE_ACCESS` is enabled. Optional chDB extras add `run_chdb_select_query` for embedded queries over files and URLs. HTTP/SSE transports require authentication via `CLICKHOUSE_MCP_AUTH_TOKEN`, FastMCP OAuth/OIDC providers, or explicit `CLICKHOUSE_MCP_AUTH_DISABLED=true` for local dev; a `/health` endpoint supports orchestrator probes without credentials per README guidance.
BigQuery MCP Server
Google Cloud documents a remote BigQuery Model Context Protocol server at docs.cloud.google.com/bigquery/docs/use-bigquery-mcp, enabled when the BigQuery API is enabled. Connect MCP clients to the managed HTTP endpoint `https://bigquery.googleapis.com/mcp` with OAuth 2.0 and IAM (API keys are not accepted). Documented IAM roles include MCP Tool User (`roles/mcp.toolUser`), BigQuery Job User (`roles/bigquery.jobUser`), and BigQuery Data Viewer (`roles/bigquery.dataViewer`). Tools include `execute_sql` and `execute_sql_readonly` per the use guide; `execute_sql_readonly` allows only read-only operations while `execute_sql` is the sole non-read-only tool. Limitations documented: query processing capped at three minutes by default, results limited to 3,000 rows, and Google Drive external tables unsupported for those SQL tools.
MotherDuck MCP Server
MotherDuck documents a remote Model Context Protocol server at motherduck.com/docs/sql-reference/mcp hosted at `https://api.motherduck.com/mcp` with OAuth (or Bearer token) and read-write SQL access to MotherDuck cloud databases. Tools include `list_databases`, `list_tables`, `list_columns`, `search_catalog`, `query`, `query_rw`, `ask_docs_question`, Dive tools (`list_dives`, `read_dive`, `view_dive`, `save_dive`, etc.), and Flight scheduling tools (`list_flights`, `create_flight`, `run_flight`, etc.) per MotherDuck MCP docs. For local DuckDB files or custom configs, MotherDuck points to the open-source `mcp-server-motherduck` package (`uvx mcp-server-motherduck --db-path md:`) on github.com/motherduckdb/mcp-server-motherduck.