mcp-clickhouseofficial
A
licenseA
qualityB
maintenanceClickHouse database integration with schema inspection and query capabilities
Last updated
3
833
Apache 2.0
clickhouse
by donald-ada
Provides tools for querying and managing ClickHouse databases, including listing databases, tables, describing schemas, executing SELECT queries, and DDL/DML operations.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@clickhouseList all databases on the ClickHouse server"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
ClickHouse MCP Server
一个用于 ClickHouse 的 Model Context Protocol (MCP) 服务器，让 Claude 等 AI 助手能够直接查询和管理 ClickHouse 数据库。
功能
提供 5 个工具：
工具 | 描述 |
| 列出所有数据库 |
| 列出指定数据库的所有表 |
| 查看表的列信息和建表语句 |
| 执行 SELECT 查询，返回 JSON 结果 |
| 执行 DDL / DML 语句（CREATE、ALTER、DROP、INSERT 等） |
Related MCP server: ClickHouse MCP Server
快速开始
安装依赖
npm install配置环境变量
复制 .env.example 并填写你的 ClickHouse 连接信息：
cp .env.example .envCLICKHOUSE_HOST=http://your-clickhouse-host:8123
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=your_password
CLICKHOUSE_DATABASE=default构建
npm run build在 Claude Desktop 中使用
编辑 ~/Library/Application Support/Claude/claude_desktop_config.json（macOS）：
{
"mcpServers": {
"clickhouse": {
"command": "node",
"args": ["/path/to/clickhouse/dist/index.js"],
"env": {
"CLICKHOUSE_HOST": "http://your-clickhouse-host:8123",
"CLICKHOUSE_USER": "default",
"CLICKHOUSE_PASSWORD": "your_password",
"CLICKHOUSE_DATABASE": "default"
}
}
}
}在 Claude Code 中使用
claude mcp add clickhouse node /path/to/clickhouse/dist/index.js \
-e CLICKHOUSE_HOST=http://your-clickhouse-host:8123 \
-e CLICKHOUSE_USER=default \
-e CLICKHOUSE_PASSWORD=your_password \
-e CLICKHOUSE_DATABASE=default开发
# 直接运行（无需构建）
npm run dev技术栈
License
MIT
This server cannot be installed
Maintenance
–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants to securely interact with ClickHouse databases, supporting table exploration and SQL query execution through a controlled interface.Last updated18Apache 2.0
- Alicense-qualityCmaintenanceEnables interaction with ClickHouse databases via MCP, providing tools to list databases and tables and execute safe SELECT, SHOW, and DESCRIBE queries.Last updated95MIT
- AlicenseAqualityAmaintenanceEnables querying ClickHouse databases using natural language with AI models, supporting multiple providers and access restrictions via per-call allow-lists.Last updated32MIT
Related MCP Connectors
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
Generate realistic, FK-consistent synthetic test data for your databases from your AI assistant.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/donald-ada/clickhouse'
If you have feedback or need assistance with the MCP directory API, please join our Discord server