Connect to a Hologres instance, get table metadata, query and analyze data.
Connect to a Hologres instance, get table metadata, query and analyze data.
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.
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| 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 | guc_name (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. |
| 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). |
| show_hg_table_ddl | Show the DDL script of a table, view, or external table in the Hologres database. |
| 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. |
| 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 |
| get_hg_slow_queries | Get slow queries from hg_query_log ordered by duration. |
| list_hg_dynamic_tables | List all Dynamic Tables with their status, freshness settings, and last refresh info. |
| get_hg_dynamic_table_refresh_history | Get refresh history for a specific Dynamic Table, including duration, status, and latency. |
| list_hg_recyclebin | List all tables in the Hologres recycle bin (dropped tables that can be restored). |
| restore_hg_table_from_recyclebin | Restore a dropped table from the Hologres recycle bin. |
| list_hg_warehouses | List all computing groups (warehouses) with their CPU, memory, cluster count, and status. |
| switch_hg_warehouse | Switch the current session's computing resource to a specified warehouse. |
| get_hg_table_storage_size | Get storage size details of a table, including total, data, index, and metadata breakdown. |
| cancel_hg_query | Cancel or terminate a running query by its process ID. |
| list_hg_active_queries | List currently active queries and connections from pg_stat_activity. |
| list_hg_query_queues | List all Query Queues and their classifiers (concurrency limits, routing rules). Requires V3.0+. |
| get_hg_table_properties | Get table properties including distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc. |
| get_hg_table_shard_info | Get table's Table Group and shard count info for diagnosing data skew. |
| list_hg_external_databases | List all External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+. |
| get_hg_lock_diagnostics | Diagnose lock contention by showing blocking and waiting queries. |
| get_hg_table_info_trend | Get table storage trend from hg_table_info, showing daily storage size, file count, and row count changes. |
| manage_hg_query_queue | Create, drop, or clear a Query Queue. Requires V3.0+ and superuser privileges. |
| manage_hg_classifier | Create or drop a classifier for a Query Queue. Requires V3.0+. |
| set_hg_query_queue_property | Set or remove properties on a Query Queue or classifier. Requires V3.0+. |
| manage_hg_warehouse | Manage a computing group: suspend, resume, restart, rename, or resize. Requires superuser. |
| get_hg_warehouse_status | Get detailed running status and scaling progress of a computing group. |
| rebalance_hg_warehouse | Trigger shard rebalancing for a computing group to eliminate data skew. |
| list_hg_data_masking_rules | List all data masking rules configured via hg_anon extension (column-level and user-level). |
| query_hg_external_files | Query files directly from OSS using EXTERNAL_FILES function without creating foreign tables. Requires V4.1+. |
| get_hg_guc_config | Get the current value of a GUC (Grand Unified Configuration) parameter. |
{
"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": "YOUR_HOLOGRES_PASSWORD",
"HOLOGRES_DATABASE": "database"
}
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
| Variable | Description | Required |
|---|---|---|
| HOLOGRES_HOST | Declared in the maintainer’s client configuration. | Check documentation |
| HOLOGRES_PORT | Declared in the maintainer’s client configuration. | Check documentation |
| HOLOGRES_USER | Declared in the maintainer’s client configuration. | Check documentation |
| HOLOGRES_PASSWORD | Declared in the maintainer’s client configuration. | Check documentation |
| HOLOGRES_DATABASE | Declared in the maintainer’s client configuration. | Check documentation |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.
Enables AI models to interact with PostgreSQL databases through a standardized protocol.
Official Redis server — search keys, inspect data structures and manage caches in natural language.
DeepADB — full-featured Android Debug Bridge MCP server. 204 tools across 45 modules for device inspection from UI to baseband.