aliyun/alibabacloud-hologres-mcp-server
If you are the rightful owner of alibabacloud-hologres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Hologres MCP Server acts as a bridge between AI Agents and Hologres databases, facilitating metadata retrieval and SQL execution.
Tools
Functions exposed to the LLM to take actions
execute_hg_select_sql
Execute SELECT SQL to query data from Hologres database.
execute_hg_select_sql_with_serverless
Use Serverless Computing resources to execute SELECT SQL to query data in Hologres database. When the error like "Total memory used by all existing queries exceeded memory limitation" occurs during execute_hg_select_sql execution, you can re-execute the SQL with the tool execute_hg_select_sql_with_serverless.
execute_hg_dml_sql
Execute (INSERT, UPDATE, DELETE) SQL to insert, update, and delete data in Hologres databse.
execute_hg_ddl_sql
Execute (CREATE, ALTER, DROP) SQL statements to CREATE, ALTER, or DROP tables, views, procedures, GUCs etc. in Hologres databse.
gather_hg_table_statistics
Execute the ANALYZE TABLE command to have Hologres collect table statistics, enabling QO to generate better query plans
get_hg_query_plan
Get query plan for a SQL query in Hologres database
get_hg_execution_plan
Get actual execution plan with runtime statistics for a SQL query in Hologres database
call_hg_procedure
Call a stored procedure in Hologres database.
create_hg_maxcompute_foreign_table
Create a MaxCompute foreign table in Hologres database to accelerate queries on MaxCompute data.
list_hg_schemas
List all schemas in the current Hologres database, excluding system schemas.
list_hg_tables_in_a_schema
List all tables in a specific schema in the current Hologres database, including their types (table, view, foreign table, partitioned table).
show_hg_table_ddl
Show DDL script for a table, view, or foreign table in Hologres database.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client
All Schemas in Hologres database
URI: hologres:///schemas
MIME: text/plain
Hologres is a PostgreSQL-compatible OLAP product. List all schemas in Hologres database
