ClickHouse Cloud MCP Server logo

ClickHouse Cloud MCP Server

by alexkorep

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

View on GitHub

Last updated: N/A

What is ClickHouse Cloud MCP Server?

This is an MCP server that exposes ClickHouse Cloud API endpoints via MCP tools. It authenticates using ClickHouse OpenAPI Key ID and Secret provided via environment variables and handles JSON request bodies and responses.

How to use ClickHouse Cloud MCP Server?

  1. Clone the repository.
  2. Install dependencies using npm install.
  3. Build the TypeScript code using npm run build.
  4. Configure the required environment variables: CLICKHOUSE_API_KEY_ID, CLICKHOUSE_API_SECRET, and optionally CLICKHOUSE_API_URL.
  5. Add the server configuration to your claude_desktop_config.json file, specifying the command, arguments, and environment variables.

Key features of ClickHouse Cloud MCP Server

  • Exposes ClickHouse Cloud API endpoint via MCP tools

  • Authenticates using ClickHouse OpenAPI Key ID and Secret

  • Handles JSON request bodies and responses

Use cases of ClickHouse Cloud MCP Server

  • Managing ClickHouse Cloud organizations

  • Managing ClickHouse Cloud services

FAQ from ClickHouse Cloud MCP Server

What is the default ClickHouse API URL?

The default ClickHouse API URL is https://api.clickhouse.cloud.

What environment variables are required?

The required environment variables are CLICKHOUSE_API_KEY_ID and CLICKHOUSE_API_SECRET.

How do I use this with Claude Desktop?

Add the provided configuration to your claude_desktop_config.json file.

What is an MCP server?

MCP stands for Managed Control Plane. It's a server that provides tools to manage and interact with a specific service or API.

What is the purpose of this server?

The purpose of this server is to provide a convenient way to interact with the ClickHouse Cloud API through MCP tools.