广告合作
MCP.so
登录

Clickhouse MCP server

@burakdirin

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

burakdirin

关于 Clickhouse MCP server

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

#clickhouse#mcp-server#database-integration

Clickhouse MCP server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "clickhouse-mcp-server-burakdirin": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "clickhouse-mcp-server"
      ]
    }
  }
}

Clickhouse MCP server 工具

2

Connects to a specific Clickhouse database

Executes Clickhouse queries

概览

What is Clickhouse MCP server?

Clickhouse MCP server is an MCP server that connects to a Clickhouse database, allowing users to execute SQL queries through the Model Context Protocol. It is designed for developers and AI assistants that need to interact with Clickhouse databases.

How to use Clickhouse MCP server?

Install the package with uv pip install clickhouse-mcp-server or pip install clickhouse-mcp-server. Configure environment variables for Clickhouse connection, then configure the MCP client (e.g., Claude Desktop) with the server definition, specifying the command uvx clickhouse-mcp-server and your connection settings. Use the provided connect_database and execute_query tools to interact with the database.

Key features of Clickhouse MCP server

  • Connects to Clickhouse databases and executes queries.
  • Provides connect_database and execute_query tools.
  • Supports read-only mode via environment variable.
  • Configurable through environment variables for host, user, password, database.
  • Multiple queries can be sent separated by semicolons.

Use cases of Clickhouse MCP server

  • Query a Clickhouse database from an AI assistant.
  • Enable natural‑language database exploration via MCP.
  • Integrate Clickhouse into automated workflows with read‑only access.
  • Debug or inspect database schemas and data interactively.

常见问题

1

What tools does Clickhouse MCP server provide?

It provides `connect_database` to connect to a specific database and `execute_query` to run Clickhouse SQL queries, returning results in JSON format.

2

How do I configure Clickhouse MCP server for read‑only mode?

Set the `CLICKHOUSE_READONLY` environment variable to `true` or `1`. The default is false, allowing write queries.

3

What are the runtime requirements?

The server requires Python and the package can be installed via `uv` or `pip`. It runs as a stdio‑based MCP server, best debugged with the MCP Inspector.

4

How do I publish the server to PyPI?

Build with `uv build` and publish with `uv publish`, providing PyPI credentials via token or username/password.

5

Can I use Clickhouse MCP server with Claude Desktop?

Yes, configure it in the Claude Desktop config file (macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`, Windows: `%APPDATA%/Claude/claude_desktop_config.json`) with the published server configuration using `uvx`.

评论

数据库 分类下的更多 MCP 服务器

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

广告合作