ClickHouse

stdiononeofficial★ 784database

Query your ClickHouse database server.

Install

How to run this server

[ { "cmd": "pip install 'mcp-clickhouse[chdb]'`", "imports": [] } ]

server path: clickhouse

Tools

What this server exposes

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.

Configuration

Environment & auth

authnone

envCLICKHOUSE_MCP_AUTH_TOKEN

envFASTMCP_SERVER_AUTH_AZURE_TENANT_ID

envFASTMCP_SERVER_AUTH_AZURE_CLIENT_ID

envFASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET

envCLICKHOUSE_HOST

envCLICKHOUSE_PORT

envCLIENT_CONFIG_OVERRIDES_KEY

envCLICKHOUSE_MCP_BIND_HOST

envCLICKHOUSE_MCP_BIND_PORT

Resources