{"slug":"aliyun/alibabacloud-hologres-mcp-server","name":"Hologres","description":"Connect to a Hologres instance, get table metadata, query and analyze data.","category":"database","tags":[],"official":true,"stars":33,"transport":"stdio","install":[{"cmd":"uvx mode","imports":[]}],"tools":[{"name":"execute_hg_select_sql","description":"Execute a SELECT SQL query in Hologres database"},{"name":"execute_hg_select_sql_with_serverless","description":"Execute a SELECT SQL query in Hologres database with serverless computing"},{"name":"execute_hg_dml_sql","description":"Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database"},{"name":"execute_hg_ddl_sql","description":"Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database"},{"name":"gather_hg_table_statistics","description":"Collect table statistics in Hologres database"},{"name":"get_hg_query_plan","description":"Get query plan in Hologres database"},{"name":"get_hg_execution_plan","description":"Get execution plan in Hologres database"},{"name":"call_hg_procedure","description":"Invoke a procedure in Hologres database"},{"name":"create_hg_maxcompute_foreign_table","description":"Create MaxCompute foreign tables in Hologres database"},{"name":"list_hg_schemas","description":"Lists all schemas in the current Hologres database, excluding system schemas"},{"name":"list_hg_tables_in_a_schema","description":"Lists all tables in a specific schema, including their types (table, view, external table, partitioned table)"},{"name":"show_hg_table_ddl","description":"Show the DDL script of a table, view, or external table in the Hologres database"},{"name":"query_and_plotly_chart","description":"Execute a SELECT SQL query and generate a chart (bar, line, scatter, pie, histogram, area). Returns query results and a base64-encoded PNG image"},{"name":"analyze_hg_query_by_id","description":"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 stats"},{"name":"get_hg_slow_queries","description":"Get slow queries from hg_query_log ordered by duration"},{"name":"list_hg_dynamic_tables","description":"List all Dynamic Tables with their status, freshness settings, and last refresh info"},{"name":"get_hg_dynamic_table_refresh_history","description":"Get refresh history for a specific Dynamic Table, including duration, status, and latency"},{"name":"list_hg_recyclebin","description":"List all tables in the Hologres recycle bin (dropped tables that can be restored)"},{"name":"restore_hg_table_from_recyclebin","description":"Restore a dropped table from the Hologres recycle bin"},{"name":"list_hg_warehouses","description":"List all computing groups (warehouses) with their CPU, memory, cluster count, and status"},{"name":"switch_hg_warehouse","description":"Switch the current session's computing resource to a specified warehouse"},{"name":"get_hg_table_storage_size","description":"Get storage size details of a table, including total, data, index, and metadata breakdown"},{"name":"cancel_hg_query","description":"Cancel or terminate a running query by its process ID"},{"name":"list_hg_active_queries","description":"List currently active queries and connections from pg_stat_activity"},{"name":"list_hg_query_queues","description":"List all Query Queues and their classifiers (concurrency limits, routing rules). Requires V3.0+"},{"name":"get_hg_table_properties","description":"Get table properties including distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc"},{"name":"get_hg_table_shard_info","description":"Get table's Table Group and shard count info for diagnosing data skew"},{"name":"list_hg_external_databases","description":"List all External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+"},{"name":"get_hg_lock_diagnostics","description":"Diagnose lock contention by showing blocking and waiting queries"},{"name":"get_hg_table_info_trend","description":"Get table storage trend from hg_table_info, showing daily storage size, file count, and row count changes"},{"name":"manage_hg_query_queue","description":"Create, drop, or clear a Query Queue. Requires V3.0+ and superuser privileges"},{"name":"manage_hg_classifier","description":"Create or drop a classifier for a Query Queue. Requires V3.0+"},{"name":"set_hg_query_queue_property","description":"Set or remove properties on a Query Queue or classifier. Requires V3.0+"},{"name":"manage_hg_warehouse","description":"Manage a computing group: suspend, resume, restart, rename, or resize. Requires superuser"},{"name":"get_hg_warehouse_status","description":"Get detailed running status and scaling progress of a computing group"},{"name":"rebalance_hg_warehouse","description":"Trigger shard rebalancing for a computing group to eliminate data skew"},{"name":"list_hg_data_masking_rules","description":"List all data masking rules configured via hg_anon extension (column-level and user-level)"},{"name":"query_hg_external_files","description":"Query files directly from OSS using EXTERNAL_FILES function without creating foreign tables. Requires V4.1+"},{"name":"get_hg_guc_config","description":"Get the current value of a GUC (Grand Unified Configuration) parameter"}],"env_vars":["HOLOGRES_HOST","HOLOGRES_PORT"],"auth_type":"none","github":"https://github.com/aliyun/alibabacloud-hologres-mcp-server","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}