{"slug":"ClickHouse/mcp-clickhouse","name":"ClickHouse","description":"Query your ClickHouse database server.","category":"database","tags":[],"official":true,"stars":784,"transport":"stdio","install":[{"cmd":"pip install 'mcp-clickhouse[chdb]'`","imports":[]}],"tools":[{"name":"run_query","description":"Execute SQL queries on your ClickHouse cluster. Queries run in read-only mode by default, but writes can be enabled explicitly if needed."},{"name":"list_databases","description":"List all databases on your ClickHouse cluster."},{"name":"list_tables","description":"List tables in a database with pagination, filtering, and optional column metadata."},{"name":"run_chdb_select_query","description":"Execute SQL queries using chDB's embedded ClickHouse engine. Query data directly from various sources (files, URLs, databases) without ETL processes."}],"env_vars":["CLICKHOUSE_MCP_AUTH_TOKEN","FASTMCP_SERVER_AUTH_AZURE_TENANT_ID","FASTMCP_SERVER_AUTH_AZURE_CLIENT_ID","FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET","CLICKHOUSE_HOST","CLICKHOUSE_PORT","CLIENT_CONFIG_OVERRIDES_KEY","CLICKHOUSE_MCP_BIND_HOST","CLICKHOUSE_MCP_BIND_PORT"],"auth_type":"none","github":"https://github.com/ClickHouse/mcp-clickhouse","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}