Hologres MCP Server

The Hologres MCP Server acts as a universal interface, facilitating communication between AI Agents and Hologres databases. It enables AI Agents to seamlessly retrieve Hologres database metadata and execute SQL operations.

Configuration

Two modes are available for configuration:

Mode 1: Using Local File

Download the repository using git clone https://github.com/aliyun/alibabacloud-hologres-mcp-server.git. Integrate it into the MCP client by adding a configuration block, specifying the path to the cloned repository and setting environment variables for HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE.

Mode 2: Using PIP Mode

Install the server using pip install hologres-mcp-server. Integrate it into the MCP client by adding a configuration block, specifying the hologres-mcp-server and setting environment variables for HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE.

Components

Tools

• execute_sql: Executes SQL queries in Hologres.
• analyze_table: Collects table statistics.
• get_query_plan: Retrieves the query plan.
• get_execution_plan: Retrieves the execution plan.

Resources

• hologres:///schemas: Retrieves all schemas in the database.
• hologres:///{schema}/tables: Lists all tables in a schema.
• hologres:///{schema}/{table}/ddl: Retrieves table DDL.
• hologres:///{schema}/{table}/statistic: Shows collected table statistics.
• system:///{+system_path}: Accesses system paths like missing_stats_tables, stat_activity, and query_log.