Clickhouse_mcp_server

Name: Clickhouse_mcp_server
Author: dubin555

by dubin555

8 GitHub

No known CVEs

Apache-2.0 license

Stale

Last commit 447d ago

Works with most clients

Transport: stdio, http

0 tools

Grade F

Edit this pageView history

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopstdio, http · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse": {
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_PORT": "8123",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_DATABASE": "default",
        "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD"
      },
      "args": [
        "--directory",
        "/path/to/clickhouse_mcp_server",
        "run",
        "-m",
        "clickhouse_mcp_server.server"
      ],
      "command": "uv"
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/clickhouse-mcp-server)](https://mcppedia.org/s/clickhouse-mcp-server)

Read me

What Clickhouse_mcp_server does

A Model Context Protocal (MCP) server implement for ClickHouse.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

28/100across 5 weighted dimensions

How we score →

0255075100

−72

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Clickhouse_mcp_server safe to use?: Clickhouse_mcp_server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under Apache-2.0.
How do I install Clickhouse_mcp_server?: Clickhouse_mcp_server supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
What AI clients work with Clickhouse_mcp_server?: Clickhouse_mcp_server is compatible with claude-desktop, cursor, claude-code. It uses stdio and http transport.
Is Clickhouse_mcp_server actively maintained?: Clickhouse_mcp_server is not actively maintained — last commit was 447 days ago. It has 8 GitHub stars.

Similar servers

Others in data

View all →

PostgreSQL MCP Server98

Query and manage PostgreSQL databases directly from AI assistants

87.0k 1

Supabase MCP Server97

Manage Supabase projects — databases, auth, storage, and edge functions

2.7k 4

Mysql_mcp_server96

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3k 2

io.github.mongodb-js/mongodb-mcp-server96

MongoDB Model Context Protocol Server

1.0k 3

MCP Security Weekly

Get CVE alerts and security updates for Clickhouse_mcp_server and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

{ "mcpServers": { "clickhouse": { "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_PORT": "8123", "CLICKHOUSE_USER": "default", "CLICKHOUSE_DATABASE": "default", "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD" }, "args": [ "--directory", "/path/to/clickhouse_mcp_server", "run", "-m", "clickhouse_mcp_server.server" ], "command": "uv" } } }

ClickHouse MCP Server

A Model Context Protocal (MCP) server implement for ClickHouse.

This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.

Configuration

Set the following environment variables:

CLICKHOUSE_HOST=localhost CLICKHOUSE_PORT=8123 CLICKHOUSE_USER=default CLICKHOUSE_PASSWORD=CHANGE_TO_YOUR_PASSWORD CLICKHOUSE_DATABASE=default

Or via command-line args:

--host the database host

--port the database port

--user the database username

--password the database password

--database the database name

CLINE

Configure the MCP server in VSCode, Cline extension, or other MCP client.: Example:

{ "mcpServers": { "clickhouse": { "command": "uv", "args": [ "--directory", "/path/to/clickhouse_mcp_server", "run", "-m", "clickhouse_mcp_server.server" ], "env": { "CLICKHOUSE_HOST": "localhost", "CLICKHOUSE_PORT": "8123", "CLICKHOUSE_USER": "default", "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD", "CLICKHOUSE_DATABASE": "default" } } } }

Frequently Asked Questions

Is Clickhouse_mcp_server safe to use?

Clickhouse_mcp_server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under Apache-2.0.

How do I install Clickhouse_mcp_server?

Clickhouse_mcp_server supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.

What AI clients work with Clickhouse_mcp_server?

Clickhouse_mcp_server is compatible with claude-desktop, cursor, claude-code. It uses stdio and http transport.

Is Clickhouse_mcp_server actively maintained?

Clickhouse_mcp_server is not actively maintained — last commit was 447 days ago. It has 8 GitHub stars.

ClickHouse MCP Server

A Model Context Protocal (MCP) server implement for ClickHouse.

Configuration

Set the following environment variables:

CLICKHOUSE_HOST=localhost    
CLICKHOUSE_PORT=8123         
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=CHANGE_TO_YOUR_PASSWORD
CLICKHOUSE_DATABASE=default

Or via command-line args:

--host the database host
--port the database port
--user the database username
--password the database password
--database the database name

Usage

Fake some data in clickhouse

Check the SQL in dev_contribute.md for details.

Post your question to AI assistant in Cline

What is the sales volume in each region? Which product is the best - selling?

CLINE

Configure the MCP server in VSCode, Cline extension, or other MCP client.: Example:

{
  "mcpServers": {
    "clickhouse": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/clickhouse_mcp_server",
        "run",
        "-m",
        "clickhouse_mcp_server.server"
      ],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_PORT": "8123",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": "CHANGE_TO_YOUR_PASSWORD",
        "CLICKHOUSE_DATABASE": "default"
      }
    }
    
  }
}

License

APACHE - See LICENSE file for details.

Contribute

See dev_contribute.md for details.

Prerequisites

Python with uv package manager
ClickHouse installation
MCP server dependencies

Acknowledgement

This library's implementation was inspired by the following three repositories and incorporates their code, respect for the open-source spirit!

Thanks!