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.
Hologres MCP Server is designed to provide a seamless interface for AI Agents to interact with Hologres databases. It allows AI Agents to retrieve metadata and execute SQL operations efficiently. The server can be configured in two modes: using a local file or through PIP installation. It supports various SQL operations, including SELECT, DML, and DDL queries, and offers tools for gathering table statistics and obtaining query plans. Additionally, it provides resources and templates to access metadata about schemas, tables, and views. The server is highly configurable, allowing users to set environment variables for connecting to Hologres databases. This flexibility makes it a powerful tool for integrating AI capabilities with Hologres databases, enabling advanced data processing and analysis.
Features
- Seamless integration with Hologres databases for AI Agents.
- Supports execution of various SQL operations including SELECT, DML, and DDL.
- Provides tools for gathering table statistics and obtaining query plans.
- Configurable through local file or PIP installation.
- Offers resources and templates for accessing database metadata.
Tools
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.
