Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| VERTICA_SSL | No | Whether to use SSL for the database connection. | false |
| VERTICA_HOST | Yes | The hostname or IP address of the Vertica database server. | |
| VERTICA_PORT | Yes | The port number the Vertica database server is listening on. | 5433 |
| VERTICA_USER | Yes | The username for database authentication. | |
| VERTICA_DATABASE | Yes | The name of the database to connect to. | |
| VERTICA_PASSWORD | Yes | The password for database authentication. | |
| VERTICA_CACHE_TTL | No | Cache Time-To-Live in seconds. | 300 |
| VERTICA_LAZY_INIT | No | If set to 1, delays database connection until the first use. | 1 |
| VERTICA_RATE_LIMIT | No | Maximum requests per minute. | 60 |
| ALLOW_DDL_OPERATION | No | Global permission to allow DDL operations (e.g., CREATE, DROP). | false |
| VERTICA_MAX_RETRIES | No | Maximum number of retry attempts for failed queries. | 3 |
| VERTICA_RETRY_DELAY | No | Base delay for retries in seconds. | 0.1 |
| VERTICA_MAX_RESULT_MB | No | Maximum result size in Megabytes. | 100 |
| VERTICA_QUERY_TIMEOUT | No | Query timeout in seconds. | 600 |
| ALLOW_DELETE_OPERATION | No | Global permission to allow DELETE operations. | false |
| ALLOW_INSERT_OPERATION | No | Global permission to allow INSERT operations. | false |
| ALLOW_UPDATE_OPERATION | No | Global permission to allow UPDATE operations. | false |
| SCHEMA_DDL_PERMISSIONS | No | Schema-specific DDL permissions (e.g., staging:false,production:false). | |
| VERTICA_CONNECTION_LIMIT | No | Maximum number of connections in the connection pool. | 10 |
| SCHEMA_DELETE_PERMISSIONS | No | Schema-specific delete permissions (e.g., staging:false,production:false). | |
| SCHEMA_INSERT_PERMISSIONS | No | Schema-specific insert permissions (e.g., staging:true,production:false). | |
| SCHEMA_UPDATE_PERMISSIONS | No | Schema-specific update permissions (e.g., staging:true,production:false). | |
| VERTICA_HEALTH_CHECK_INTERVAL | No | Interval between health checks in seconds. | 60 |
| VERTICA_SSL_REJECT_UNAUTHORIZED | No | Whether to reject unauthorized SSL certificates. | true |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |