Hologres MCP Server

@spyfree

代码仓库

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

spyfree

关于 Hologres MCP Server

暂无概览

#hologres #mcp-server #ai-integration

Hologres MCP Server 配置

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

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

Hologres MCP Server 工具

Execute queries in Hologres

Collect table statistics

Get query plan

Get execution plan

概览

What is Hologres MCP Server?

Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases, enabling seamless communication for retrieving database metadata and executing SQL operations.

How to use Hologres MCP Server?

Install via local repository clone or pip install hologres-mcp-server. Configure required environment variables (HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, HOLOGRES_DATABASE). Run the server in SSE mode (default) or STDIO mode using the --transport flag. Add the server configuration to your MCP client (e.g., Cherry Studio) with the appropriate command and environment variables.

Key features of Hologres MCP Server

Dual transport mode support (STDIO and SSE)
Database metadata access (schemas, tables)
SQL execution with result analysis
Table statistics collection and viewing
Query plan and execution plan retrieval

Use cases of Hologres MCP Server

AI agents retrieving Hologres schema and table information
Executing SQL queries interactively through an agent
Collecting table statistics for performance tuning
Obtaining query or execution plans for optimization
Monitoring current running queries and query logs

常见问题

What is the default transport mode?

The server runs in SSE (Server-Sent Events) mode by default. You can switch to STDIO mode using the `--transport stdio` argument.

What environment variables are required?

`HOLOGRES_USER`, `HOLOGRES_PASSWORD`, and `HOLOGRES_DATABASE` are required. `SERVER_HOST` and `SERVER_PORT` are only needed for SSE mode.

What system resources are available for monitoring?

System resource templates expose `missing_stats_tables`, `stat_activity`, `query_log/latest/<row_limits>`, and query logs filtered by user or application.

Can it be integrated with Cherry Studio?

Yes. For SSE mode, use the server’s host and port (e.g., `http://localhost:8001`). For STDIO mode, configure the command and arguments as shown in the README.

What Python version is required?

Python 3.10 or higher is required, along with the `uv` package manager for development.

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

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K