广告合作
MCP.so
登录

Hologres MCP Server

@spyfree

代码仓库

基本信息

分类

其他

许可证

Apache-2.0 license

传输方式

stdio

作者

spyfree

关于 Hologres MCP Server

暂无概览

#hologres#mcp-server#ai-database-integration

Hologres MCP Server 配置

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

{
  "mcpServers": {
    "hologres-mcp-server": {
      "command": "python",
      "args": [
        "examples/test_server.py"
      ]
    }
  }
}

Hologres MCP Server 工具

4

Execute queries in Hologres

Collect table statistics

Get query plan

Get execution plan

概览

What is Hologres MCP Server?

Hologres MCP Server is a universal interface between AI Agents and Hologres databases. It enables seamless communication, letting AI Agents retrieve database metadata and execute SQL operations.

How to use Hologres MCP Server?

Install via pip (pip install hologres-mcp-server) or clone the repository. Configure environment variables for Hologres connection (HOLOGRES_HOST, PORT, USER, PASSWORD, DATABASE) and optionally SERVER_HOST/PORT for SSE and HTTP Stream modes. Run the server using hologres-mcp-server with --transport set to stdio, sse (default), or http-stream. Integration examples are provided for Python and Node.js.

Key features of Hologres MCP Server

  • Multiple transport modes: STDIO, SSE, and HTTP Stream
  • Retrieve Hologres database metadata (schemas, tables)
  • Execute SQL queries and analyze results
  • Collect and view table statistics
  • Get query plans and execution plans

Use cases of Hologres MCP Server

  • AI agents querying Hologres databases in real time
  • Retrieving schema and table DDL for database exploration
  • Analyzing table statistics to optimize query performance
  • Fetching query logs by user, application, or recent activity
  • Integrating with MCP clients like Cherry Studio

常见问题

1

What transport modes does Hologres MCP Server support?

STDIO (standard I/O), SSE (Server-Sent Events), and HTTP Stream (Streamable HTTP). The default is SSE.

2

What environment variables are required?

HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE are all required. SERVER_HOST and SERVER_PORT are only needed for SSE and HTTP Stream modes.

3

How can I install Hologres MCP Server?

You can use pip (`pip install hologres-mcp-server`) or clone the repository and run it with `uv`. Configuration is added to the MCP client’s `mcpServers` section.

4

Can Hologres MCP Server work with Cherry Studio?

Yes. Cherry Studio can connect in SSE mode (e.g., `http://localhost:8001`), HTTP Stream mode (`http://localhost:8001/mcp`), or STDIO mode with the appropriate command.

5

What are the runtime requirements?

Python 3.10 or higher and `uv` for package management.

评论

其他 分类下的更多 MCP 服务器

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

ICSS

chokcoco

不止于 CSS

20.7K
广告合作