ClickHouse MCP ServerServer

ThomAub
GitHub
databasesMCPAI integration

Loading subscription status...

💡 Description

This project implements a Model Context Protocol (MCP) server for ClickHouse, enabling seamless integration of ClickHouse databases with large language models (LLMs) and other AI applications.

📝 JSON Entries

{
  "mcpServers": [
    {
      "ClickHouse MCP Server": {
        "env": {},
        "args": [],
        "command": "python clickhouse_mcp_server/server.py"
      }
    }
  ]
}

🛠️ Tools

Python

Features

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

💬 Example Queries

  • List databases and tables in ClickHouse
  • Retrieve table schemas from ClickHouse
  • Execute SELECT queries on ClickHouse data