# aliyun/alibabacloud-hologres-mcp-server

Source: https://glimind.com/server/awesome%2Faliyun%2Falibabacloud-hologres-mcp-server
Registry id: `awesome/aliyun/alibabacloud-hologres-mcp-server`
Status: unknown

## Tools (25)

- `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 stat
- `call_hg_procedure`: Invoke a procedure in Hologres database
- `cancel_hg_query`: Cancel or terminate a running query by its process ID.
- `create_hg_maxcompute_foreign_table`: Create MaxCompute foreign tables in Hologres database
- `execute_hg_ddl_sql`: Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database
- `execute_hg_dml_sql`: Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database
- `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
- `gather_hg_table_statistics`: Collect table statistics in Hologres database
- `get_hg_dynamic_table_refresh_history`: Get refresh history for a specific Dynamic Table, including duration, status, and latency.
- `get_hg_execution_plan`: Get execution plan in Hologres database
- `get_hg_query_plan`: Get query plan in Hologres database
- `get_hg_slow_queries`: Get slow queries from hg_query_log ordered by duration.
- `get_hg_table_storage_size`: Get storage size details of a table, including total, data, index, and metadata breakdown.
- `list_hg_active_queries`: List currently active queries and connections from pg_stat_activity.
- `list_hg_dynamic_tables`: List all Dynamic Tables with their status, freshness settings, and last refresh info.
- `list_hg_query_queues`: List all Query Queues and their classifiers (concurrency limits, routing rules). Requires V3.0+.
- `list_hg_recyclebin`: List all tables in the Hologres recycle bin (dropped tables that can be restored).
- `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).
- `list_hg_warehouses`: List all computing groups (warehouses) with their CPU, memory, cluster count, and status.
- `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.
- `restore_hg_table_from_recyclebin`: Restore a dropped table from the Hologres recycle bin.
- `show_hg_table_ddl`: Show the DDL script of a table, view, or external table in the Hologres database.
- `switch_hg_warehouse`: Switch the current session's computing resource to a specified warehouse.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.