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.
Use cases
- Let agents inspect ClickHouse schemas with paginated `list_tables` filters before writing analytics SQL
- Run read-only diagnostics queries during on-call investigations from MCP clients
- Query local or remote datasets through chDB when the optional extra is installed
- Front HTTP/SSE MCP with bearer tokens or Azure/Google OAuth via FastMCP in production
- Monitor server health through the documented `/health` endpoint on HTTP transports
Key features
- Cursor
- Claude Desktop
- VS Code
- Codex
Frequently Asked Questions
- Are writes allowed by default?
- README states queries run read-only unless CLICKHOUSE_ALLOW_WRITE_ACCESS is explicitly enabled.
- Does stdio transport need auth?
- No—authentication is required for HTTP/SSE transports only per security section.
- What is chDB support?
- Install pip install 'mcp-clickhouse[chdb]' to expose run_chdb_select_query for embedded ClickHouse queries.
Related
Related
3 Indexed items
DuckDB MCP community extension (`duckdb_mcp`)
The DuckDB-distributed community extension `duckdb_mcp` embeds MCP client and server capabilities directly inside DuckDB. Installers load it via `INSTALL duckdb_mcp FROM community` followed by `LOAD duckdb_mcp`, after which SQL can attach remote MCP servers (stdio/TCP/WebSocket transports), enumerate resources (`mcp_list_resources`), invoke remote tools (`mcp_call_tool`), and wrap responses with `read_csv`/`read_json`/`read_parquet` URIs routed through `mcp://`. In reverse direction, DuckDB can publish tables, queries, and execution-bound tools (`mcp_publish_table`, `mcp_publish_query`, `mcp_publish_execution_tool`) while `mcp_server_start` exposes them to external MCP-compatible clients.
Neon MCP Server
Official Neon MCP integration exposes Neon Postgres projects to MCP-capable assistants via Streamable HTTP (`https://mcp.neon.tech/mcp`), legacy SSE (`https://mcp.neon.tech/sse`), or a locally launched `@neondatabase/mcp-server-neon` package. Documentation lists tools for project and branch lifecycle, SQL execution, migration rehearsal branches, slow-query diagnostics, Neon Auth provisioning, Data API setup, and embedded Neon docs retrieval—each mapped to Neon API operations.
Qdrant MCP Server
Official Qdrant MCP server implementation that gives AI agents a semantic memory layer backed by Qdrant vector search. It exposes MCP tools for storing information and retrieving relevant context, so assistants can persist and recall facts across sessions instead of relying only on short chat history.