広告掲載
MCP.so
ログイン

Hologres MCP Server

@MCP-Mirror

リポジトリ

基本情報

カテゴリ

その他

ライセンス

Apache-2.0 license

トランスポート

stdio

作者

MCP-Mirror

Hologres MCP Server について

Mirror of

#hologres#mcp-server#ai-integration

Hologres MCP Server の設定

以下の設定を使って、このサーバーを 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": ""
      }
    }
  }
}

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 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

よくある質問

1

What tools does Hologres MCP Server provide?

It provides `execute_sql`, `analyze_table`, `get_query_plan`, and `get_execution_plan`.

2

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.

3

What runtime dependencies are required?

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

4

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`.

5

Are there any built-in prompts?

No, the README does not list any prompts for this server.

コメント

「その他」の他のコンテンツ

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.

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

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
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

広告掲載