Hologres MCP Server

Name: Hologres MCP Server
Author: spyfree

@spyfree

リポジトリ

Hologres MCP Server について

概要はまだありません

#hologres #mcp-server #ai-integration

基本情報

カテゴリ

その他

ライセンス

Apache-2.0

ランタイム

python

トランスポート

stdio

公開者

spyfree

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

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

FAQ from Hologres MCP Server

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.