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
  • Azure Cosmos DB MCP Server
  • Ollama MCP Server
  • SQL Query MCP Server
  • Powertools MCP Search Server
  • OpenAPI MCP Server
Back to MCP Servers
ClickHouse MCP Server

ClickHouse MCP Server

Public
ThomAub/clickhouse_mcp_server

Enables seamless integration of ClickHouse databases with Large Language Models by providing secure Model Context Protocol support for listing resources, retrieving schemas, and executing SELECT queries.

python
0 tools
May 29, 2025
Updated Jun 4, 2025

Supercharge Your AI with ClickHouse MCP Server

MCP Server

Unlock the full potential of ClickHouse MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests

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
  • Azure Cosmos DB MCP Server
    Azure Cosmos DB MCP Server

    Enables seamless, secure interaction between AI language models and Azure Cosmos DB by translating n...

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

    Enables seamless integration of local Ollama LLM models with MCP-compatible applications, offering m...

    Added May 30, 2025
  • SQL Query MCP Server
    SQL Query MCP Server

    Enables natural language querying of PostgreSQL databases by translating prompts into SQL via LLM in...

    Added May 30, 2025
  • Powertools MCP Search Server
    Powertools MCP Search Server

    Model Context Protocol server enabling efficient local search of AWS Lambda Powertools documentation...

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

    Enables large language models to interact with REST APIs by providing configured REST API context an...

    Added May 30, 2025