mcpField
C
ClickHouse Cloud MCP Server

ClickHouse Cloud MCP Server

Local
github.com/alexkorepDatabases1Updated 81w ago
Repository

About ClickHouse Cloud MCP Server

ClickHouse Cloud MCP Server exposes parts of the ClickHouse Cloud API v1 through MCP tools. It is for users managing organizations and services, and authenticates with an API key ID and secret supplied through environment variables.

Key features

  1. 01Expose ClickHouse Cloud API endpoints as tools
  2. 02Manage organizations and services
  3. 03Authenticate with API key ID and secret
  4. 04Handle JSON request bodies and responses

Use cases

  1. 01Manage ClickHouse Cloud organizations
  2. 02Manage ClickHouse Cloud services
  3. 03Call the API through an MCP client

MCP support

It exposes ClickHouse Cloud API v1 endpoints as tools for MCP clients. The documented scope includes organization and service management.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

ClickHouse Cloud MCP Server

This MCP server provides tools to interact with the ClickHouse Cloud API (v1). It allows managing organizations and services, the rest is TODO.

Features

  • Exposes ClickHouse Cloud API endpoint via MCP tools.
  • Authenticates using ClickHouse OpenAPI Key ID and Secret provided via environment variables.
  • Handles JSON request bodies and responses.

Prerequisites

You need a ClickHouse Cloud API Key.

Installation

Clone this repository and install the dependencies:

npm install

Build the TypeScript code:

npm run build

This will create a dist directory containing the compiled JavaScript file.

Configuration

This server requires the following environment variables to be set:

  • CLICKHOUSE_API_KEY_ID: Your ClickHouse Cloud API Key ID.
  • CLICKHOUSE_API_SECRET: Your ClickHouse Cloud API Key Secret.
  • CLICKHOUSE_API_URL: The base URL for the ClickHouse Cloud API (default is https://api.clickhouse.cloud). Use http://localhost:2023 for local development.

Usage with Claude Desktop

Add the following configuration to your claude_desktop_config.json:

{
  "mcpServers": {
    "clickhouse": {
      "command": "node",
      "args": [
        "/full/path/to/dist/index.js"
      ],
      "env": {
        "CLICKHOUSE_API_KEY_ID": "key id",
        "CLICKHOUSE_API_SECRET": "key secret",
        "CLICKHOUSE_API_URL": "http://localhost:2023"
      }
    }
  }
}

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.