Clickhouse MCP server

An MCP server implementation that enables Claude AI to interact with Clickhouse databases.

Catalog onlyCatalog onlySTDIO

Overview

Clickhouse MCP Server is an implementation that allows Claude AI to interact with Clickhouse databases, facilitating seamless database operations.

To use the Clickhouse MCP Server, install it via uv or pip, configure the necessary environment variables, and utilize the provided tools to connect to databases and execute queries.

Connects to specific Clickhouse databases. - Executes SQL queries and returns results in JSON format. - Supports multiple queries in a single execution.

Integrating Claude AI with Clickhouse for data analysis.
Automating database queries for reporting purposes.
Facilitating data retrieval for machine learning applications.

Add to your AI client

Use these steps to connect Clickhouse MCP server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "clickhouse-mcp-server-burakdirin": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-burakdirin"
      ]
    }
  }
}

FAQ

What programming language is Clickhouse MCP Server written in?

Clickhouse MCP Server is written in Python.

How do I install Clickhouse MCP Server?

You can install it using `uv pip install clickhouse-mcp-server` or `pip install clickhouse-mcp-server`.

Is there a way to debug the server?

Yes, you can use the MCP Inspector for debugging.

Developer tools