What is an MCP Server?
An MCP (Model Context Protocol) server acts as a bridge, allowing AI models to access and interact with external data sources and tools.
What is Clickhouse and why use it with Claude AI?
Clickhouse is a high-performance, column-oriented database. Integrating it with Claude AI via the MCP server allows AI agents to leverage the speed and scalability of Clickhouse for data-driven tasks.
What tools does the Clickhouse MCP Server provide?
The server provides two tools: connect_database for establishing a connection to a Clickhouse database and execute_query for executing SQL queries.
What environment variables are used to configure the server?
The server uses environment variables such as CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE, and CLICKHOUSE_READONLY to configure the connection settings.
How can I install the Clickhouse MCP Server?
You can install the server using uv or pip package managers.
How do I install via Smithery?
You can install Clickhouse Database Integration Server for Claude Desktop automatically via Smithery using the command: npx -y @smithery/cli install @burakdirin/clickhouse-mcp-server --client claude
How do I debug the Clickhouse MCP Server?
The documentation recommends using the MCP Inspector, a debugging tool that provides a visual interface for monitoring the communication between the AI agent and the server.
Does the Clickhouse MCP Server integrate with UBOS?
Yes, the Clickhouse MCP Server seamlessly integrates with the UBOS platform, unlocking even greater potential for AI agent development and deployment through simplified orchestration, enhanced data connectivity, and customizable AI agents.
What are some use cases for the Clickhouse MCP Server?
Use cases include real-time analytics, personalized recommendations, fraud detection, customer support automation, and supply chain optimization.
Clickhouse MCP Server
Project Details
- burakdirin/clickhouse-mcp-server
- MIT License
- Last Updated: 3/17/2025
Recomended MCP Servers
A Model Context Protocl (MCP) server for Laravel 12 Documentation
A JavaScript / TypeScript / Python / C# / PHP / Go cryptocurrency trading API with support for...
Azure Cosmos DB MCP Client and Server
A simple MCP integration that allows Claude to read and manage a personal Notion todo list
FRED (Federal Reserve Economic Data) API integration with Model Context Protocol (MCP)
MCP Terminal 是一个基于 MCP（Model Context Protocol）的终端控制服务器，专为与大型语言模型（LLM）和 AI 助手集成而设计。它提供了一个标准化的接口，使 AI 可以执行终端命令并获取输出结果。
This is a tool to scrape/download images and data from Vinted & Depop using the API and stores...
CTX: The missing link between your codebase and your LLM. Context as Code (CaC) tool with MCP server...
MCP server that generates mock data.
Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support,...
Featured Templates
View More
