Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| All Schemas in Hologres database | Hologres is a PostgreSQL-compatible OLAP product. List all schemas in Hologres database |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| 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. |