ClickHouse MCP Server

MCPOpen SourceApache-2.016.5

by Ilya1991 • Data & Databases

An MCP server that lets agents execute read-only SQL queries and inspect databases and tables on a ClickHouse cluster.

Example Use Cases

1
Execute read-only SQL queries against a ClickHouse cluster to retrieve analytics or telemetry data.
2
Discover schema and structure by listing available databases and tables before constructing queries.
3
A safe, read-only interface to ClickHouse (readonly enforced) integrated into Claude Desktop or other MCP-enabled environments.

Description

This MCP server exposes tools to run SELECT queries (enforced readonly), list databases, and list tables in a ClickHouse cluster. It is configured via environment variables and supports secure connections, timeouts, and an optional default database. The README includes simple deployment and development instructions (including a Docker-based test cluster and a Claude Desktop configuration). It's useful for safely integrating ClickHouse data access into agent workflows without permitting writes.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D44/100

4/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

OwnerIlya1991

CategoryData & Databases

DependenciesStandalone