Skip to main content
Glama
Sign In
enesjakozh
ThomAub

ClickHouse MCP Server

by ThomAub
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Hybrid

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

Related MCP server: ClickHouse MCP Server

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.

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • clickhouse-mcp-server

    burakdirin
    A
    license
    B
    quality
    C
    maintenance
    An MCP server implementation that enables Claude AI to interact with Clickhouse databases. Features include secure database connections, query execution, read-only mode support, and multi-query capabilities.
    2
    22 PyPI
    2
    MIT
  • MCP TapData Server by tapdata

    MCP TapData Serverofficial

    tapdata
    F
    license
    Not graded
    quality
    D
    maintenance
    A Model Context Protocol server that enables Large Language Models to access and interact with database connections, including viewing schemas and performing CRUD operations on connected databases.
    -
  • ExecuteAutomation Database Server by executeautomation

    ExecuteAutomation Databaseofficial

    executeautomation
    A
    license
    Not graded
    quality
    F
    maintenance
    A Model Context Protocol server that enables LLMs like Claude to interact with SQLite and SQL Server databases, allowing for schema inspection and SQL query execution.
    1,126 npm
    388
    MIT

Appeared in Searches