Alibabacloud Hologres MCP Server

🚀 Hologres MCP Server

The Hologres MCP Server serves as a universal interface between AI agents and the Hologres database. It enables AI agents to communicate seamlessly with Hologres, helping them obtain metadata from the Hologres database and execute SQL operations.

🚀 Quick Start

📦 Installation

Mode 1: Using Local Files

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

Installation

Install the 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"
      }
    }
  }

✨ Features

Tools

• execute_select_sql: Execute SELECT SQL queries on the Hologres server.
• execute_dml_sql: Execute DML (INSERT, UPDATE, DELETE) SQL queries on the Hologres server.
• execute_ddl_sql: Execute DDL (CREATE, ALTER, DROP) SQL queries on the Hologres server.
• gather_table_statistics: Collect table statistics.
• get_query_plan: Get the query plan.
• get_execution_plan: Get the execution plan.

Resources

Built - in Resources

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

Resource Templates

• hologres:///{schema}/tables: List all tables in the schema.
• hologres:///{schema}/{table}/partitions: List all partitions of the partitioned table.
• hologres:///{schema}/{table}/ddl: Get the DDL of the table.
• hologres:///{schema}/{table}/statistic: Show the collected table statistics.
• system:///{+system_path}: System paths include:
  • missing_stats_tables - Show tables missing statistics.
  • stat_activity - Show information about currently running queries.
  • query_log/latest/<row_limits> - Get the recent query log history for the specified number of rows.
  • query_log/user/<user_name>/<row_limits> - Get the query log history for a specific user with a row limit.
  • query_log/application/<application_name>/<row_limits> - Get the query log history for a specific application with a row limit.
  • query_log/failed/<interval>/<row_limits> - Get the failed query log history within the specified interval with a row limit.