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

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

常见问题

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

Are there any built-in prompts?

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

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

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

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one