Alibabacloud Hologres MCP Server

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

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).

analyze_hg_query_by_id

Analyze a specific query's performance profile by its query_id from hg_query_log.

get_hg_slow_queries

Get slow queries from hg_query_log ordered by duration.

get_hg_dynamic_table_refresh_history

Get refresh history for a specific Dynamic Table, including duration, status, and latency.

restore_hg_table_from_recyclebin

Restore a dropped table from the Hologres recycle bin.

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.

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.

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.

manage_hg_classifier

Create or drop a classifier for a Query Queue.

set_hg_query_queue_property

Set or remove properties on a Query Queue or classifier.

manage_hg_warehouse

Manage a computing group: suspend, resume, restart, rename, or resize.

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.

query_hg_external_files

Query files directly from OSS using EXTERNAL_FILES function without creating foreign tables.

get_hg_guc_config

Get the current value of a GUC (Grand Unified Configuration) parameter.