drio
Open app

ClickHouse MCP Server

Source

Catalog onlyCatalog onlySTDIO

Overview

clickhouse_mcp_server is a server implementation designed to work with ClickHouse, a fast open-source columnar database management system. It provides a way to manage and interact with ClickHouse databases efficiently.

To use clickhouse_mcp_server, clone the repository from GitHub, set up your ClickHouse instance, and configure the server parameters as needed. You can then run the server to manage your database operations.

  • Efficient management of ClickHouse databases - Support for various database operations - Easy integration with existing ClickHouse setups
  1. Managing large datasets in ClickHouse for analytics.
  2. Integrating ClickHouse with other applications for data processing.
  3. Providing a server interface for database operations.

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-dubin555": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-dubin555"
      ]
    }
  }
}

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-dubin555": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-dubin555"
      ]
    }
  }
}

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-dubin555": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-dubin555"
      ]
    }
  }
}

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-dubin555": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-clickhouse-mcp-server-dubin555"
      ]
    }
  }
}

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

What is ClickHouse?

ClickHouse is a fast open-source columnar database management system designed for online analytical processing (OLAP).

Is clickhouse_mcp_server free to use?

Yes! clickhouse_mcp_server is open-source and free to use under the Apache-2.0 license.

How can I contribute to clickhouse_mcp_server?

You can contribute by submitting issues or pull requests on the GitHub repository.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":3444,"uuid":"77c0cacc-35b7-4af4-95ca-571a2dda7cbf","name":"clickhouse_mcp_server","title":"ClickHouse MCP Server","description":"","avatar_url":"https://avatars.githubusercontent.com/u/8174807?v=4","created_at":"2025-03-19T16:34:07.332+00:00","updated_at":"2025-03-19T16:36:57.885+00:00","status":"created","author_name":"dubin555","author_avatar_url":"https://avatars.githubusercontent.com/u/8174807?v=4","tags":"[]","category":"databases","is_featured":false,"sort":1,"url":"https://github.com/dubin555/clickhouse_mcp_server","target":"_self","content":"$29","summary":"$2a","img_url":"https://github.com/dubin555/clickhouse_mcp_server/raw/main/pics/demo.png","type":null,"metadata":"{\"star\":\"0\",\"license\":\"Apache-2.0 license\",\"language\":\"Python\",\"is_official\":false,\"latest_commit_time\":\"2025-03-20 19:17:10\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Databases