SSyncDev

Hologres MCP Server

Connect to a Hologres instance, get table metadata, query and analyze data.

Local serverstdioPython

What is the Hologres MCP Server?

Connect to a Hologres instance, get table metadata, query and analyze data.

What it actually does

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.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
execute_hg_select_sqlExecute a SELECT SQL query in Hologres database
execute_hg_select_sql_with_serverlessExecute a SELECT SQL query in Hologres database with serverless computing
execute_hg_dml_sqlExecute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database
execute_hg_ddl_sqlExecute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database
gather_hg_table_statisticsCollect table statistics in Hologres database
Parametersguc_name (string)
get_hg_query_planGet query plan in Hologres database
get_hg_execution_planGet execution plan in Hologres database
call_hg_procedureInvoke a procedure in Hologres database
create_hg_maxcompute_foreign_tableCreate MaxCompute foreign tables in Hologres database.
list_hg_schemasLists all schemas in the current Hologres database, excluding system schemas.
list_hg_tables_in_a_schemaLists all tables in a specific schema, including their types (table, view, external table, partitioned table).
show_hg_table_ddlShow the DDL script of a table, view, or external table in the Hologres database.
query_and_plotly_chartExecute 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_idAnalyze 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_queriesGet slow queries from hg_query_log ordered by duration.
list_hg_dynamic_tablesList all Dynamic Tables with their status, freshness settings, and last refresh info.
get_hg_dynamic_table_refresh_historyGet refresh history for a specific Dynamic Table, including duration, status, and latency.
list_hg_recyclebinList all tables in the Hologres recycle bin (dropped tables that can be restored).
restore_hg_table_from_recyclebinRestore a dropped table from the Hologres recycle bin.
list_hg_warehousesList all computing groups (warehouses) with their CPU, memory, cluster count, and status.
switch_hg_warehouseSwitch the current session's computing resource to a specified warehouse.
get_hg_table_storage_sizeGet storage size details of a table, including total, data, index, and metadata breakdown.
cancel_hg_queryCancel or terminate a running query by its process ID.
list_hg_active_queriesList currently active queries and connections from pg_stat_activity.
list_hg_query_queuesList all Query Queues and their classifiers (concurrency limits, routing rules). Requires V3.0+.
get_hg_table_propertiesGet table properties including distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc.
get_hg_table_shard_infoGet table's Table Group and shard count info for diagnosing data skew.
list_hg_external_databasesList all External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+.
get_hg_lock_diagnosticsDiagnose lock contention by showing blocking and waiting queries.
get_hg_table_info_trendGet table storage trend from hg_table_info, showing daily storage size, file count, and row count changes.
manage_hg_query_queueCreate, drop, or clear a Query Queue. Requires V3.0+ and superuser privileges.
manage_hg_classifierCreate or drop a classifier for a Query Queue. Requires V3.0+.
set_hg_query_queue_propertySet or remove properties on a Query Queue or classifier. Requires V3.0+.
manage_hg_warehouseManage a computing group: suspend, resume, restart, rename, or resize. Requires superuser.
get_hg_warehouse_statusGet detailed running status and scaling progress of a computing group.
rebalance_hg_warehouseTrigger shard rebalancing for a computing group to eliminate data skew.
list_hg_data_masking_rulesList all data masking rules configured via hg_anon extension (column-level and user-level).
query_hg_external_filesQuery files directly from OSS using EXTERNAL_FILES function without creating foreign tables. Requires V4.1+.
get_hg_guc_configGet the current value of a GUC (Grand Unified Configuration) parameter.

How to install the Hologres MCP Server

{
  "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.

Configuration

VariableDescriptionRequired
HOLOGRES_HOSTDeclared in the maintainer’s client configuration.Check documentation
HOLOGRES_PORTDeclared in the maintainer’s client configuration.Check documentation
HOLOGRES_USERDeclared in the maintainer’s client configuration.Check documentation
HOLOGRES_PASSWORDDeclared in the maintainer’s client configuration.Check documentation
HOLOGRES_DATABASEDeclared in the maintainer’s client configuration.Check documentation

Example prompts to try

  • “Use Hologres to execute hg select sql.”
  • “Use Hologres to execute hg select sql with serverless.”
  • “Use Hologres to execute hg dml sql.”

Frequently asked questions

Connect to a Hologres instance, get table metadata, query and analyze data. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.