Mcp Clickhouse

A local MCP server that gives an AI assistant read-only access to ClickHouse for analytics queries, table inspection, sizes and health checks.

What you can do

Run read-only analytics queries against ClickHouse and get results back for the assistant to interpret or summarize. Inspect tables and their structure to understand what data is available. Check table sizes and overall database health. All access is described as read-only, so the assistant can explore and report without changing stored data.

When to use it

Useful when an assistant needs to answer questions from data already stored in ClickHouse, such as ad-hoc analytics, schema exploration, or quick health and size checks, without giving it write access.

Requirements

Runs as a local process over stdio, installed from the npm package @infoinlet/mcp-clickhouse, so Node.js and npm are needed. It is desktop-only and not web-executable. The manifest declares no authentication, environment variables or headers, so connection details for the ClickHouse instance are not documented here and would need to be supplied some other way.