Hologres

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

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

MCP Integration

Add the following configuration to the MCP client configuration file:

1"mcpServers": {
2  "hologres-mcp-server": {
3    "command": "uv",
4    "args": [
5      "--directory",
6      "/path/to/alibabacloud-hologres-mcp-server",
7      "run",
8      "hologres-mcp-server"
9    ],
10    "env": {
11      "HOLOGRES_HOST": "host",
12      "HOLOGRES_PORT": "port",
13      "HOLOGRES_USER": "access_id",
14      "HOLOGRES_PASSWORD": "access_key",
15      "HOLOGRES_DATABASE": "database"
16    }
17  }
18}

Mode 2: Using PIP Mode

Installation

Install MCP Server using the following package:

1pip install hologres-mcp-server

MCP Integration

Add the following configuration to the MCP client configuration file:

1  "mcpServers": {
2    "hologres-mcp-server": {
3      "command": "uv",
4      "args": [
5        "run",
6        "--with",
7        "hologres-mcp-server",
8        "hologres-mcp-server"
9      ],
10      "env": {
11        "HOLOGRES_HOST": "host",
12        "HOLOGRES_PORT": "port",
13        "HOLOGRES_USER": "access_id",
14        "HOLOGRES_PASSWORD": "access_key",
15        "HOLOGRES_DATABASE": "database"
16      }
17    }
18  }

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:///{+system_path}: System paths include:

  • missing_stats_tables - Shows the tables that are missing statistics.
  • stat_activity - Shows the information of current running queries.
  • query_log/latest/<row_limits> - Get recent query log history with specified number of rows.
  • query_log/user/<user_name>/<row_limits> - Get query log history for a specific user with row limits.
  • query_log/application/<application_name>/<row_limits> - Get query log history for a specific application with row limits.

Prompts

None at this time