Mcp Server Clickhouse

1 MIT

FreeCommunity

AI Systems

MCP server for ClickHouse Cloud API management and interaction.

What is Mcp Server Clickhouse

mcp-server-clickhouse is a server that provides tools to interact with the ClickHouse Cloud API (v1), enabling management of organizations and services within ClickHouse Cloud.

Use cases

Use cases include managing data analytics workflows, integrating ClickHouse Cloud with other applications, and automating data operations within organizations.

How to use

To use mcp-server-clickhouse, clone the repository, install dependencies using ‘npm install’, build the TypeScript code with ‘npm run build’, and configure the environment variables for your ClickHouse API key before running the server.

Key features

Key features include exposing the ClickHouse Cloud API endpoint via MCP tools, authenticating using ClickHouse OpenAPI Key ID and Secret, and handling JSON request bodies and responses.

Where to use

mcp-server-clickhouse can be used in cloud-based data analytics, business intelligence applications, and any environment requiring interaction with ClickHouse Cloud services.

Clients Supporting MCP

The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.

Claude Desktop: Official desktop application from Anthropic, natively supports MCP protocol. claude.ai

Cherry Studio: Cross-platform desktop client supporting multiple LLM providers, built-in MCP server support. cherry-ai.com

LobeChat: Modern open-source ChatGPT/LLMs UI, supports MCP protocol integration. lobehub.com

DeepChat: Cross-platform desktop AI assistant, compatible with MCP protocol, focusing on privacy and efficiency. deepchat.thinkinai.xyz

5ire: Cross-platform open-source desktop intelligent assistant MCP client, supports local knowledge base and MCP server. 5ire.app

View More MCP Clients

Overview

What is Mcp Server Clickhouse

mcp-server-clickhouse is a server that provides tools to interact with the ClickHouse Cloud API (v1), enabling management of organizations and services within ClickHouse Cloud.

Use cases

Use cases include managing data analytics workflows, integrating ClickHouse Cloud with other applications, and automating data operations within organizations.

How to use

Key features

Key features include exposing the ClickHouse Cloud API endpoint via MCP tools, authenticating using ClickHouse OpenAPI Key ID and Secret, and handling JSON request bodies and responses.

Where to use

mcp-server-clickhouse can be used in cloud-based data analytics, business intelligence applications, and any environment requiring interaction with ClickHouse Cloud services.

Clients Supporting MCP

The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.

Claude Desktop: Official desktop application from Anthropic, natively supports MCP protocol. claude.ai

Cherry Studio: Cross-platform desktop client supporting multiple LLM providers, built-in MCP server support. cherry-ai.com

LobeChat: Modern open-source ChatGPT/LLMs UI, supports MCP protocol integration. lobehub.com

DeepChat: Cross-platform desktop AI assistant, compatible with MCP protocol, focusing on privacy and efficiency. deepchat.thinkinai.xyz

5ire: Cross-platform open-source desktop intelligent assistant MCP client, supports local knowledge base and MCP server. 5ire.app

View More MCP Clients

Content

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"
      }
    }
  }
}

Dev Tools Supporting MCP

The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.

Zed: High-performance collaborative code editor, supports MCP protocol, providing a smooth programming experience. zed.dev

Cursor: AI code editor built on VS Code, supports MCP protocol for context-aware programming. cursor.com

Windsurf: AI code editor from Codeium, integrates MCP protocol to provide intelligent code assistance. windsurf.com

Continue: Open-source AI programming assistant plugin, supports VS Code and JetBrains, compatible with MCP protocol. continue.dev

Trae: AI-driven code editor, supports MCP protocol, focusing on enhancing developer programming experience. trae.ai

View More MCP Dev Tools

Tools

No tools

Comments

Recommend MCP Servers

Tavily MCP Server The Tavily MCP server provides: search, extract, map, crawl tools Real-time web search capabilities through the tavily-search tool Intelligent data extraction from web pages via the tavily-extract tool Powerful web mapping tool that creates a structured map of website Web crawler that systematically explores websites.

MCP Server Chart This is a TypeScript-based MCP server that provides chart generation capabilities. It allows you to create various types of charts through MCP tools. You can also use it in Dify.

GitHub MCP Server MCP Server for the GitHub API, enabling file operations, repository management, search functionality, and more.

Brave Search MCP Server Web and local search using Brave's Search API

Firecrawl MCP Server Advanced web scraping with JavaScript rendering, PDF support, and smart rate limiting

Context7 MCP LLMs rely on outdated or generic information about the libraries you use. You get:

Slack MCP server Channel management and messaging capabilities

Sequential Thinking MCP Server Dynamic and reflective problem-solving through thought sequences

Fetch MCP Server A Model Context Protocol server that provides web content fetching capabilities.

Playwright MCP A Model Context Protocol (MCP) server that provides browser automation capabilities using [Playwright](https://playwright.dev). This server enables LLMs to interact with web pages through structured accessibility snapshots, bypassing the need for screenshots or visually-tuned models.

View All MCP Servers