Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| HOLOGRES_HOST | Yes | Hologres server host | |
| HOLOGRES_PORT | Yes | Hologres server port | |
| HOLOGRES_USER | Yes | Hologres access ID/username | |
| HOLOGRES_DATABASE | Yes | Hologres database name | |
| HOLOGRES_PASSWORD | Yes | Hologres access key/password |
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 | 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_select_sql | Execute SELECT SQL to query data from Hologres database. |
| execute_dml_sql | Execute (INSERT, UPDATE, DELETE) SQL to insert, update, and delete data in Hologres databse. |
| execute_ddl_sql | Execute (CREATE, ALTER, DROP) SQL statements to CREATE, ALTER, or DROP tables, views, procedures, GUCs etc. in Hologres databse. |
| gather_table_statistics | Execute the ANALYZE TABLE command to have Hologres collect table statistics, enabling QO to generate better query plans |
| get_query_plan | Get query plan for a SQL query |
| get_execution_plan | Get actual execution plan with runtime statistics for a SQL query |