Hologres MCP Server

Name: Hologres MCP Server
Author: MCP-Mirror

@MCP-Mirror

リポジトリ

Hologres MCP Server について

Mirror of

#hologres #mcp-server #ai-integration

基本情報

カテゴリ

その他

ライセンス

Apache-2.0 license

ランタイム

python

トランスポート

stdio

公開者

MCP-Mirror

設定

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

{
  "mcpServers": {
    "hologres-mcp-server": {
      "command": "uv",
      "args": [
        "run",
        "--with",
        "hologres-mcp-server",
        "hologres-mcp-server"
      ],
      "env": {
        "HOLOGRES_HOST": "",
        "HOLOGRES_PORT": "",
        "HOLOGRES_USER": "",
        "HOLOGRES_PASSWORD": "",
        "HOLOGRES_DATABASE": ""
      }
    }
  }
}

ツール

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. It enables AI Agents to retrieve Hologres database metadata and execute SQL operations.

How to use Hologres MCP Server?

Install using pip install hologres-mcp-server or clone from GitHub. Add the MCP server configuration to your MCP client config file, setting the environment variables HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE. Launch using the provided uv commands for either local or pip mode.

Key features of Hologres MCP Server

Execute SQL queries in Hologres databases
Collect table statistics via analyze_table
Retrieve query plans and execution plans
Access database schemas, tables, and DDL
View recent and user/application-specific query logs
Inspect system status (missing statistics, current queries)

Use cases of Hologres MCP Server

AI agents autonomously querying Hologres for analytics
Automated database metadata retrieval for schema documentation
Performance debugging with query plan analysis
Monitoring query logs per user or application
Statistic health checks via missing_stats_tables

FAQ from Hologres MCP Server

What tools does Hologres MCP Server provide?

It provides execute_sql, analyze_table, get_query_plan, and get_execution_plan.

How do I configure the server for my database?

Set the environment variables HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE in the MCP client configuration.

What runtime dependencies are required?

Python with uv installed is required. The server can be installed via pip or run from a local clone.

What type of data can I access via resources?

You can access schemas, table lists, DDL, table statistics, query logs (by row limit, user, or application), and system paths like missing_stats_tables and stat_activity.