Skip to main content
Glama
enesjakozh

ClickHouse MCP Server

by ThomAub
GitHub
Python
MIT License
1
  • Linux
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

ClickHouse MCP 服务器

该项目为 ClickHouse 实现了模型上下文协议 (MCP) 服务器，允许 ClickHouse 数据库与大型语言模型 (LLM) 和其他 AI 应用程序无缝集成。

特征

  • 将 ClickHouse 数据库和表列为资源
  • 检索表架构
  • 在 ClickHouse 数据库上执行 SELECT 查询
  • 使用 MCP 协议进行安全高效的通信

要求

  • Python 3.10+
  • ClickHouse 服务器

安装

  1. 克隆存储库：
    git clone https://github.com/ThomAub/clickhouse_mcp_server.git cd clickhouse_mcp_server
  2. 安装所需的软件包：
    uv sync --all-extras
  3. 在环境变量中设置您的 ClickHouse 连接详细信息或更新server.py中的get_clickhouse_client函数。

用法

运行服务器：

python clickhouse_mcp_server/server.py

服务器将启动并监听 MCP 请求。

测试

使用 pytest 运行测试：

pytest tests/

贡献

欢迎贡献代码！欢迎提交 Pull 请求。

执照

该项目已获得 MIT 许可。

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

模型上下文协议服务器，使大型语言模型能够与 ClickHouse 数据库无缝交互，支持资源列表、模式检索和查询执行。

  1. 特征
    1. 要求
      1. 安装
        1. 用法
          1. 测试
            1. 贡献
              1. 执照

                Related Resources

                Related MCP Servers

                • ClickUp MCP Integration

                  Leanware-io
                  -
                  security
                  A
                  license
                  -
                  quality
                  A Model Context Protocol server that enables Large Language Models to interact with ClickUp workspace tasks and data, allowing creation and retrieval of tasks through natural language.
                  Last updated -
                  762
                  3
                  TypeScript
                  MIT License
                  • Apple

                • ClickHouse MCP Server

                  dubin555
                  A
                  security
                  A
                  license
                  A
                  quality
                  A 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 updated -
                  1
                  8
                  Python
                  Apache 2.0

                • MCP TapData Serverofficial

                  tapdata
                  -
                  security
                  F
                  license
                  -
                  quality
                  A Model Context Protocol server that enables Large Language Models to access and interact with database connections, including viewing schemas and performing CRUD operations on connected databases.
                  Last updated -
                  • Apple

                • Couchbase MCP Server for LLMs

                  Aniket310101
                  -
                  security
                  F
                  license
                  -
                  quality
                  A Model Context Protocol server that enables large language models to interact directly with Couchbase databases through natural language, supporting operations like querying buckets, performing CRUD operations, and executing N1QL queries.
                  Last updated -
                  7
                  7
                  TypeScript
                  • Apple

                View all related MCP servers

                Appeared in Searches

                New MCP Servers

                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/ThomAub/clickhouse_mcp_server'

                If you have feedback or need assistance with the MCP directory API, please join our Discord server