ClickHouse MCP Server
ClickHouse's official MCP server: run SQL, list databases and tables on a ClickHouse cluster (read-only by default), with optional embedded chDB queries.
Tags
Description
Tools: run_query (with typed query parameters), list_databases, list_tables (paginated, with column metadata) and, with the optional chdb extra, run_chdb_select_query on the embedded chDB engine. Queries run read-only by default (CLICKHOUSE_ALLOW_WRITE_ACCESS=false); writes need an explicit opt-in and destructive statements such as DROP need a second flag, though the README notes the real security boundary is the ClickHouse user's grants. Defaults to stdio; HTTP/SSE transports require authentication by default and expose a /health endpoint. Install from PyPI as mcp-clickhouse (e.g. via uvx).
Related
- Postgres MCP Pro: Open-source Postgres MCP server with database health checks, index tuning, EXPLAIN plans with hypothetical indexes, schema intelligence and safe, configurable SQL execution.
- MCP Toolbox for Databases: Google's open-source MCP server for databases: prebuilt tools for MCP clients plus a framework for defining secure custom database tools for agents.
- MotherDuck / DuckDB MCP Server: MCP servers for DuckDB and MotherDuck: a managed remote server at api.motherduck.com/mcp and an open-source local server for DuckDB files, in-memory DBs and S3.
- MongoDB MCP Server: Official MCP server for querying and managing MongoDB databases and MongoDB Atlas clusters, with a read-only mode.
Guides & comparisons
- Data analysis agent stack (Stack): An agent that answers questions from your data: it queries DuckDB files, a ClickHouse warehouse or Postgres through read-only MCP servers, runs heavier analysis in a sandbox, reads spreadsheets and PDFs, and is tested and traced so you can trust the numbers.
Sources
- https://github.com/ClickHouse/mcp-clickhouse
- https://pypi.org/project/mcp-clickhouse/
- https://clickhouse.com/docs/guides/use-cases/ai-ml/MCP
Machine-readable
- JSON
- Markdown
- Source file on GitHub (edit via pull request)