ClickHouse
JSON →Query your ClickHouse database server.
Install
pip install 'mcp-clickhouse[chdb]'` Tools · 4
- run_query Execute SQL queries on your ClickHouse cluster. Queries run in read-only mode by default, but writes can be enabled explicitly if needed.
- list_databases List all databases on your ClickHouse cluster.
- list_tables List tables in a database with pagination, filtering, and optional column metadata.
- run_chdb_select_query Execute SQL queries using chDB's embedded ClickHouse engine. Query data directly from various sources (files, URLs, databases) without ETL processes.
Environment variables
CLICKHOUSE_MCP_AUTH_TOKENFASTMCP_SERVER_AUTH_AZURE_TENANT_IDFASTMCP_SERVER_AUTH_AZURE_CLIENT_IDFASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRETCLICKHOUSE_HOSTCLICKHOUSE_PORTCLIENT_CONFIG_OVERRIDES_KEYCLICKHOUSE_MCP_BIND_HOSTCLICKHOUSE_MCP_BIND_PORT
Links
★ 784 GitHub stars