← all servers
[databases][OFFICIAL]
ClickHouse
Run read-only SQL queries against a ClickHouse database and inspect its schema.
ClickHouse's own MCP server, giving a model a safe way to explore a ClickHouse database: listing databases and tables, reading table schemas, and running read-only SQL queries against your data.
Ships as a Python package and connects to any self-hosted ClickHouse server or ClickHouse Cloud instance.
install
uvx mcp-clickhouse{
"mcpServers": {
"clickhouse": {
"command": "uvx",
"args": ["mcp-clickhouse"],
"env": {
"CLICKHOUSE_HOST": "localhost",
"CLICKHOUSE_USER": "default",
"CLICKHOUSE_PASSWORD": ""
}
}
}
}