ClickHouse MCP Server
Public
Provides a secure Model Context Protocol interface enabling AI assistants to explore, analyze, and query databases with controlled access to tables and data using SQL.
python
Provides a secure Model Context Protocol interface enabling AI assistants to explore, analyze, and query databases with controlled access to tables and data using SQL.
Unlock the full potential of ClickHouse MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.
Free tier available • No credit card required
Discover shared experiences
A Model Context Protocal (MCP) server implement for ClickHouse.
This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.
Set the following environment variables:
CLICKHOUSE_HOST=localhost CLICKHOUSE_PORT=8123 CLICKHOUSE_USER=default CLICKHOUSE_PASSWORD=CHANGE_TO_YOUR_PASSWORD CLICKHOUSE_DATABASE=default
Or via command-line args:
--host the database host--port the database port--user the database username--password the database password--database the database nameCheck the SQL in dev_contribute.md for details.
What is the sales volume in each region? Which product is the best - selling?
Configure the MCP server in VSCode, Cline extension, or other MCP client.: Example:
{ "mcpServers": { "clickhouse": { "command": "uv", "args": [ "--directory", "/path/to/clickhouse_mcp_server", "run", "-m", "clickhouse_mcp_server.server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_PORT": "8123", "CLICKHOUSE_USER": "default", "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD", "CLICKHOUSE_DATABASE": "default" } } } }
APACHE - See LICENSE file for details.
See dev_contribute.md for details.
uv package managerThis library's implementation was inspired by the following three repositories and incorporates their code, respect for the open-source spirit!
Thanks!
Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!
Provides AI assistants with seamless access to The Movie Database API via Model Context Protocol, en...
Provides Model Context Protocol (MCP) tools to access AWS CloudWatch logs, enabling AI assistants to...
Provides image generation capabilities via Google's Gemini 2 API using the Model Context Protocol, e...
Provides greeting-related tools, resources, and prompts via Model Context Protocol (MCP), enabling p...
Provides vector-based semantic search and real-time context augmentation for AI assistants by retrie...