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 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| run_query_safely | Safe query execution with size detection, pagination, and timeout support.
Args:
query: SQL query to execute
row_threshold: Maximum rows before requiring confirmation
proceed: Whether to proceed with large result set
mode: Execution mode ('page' or 'stream')
page_limit: Rows per page when paginating
include_columns: Include column names in response
precount: Count total rows for large results (expensive)
timeout: Query timeout in seconds (default from env) |
| execute_query_paginated | Execute query with pagination support and result size limits. |
| execute_query_stream | Stream query results with batching and size limits. |
| get_table_structure | Get table structure with caching support. |
| get_table_projections | List projections for a table. |
| get_schema_views | List views in schema with caching. |
| get_schema_tables | List tables in schema with caching. |
| get_database_schemas | List database schemas with caching. |
| profile_query | Profile query execution with improved error handling. |
| database_status | Get database status with improved error handling and formatting. |
| analyze_system_performance | Analyze system performance with improved efficiency. |
| generate_health_dashboard | Generate consolidated health dashboard with controlled output. Args: ctx: The context object. output_format: The format of the dashboard (default: compact, detailed, json). Returns: A dictionary containing the health dashboard. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| vertica_database_health_dashboard | Compact health dashboard. |
| vertica_database_system_monitor | System performance monitor. |
| vertica_compact_health_report | Token-efficient health report. |
| sql_query_safety_guard | SQL safety guard. |
| vertica_query_performance_analyzer | Vertica Performance Analyzer - Deep-dive query performance analysis with actionable optimization recommendations. Analyzes the given query execution plans, identifies bottlenecks, and provides concrete DDL suggestions for optimal Vertica projections, join strategies, and ROS container health. |
| vertica_sql_assistant | Vertica SQL Assistant - Expert SQL query generation with Vertica-specific optimizations. Generates efficient, Vertica-optimized SQL queries following a structured approach: analyze → research → generate → execute → fix → deliver |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |