Related MCP Server Resources

Explore more AI models, providers, and integration options:

  • Explore AI Models
  • Explore AI Providers
  • Explore MCP Servers
  • LangDB Pricing
  • Documentation
  • AI Industry Blog
  • S3 MCP Server
  • MongoDB MCP Server for LLMs
  • Jira MCP Server
  • OpenAPI MCP Server
  • SQLite MCP Server
Back to MCP Servers
ClickHouse MCP Server

ClickHouse MCP Server

Public
ThomAub/clickhouse_mcp_server

A Model Context Protocol server that enables Large Language Models to seamlessly interact with ClickHouse databases, supporting resource listing, schema retrieval, and query execution.

Verified
python
0 tools
May 29, 2025
Updated May 30, 2025

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.

Publicly Shared Threads0

Discover shared experiences

Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!

Share your threads to help others
Related MCPs5
  • S3 MCP Server
    S3 MCP Server

    An Amazon S3 Model Context Protocol server that allows Large Language Models like Claude to interact...

    3 tools
    Added May 30, 2025
  • MongoDB MCP Server for LLMs
    MongoDB MCP Server for LLMs

    An MCP server that enables large language models to interact directly with MongoDB databases, allowi...

    Added May 30, 2025
  • Jira MCP Server
    Jira MCP Server

    A Model Context Protocol server that enables AI assistants like Claude to interact with Jira, allowi...

    Added May 30, 2025
  • OpenAPI MCP Server
    OpenAPI MCP Server

    A Model Context Protocol Server that enables LLMs to interact with and execute REST API calls throug...

    Added May 30, 2025
  • SQLite MCP Server
    SQLite MCP Server

    A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and...

    Added May 30, 2025