npx mcpbar@latest install ThomAub/clickhouse_mcp_server -c claude

npx mcpbar@latest edit -c claude

{
  "mcpServers": {
    "ClickHouse MCP Server": {
      "command": "uvx",
      "args": [
        "clickhouse-mcp-server"
      ],
      "env": {}
    }
  }
}

ClickHouse MCP Server

This project implements a Model Context Protocol (MCP) server for ClickHouse, allowing seamless integration of ClickHouse databases with Large Language Models (LLMs) and other AI applications.

Features

• List ClickHouse databases and tables as resources
• Retrieve table schemas
• Execute SELECT queries on ClickHouse databases
• Secure and efficient communication using the MCP protocol

Requirements

• Python 3.10+
• ClickHouse server

Installation

1. Clone the repository:

   git clone https://github.com/ThomAub/clickhouse_mcp_server.git
   cd clickhouse_mcp_server
   

2. Install the required packages:

   uv sync --all-extras
   

3. Set up your ClickHouse connection details in environment variables or update the get_clickhouse_client function in server.py.

Usage

Run the server:

python clickhouse_mcp_server/server.py

The server will start and listen for MCP requests.

Testing

Run the tests using pytest:

pytest tests/

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

License

This project is licensed under the MIT License.