cyberneticlibrary
← library

Run analytical queries without SQL editor

clickhousemcp_serversetup L2★0
smithery:clickhouse ↗
What it does

Query ClickHouse analytical database via MCP

Best for

Letting AI agents run analytical queries on ClickHouse without SQL editor.

Inputs
  • · SQL query (SELECT, with CTEs and window functions)
  • · database connection parameters
Outputs
  • · query result rows (JSON or native format)
  • · schema metadata (tables, columns, types)
Requires
  • · ClickHouse server (running and network-accessible)
  • · database credentials
Preconditions
  • · ClickHouse instance running and reachable
  • · database credentials configured
  • · network access / firewall rules allow connection
Failure modes
  • · no built-in query timeout (can hang indefinitely)
  • · large result sets may crash MCP client
  • · complex queries may be optimized unpredictably
Trust signals
  • · ClickHouse ecosystem integration