get_hg_table_info_trend

MCP tool from Alibabacloud Hologres MCP Server by aliyun

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

How to use it

get_hg_table_info_trend 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 get_hg_table_info_trend 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_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_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_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.