Hologres MCP Server

@MCP-Mirror

About Hologres MCP Server

Mirror of

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "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": ""
      }
    }
  }
}

Tools

Execute queries in Hologres

Collect table statistics

Get query plan

Get execution plan

Overview

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.

Are there any built-in prompts?

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

Frequently asked questions

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