ClickHouse MCP Server

MCPOpen SourceMIT14.0

by bjpadhy • Data & Databases

An MCP server that exposes ClickHouse schemas and lets LLM agents run read-only SQL queries and natural-language data questions.

Example Use Cases

1
Inspect database metadata and table schemas from a ClickHouse instance.
2
Run validated, read-only SQL queries and retrieve sample data for analysis.
3
Answer natural-language questions about analytics data via integration with Claude Desktop.

Description

This repository implements a Model Context Protocol (MCP) server that connects to ClickHouse databases so LLMs (like Claude) can explore and analyze data via natural language. It exposes database and table schema resources, provides sample rows, and offers tools to execute validated read-only SQL queries. The server is designed for safe, read-only access and integrates with Claude Desktop for easy agent use. It helps bridge LLMs and analytics databases without granting DDL/DML permissions.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D45/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

Ownerbjpadhy

CategoryData & Databases

DependenciesStandalone