ClickHouse MCP ServerServer

dubin555
GitHub
databaseAIMCP

Loading subscription status...

💡 Description

A Model Context Protocol (MCP) server implementation for ClickHouse that provides AI assistants with a secure and structured way to explore and analyze databases.

📝 JSON Entries

{
  "mcpServers": [
    {
      "clickhouse": {
        "env": {
          "CLICKHOUSE_HOST": "localhost",
          "CLICKHOUSE_PORT": "8123",
          "CLICKHOUSE_USER": "default",
          "CLICKHOUSE_DATABASE": "default",
          "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD"
        },
        "args": [
          "--directory",
          "/path/to/clickhouse_mcp_server",
          "run",
          "-m",
          "clickhouse_mcp_server.server"
        ],
        "command": "uv"
      }
    }
  ]
}

🛠️ Tools

Pythonuv package manager

Features

  • Provides SQL query execution
  • Securely interacts with databases

💬 Example Queries

  • What is the sales volume in each region?
  • Which product is the best - selling?