execute_hg_dml_sql

MCP tool from Alibabacloud Hologres MCP Server by aliyun

Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database

How to use it

execute_hg_dml_sql is exposed by the Alibabacloud Hologres MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the execute_hg_dml_sql tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Alibabacloud Hologres MCP Server

$uvx hologres-mcp-server --transport streamable-http --host 0.0.0.0 --port 8000

FULL ALIBABACLOUD HOLOGRES MCP SERVER LISTING

Other tools in Alibabacloud Hologres MCP Server (38)

analyze_hg_query_by_id

Analyze a specific query's performance profile by its queryid from hgquerylog. Returns detailed metrics including duration, memory, CPU time, read/write stats.

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_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_guc_config

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

get_hg_lock_diagnostics

Diagnose lock contention by showing blocking and waiting queries.

get_hg_query_plan

Get query plan in Hologres database

get_hg_slow_queries

Get slow queries from hgquerylog ordered by duration.

get_hg_table_info_trend

Get table storage trend from hgtableinfo, showing daily storage size, file count, and row count changes.

get_hg_table_properties

Get table properties including distributionkey, clusteringkey, segmentkey, bitmapcolumns, binlog settings, etc.

get_hg_table_shard_info

Get table's Table Group and shard count info for diagnosing data skew.

get_hg_table_storage_size

Get storage size details of a table, including total, data, index, and metadata breakdown.

get_hg_warehouse_status

Get detailed running status and scaling progress of a computing group.

list_hg_active_queries

List currently active queries and connections from pgstatactivity.

list_hg_data_masking_rules

List all data masking rules configured via hganon extension (column-level and user-level).

list_hg_dynamic_tables

List all Dynamic Tables with their status, freshness settings, and last refresh info.

list_hg_external_databases

List all External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+.

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.

manage_hg_classifier

Create or drop a classifier for a Query Queue. Requires V3.0+.

manage_hg_query_queue

Create, drop, or clear a Query Queue. Requires V3.0+ and superuser privileges.

manage_hg_warehouse

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

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.

query_hg_external_files

Query files directly from OSS using EXTERNALFILES function without creating foreign tables. Requires V4.1+.

rebalance_hg_warehouse

Trigger shard rebalancing for a computing group to eliminate data skew.

restore_hg_table_from_recyclebin

Restore a dropped table from the Hologres recycle bin.

set_hg_query_queue_property

Set or remove properties on a Query Queue or classifier. Requires V3.0+.

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.