Package Exports

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@mseep/hologres_mcp_server) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

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_select_sql: Execute a SELECT SQL query on the Hologres server
execute_dml_sql: Execute a DML (INSERT, UPDATE, DELETE) SQL query on the Hologres server
execute_ddl_sql: Execute a DDL (CREATE, ALTER, DROP) SQL query on the Hologres server
gather_table_statistics: 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}/partitions: List all partitions of a partitioned table
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/ - Get recent query log history with specified number of rows.
- query_log/user// - Get query log history for a specific user with row limits.
- query_log/application// - Get query log history for a specific application with row limits.
- query_log/failed/<interval>/ - Get failed query log history with interval and specified number of rows.

Prompts

None at this time