广告合作
MCP.so
登录

ClickHouse MCP Server

@dubin555

代码仓库

基本信息

分类

数据库

许可证

Apache-2.0

传输方式

stdio

作者

dubin555

关于 ClickHouse MCP Server

暂无概览

ClickHouse MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

ClickHouse MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is ClickHouse MCP Server?

A Model Context Protocol (MCP) server implementation for ClickHouse. It provides AI assistants with a secure and structured way to explore and analyze databases, allowing them to list tables, read data, and execute SQL queries through a controlled interface.

How to use ClickHouse MCP Server?

Configure via environment variables (CLICKHOUSE_HOST, CLICKHOUSE_PORT, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, CLICKHOUSE_DATABASE) or equivalent command-line arguments. Add the server to an MCP client (e.g., Cline extension in VS Code) using uv with the path to the server directory.

Key features of ClickHouse MCP Server?

  • List tables and read data from ClickHouse.
  • Execute SQL queries through a controlled interface.
  • Secure database access with user/password authentication.
  • Configurable via environment variables or command-line args.
  • Uses ClickHouse HTTP API on port 8123.

Use cases of ClickHouse MCP Server?

  • AI assistants answering business questions by querying ClickHouse.
  • Natural language exploration of database schemas and data.
  • Automated data analysis and reporting via conversational AI.
  • Safe read-only (or controlled write) database access for LLMs.

常见问题

1

What are the prerequisites?

Python with the `uv` package manager, a running ClickHouse instance, and MCP server dependencies.

2

How do I configure the connection to ClickHouse?

Set the environment variables `CLICKHOUSE_HOST`, `CLICKHOUSE_PORT`, `CLICKHOUSE_USER`, `CLICKHOUSE_PASSWORD`, and `CLICKHOUSE_DATABASE`, or pass them as command-line arguments (`--host`, `--port`, etc.).

3

How do I integrate this server with an AI assistant?

Add the server configuration to your MCP client (e.g., the Cline extension in VS Code) using the provided JSON example with the `uv` command.

4

What transport protocol does the server use to connect to ClickHouse?

It connects to ClickHouse via HTTP on the default port 8123.

5

Is authentication supported?

Yes, the server supports ClickHouse user/password authentication via the `CLICKHOUSE_USER` and `CLICKHOUSE_PASSWORD` settings.

评论

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

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1
广告合作