{"slug":"clickhouse","kind":"mcp","name":"ClickHouse MCP Server","summary":"ClickHouse's official MCP server for listing databases and tables and running read queries on ClickHouse.","owner":"ClickHouse","repoUrl":"https://github.com/ClickHouse/mcp-clickhouse","license":"Apache-2.0","categories":["databases","data-analytics"],"tags":["clickhouse","olap","analytics","sql","python"],"runtime":"python","local":true,"cloudCapable":true,"cloudCapability":"yes","cloudReadyOnPlatform":false,"needsApiKey":true,"reviewed":false,"syncedAt":"2026-10-13T00:00:00.000Z","sample":false,"url":"https://conduits.dev/tools/clickhouse","language":"Python","transports":["stdio"],"install":{"pypi":"mcp-clickhouse"},"requirements":{"env":[{"name":"CLICKHOUSE_HOST","required":true,"secret":false,"description":"ClickHouse server hostname"},{"name":"CLICKHOUSE_USER","required":true,"secret":false,"description":"ClickHouse username"},{"name":"CLICKHOUSE_PASSWORD","required":false,"secret":true,"description":"ClickHouse password (not needed with client-cert mTLS)"}],"service":"ClickHouse","upstreamMayCharge":true,"system":["uv (for uvx) or pip"]},"tools":[{"name":"run_query","description":"Run a SQL query"},{"name":"list_databases","description":"List databases"},{"name":"list_tables","description":"List tables"},{"name":"run_chdb_select_query","description":"Run a query on chDB (needs the optional extra)"}],"readme":"# ClickHouse MCP Server\n\nClickHouse's official MCP server for listing databases and tables and running read queries on ClickHouse.\n\n## Install\n\n```bash\nuvx mcp-clickhouse\n```\n\n## Configuration\n\n| Variable | Required | Description |\n| --- | --- | --- |\n| `CLICKHOUSE_HOST` | Yes | ClickHouse server hostname |\n| `CLICKHOUSE_USER` | Yes | ClickHouse username |\n| `CLICKHOUSE_PASSWORD` | No | ClickHouse password (not needed with client-cert mTLS) |\n\n## Tools\n\n- `run_query` — Run a SQL query\n- `list_databases` — List databases\n- `list_tables` — List tables\n- `run_chdb_select_query` — Run a query on chDB (needs the optional extra)\n\n## About this listing\n\nDetails were gathered from the project's public pages on 2026-10-13 and have not been reviewed by a person yet. Read the project's own documentation before giving it access to anything sensitive.\n\nSources:\n\n- <https://github.com/ClickHouse/mcp-clickhouse>\n- <https://pypi.org/pypi/mcp-clickhouse/json>"}