ClickHouse

Official

Query your ClickHouse server

About ClickHouse MCP Server

ClickHouse is an MCP server in the Data category. It exposes tools, resources to connected AI applications, enabling them to interact with clickhouse capabilities through the standardized Model Context Protocol.

Features

Tools
Resources

Category

Data
Getting Started

To use the ClickHouse MCP server in your AI application, follow these steps:

  1. Install the MCP client SDK for your platform
  2. Connect to the ClickHouse MCP server
  3. Authenticate with your ClickHouse credentials
  4. Start using the tools, resources, and prompts provided by the server

Example Code


// Connect to the ClickHouse MCP server
const server = await mcp.connect("clickhouse");

// List available tools
const tools = await server.tools.list();

// List available resources
const resources = await server.resources.list();

// List available prompts
const prompts = await server.prompts.list();
                      
Installation

npm

npm install @mcp/server-clickhouse

pip

pip install mcp-server-clickhouse
Compatible With
Claude Desktop
Cursor
Windsurf
Zed
Any MCP-compatible client