MCP server for ClickHouse
Top 66.0% on sourcepulse
This project provides an MCP (Message Communication Protocol) server for ClickHouse, enabling programmatic interaction with ClickHouse databases. It's designed for developers and data engineers who need to integrate ClickHouse functionality into applications or workflows, offering tools to execute SQL queries, list databases, and list tables.
How It Works
The server leverages the uv
Python runtime and is configured via environment variables or a JSON configuration file. It establishes a connection to a ClickHouse instance using provided host, port, user, and password credentials. The core functionality includes executing arbitrary SQL queries (with a readonly=1
safety setting) and metadata retrieval operations like listing databases and tables.
Quick Start & Requirements
uv sync
and running mcp dev mcp_clickhouse/mcp_server.py
.uv
runtime. Docker is recommended for local development.Highlighted Details
Maintenance & Community
The project is part of the ClickHouse ecosystem. Further community and roadmap details are not explicitly provided in the README.
Licensing & Compatibility
The README does not specify a license. Compatibility for commercial or closed-source linking is not detailed.
Limitations & Caveats
The README emphasizes that default or administrative users should be avoided for security. The project appears to be primarily for integration with Claude Desktop, and its standalone usage or broader compatibility is not fully detailed.
1 day ago
Inactive