ClickHouse MCP Server

MCPOpen SourceMIT16.0

by AminKhorramii • Data & Databases

A TypeScript MCP server that exposes ClickHouse to MCP clients (e.g., Claude Desktop), enabling natural-language SQL queries and database inspection.

Example Use Cases

1
Run arbitrary SQL queries against a ClickHouse instance using natural-language prompts.
2
Inspect database metadata (list databases, tables, and schemas) to provide context-aware responses.
3
A local or containerized MCP server to integrate ClickHouse access into Claude Desktop or other MCP-capable clients.

Description

This project implements a Model Context Protocol (MCP) server written in TypeScript to connect MCP-aware clients to ClickHouse databases. It provides environment-configurable connection options (including secure TLS, timeouts, and default database), Docker support, and a published npm package for easy use. Integrates with Claude Desktop and the ClickHouse SQL Playground so users can run queries, list databases/tables, and inspect schema using natural language.

Quick Actions

View on GitHub

Security

Scanned 5 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

OwnerAminKhorramii

CategoryData & Databases

DependenciesStandalone