Hologres MCP Server

Created By

MCP-Mirror10 months ago

Mirror of

Content

Hologres MCP Server

Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases. It enables seamless communication between AI Agents and Hologres, helping AI Agents retrieve Hologres database metadata and execute SQL operations.

Configuration

Mode 1: Using Local File

Download

Download from Github

git clone https://github.com/aliyun/alibabacloud-hologres-mcp-server.git

MCP Integration

Add the following configuration to the MCP client configuration file:

"mcpServers": {
  "hologres-mcp-server": {
    "command": "uv",
    "args": [
      "--directory",
      "/path/to/alibabacloud-hologres-mcp-server",
      "run",
      "hologres-mcp-server"
    ],
    "env": {
      "HOLOGRES_HOST": "host",
      "HOLOGRES_PORT": "port",
      "HOLOGRES_USER": "access_id",
      "HOLOGRES_PASSWORD": "access_key",
      "HOLOGRES_DATABASE": "database"
    }
  }
}

Mode 2: Using PIP Mode

Installation

Install MCP Server using the following package:

pip install hologres-mcp-server

MCP Integration

Add the following configuration to the MCP client configuration file:

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

Components

Tools

execute_sql: Execute queries in Hologres
analyze_table: Collect table statistics
get_query_plan: Get query plan
get_execution_plan: Get execution plan

Resources

Built-in Resources

hologres:///schemas: Get all schemas in the database

Resource Templates

hologres:///{schema}/tables: List all tables in a schema
hologres:///{schema}/{table}/ddl: Get table DDL
hologres:///{schema}/{table}/statistic: Show collected table statistics
system:///query_log/latest/{row_limits}: Get recent query logs
system:///query_log/user/{user_name}: Get specific user's query logs
system:///query_log/application/{application_name}: Get specific application's query logs
system:///{system_path}: System paths include:
- missing_stats_tables - Shows the tables that are missing statistics.
- stat_activity - Shows the information of current running queries.