mcp-server-clickhouse

# 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: ```bash npm install ``` Build the TypeScript code: ```bash 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`: ```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" } } } } ```