aliyun/alibabacloud-hologres-mcp-server

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
MCP Integration
Add the following configuration to the MCP client configuration file:
Mode 2: Using PIP Mode
Installation
Install MCP Server using the following package:
MCP Integration
Add the following configuration to the MCP client configuration file:
Use uv mode
Use uvx mode
Mode 3: Using Streamable HTTP Transport
The server supports Streamable HTTP transport for remote deployment scenarios where STDIO is not available.
Start the server
Before starting the server, set the Hologres connection environment variables:
Then start the server:
The MCP endpoint will be available at http:// : /mcp.
CLI Options
| Option | Default | Description |
|--------|---------|-------------|
| --transport | stdio | Transport type: stdio, streamable-http, or sse |
| --host | 127.0.0.1 | Host to bind to (HTTP transports only) |
| --port | 8000 | Port to listen on (HTTP transports only) |
MCP Integration
Add the following configuration to the MCP client configuration file:
Using with Claude Code
Components
Tools
* execute_hg_select_sql: Execute a SELECT SQL query in Hologres database
* execute_hg_select_sql_with_serverless: Execute a SELECT SQL query in Hologres database with serverless computing
* execute_hg_dml_sql: Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database
* execute_hg_ddl_sql: Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database
* gather_hg_table_statistics: Collect table statistics in Hologres database
- Parameters: schema_name (string), table (string)
* get_hg_query_plan: Get query plan in Hologres database
* get_hg_execution_plan: Get execution plan in Hologres database
* call_hg_procedure: Invoke a procedure in Hologres database
* create_hg_maxcompute_foreign_table: Create MaxCompute foreign tables in Hologres database.
Since some Agents do not support resources and resource templates, the following tools are provided to obtain the metadata of schemas, tables, views, and external tables.
* list_hg_schemas: Lists all schemas in the current Hologres database, excluding system schemas.
* list_hg_tables_in_a_schema: Lists all tables in a specific schema, including their types (table, view, external table, partitioned table).
- Parameters: schema_name (string)
* show_hg_table_ddl: Show the DDL script of a table, view, or external table in the Hologres database.
- Parameters: schema_name (string), table (string)
* query_and_plotly_chart: Execute a SELECT SQL query and generate a chart (bar, line, scatter, pie, histogram, area). Returns query results and a base64-encoded PNG image.
- Parameters: query (string), chart_type (string, default "bar"), x_column (string), y_column (string), title (string)
* analyze_hg_query_by_id: Analyze a specific query's performance profile by its query_id from hg_query_log. Returns detailed metrics including duration, memory, CPU time, read/write stats.
- Parameters: query_id (string)
* get_hg_slow_queries: Get slow queries from hg_query_log ordered by duration.
- Parameters: min_duration_ms (int, default 1000), limit (int, default 20)
* list_hg_dynamic_tables: List all Dynamic Tables with their status, freshness settings, and last refresh info.
- Parameters: schema_name (string, optional)
* get_hg_dynamic_table_refresh_history: Get refresh history for a specific Dynamic Table, including duration, status, and latency.
- Parameters: schema_name (string), table_name (string), limit (int, default 10)
* list_hg_recyclebin: List all tables in the Hologres recycle bin (dropped tables that can be restored).