Server Configuration
Describes the environment variables required to run the server.
Name | Required | Description | Default |
---|---|---|---|
VERTICA_SSL | No | Enable SSL/TLS support | false |
VERTICA_HOST | No | The Vertica database host | localhost |
VERTICA_PORT | No | The Vertica database port | 5433 |
VERTICA_USER | No | The Vertica database user | dbadmin |
VERTICA_DATABASE | No | The Vertica database name | VMart |
VERTICA_PASSWORD | No | The Vertica database password | |
ALLOW_DDL_OPERATION | No | Allow DDL operations | false |
ALLOW_DELETE_OPERATION | No | Allow DELETE operations | false |
ALLOW_INSERT_OPERATION | No | Allow INSERT operations | false |
ALLOW_UPDATE_OPERATION | No | Allow UPDATE operations | false |
SCHEMA_DDL_PERMISSIONS | No | Schema-specific DDL permissions (format: schema1:true,schema2:false) | |
VERTICA_CONNECTION_LIMIT | No | Connection pooling limit | 10 |
SCHEMA_DELETE_PERMISSIONS | No | Schema-specific DELETE permissions (format: schema1:true,schema2:false) | |
SCHEMA_INSERT_PERMISSIONS | No | Schema-specific INSERT permissions (format: schema1:true,schema2:false) | |
SCHEMA_UPDATE_PERMISSIONS | No | Schema-specific UPDATE permissions (format: schema1:true,schema2:false) | |
VERTICA_SSL_REJECT_UNAUTHORIZED | No | SSL reject unauthorized connections | true |
Schema
Prompts
Interactive templates invoked by user choice
Name | Description |
---|---|
No prompts |
Resources
Contextual data attached and managed by the client
Name | Description |
---|---|
No resources |
Tools
Functions exposed to the LLM to take actions
Name | Description |
---|---|
execute_query | Execute a SQL query and return the results. Args:
ctx: FastMCP context for progress reporting and logging
query: SQL query to execute
database: Optional database name to execute the query against
Returns:
Query results as a string |
stream_query | Execute a SQL query and return the results in batches as a single string. Args:
ctx: FastMCP context for progress reporting and logging
query: SQL query to execute
batch_size: Number of rows to fetch at once
Returns:
Query results as a concatenated string |
copy_data | Copy data into a Vertica table using COPY command. Args:
ctx: FastMCP context for progress reporting and logging
schema: vertica schema to execute the copy against
table: Target table name
data: List of rows to insert
Returns:
Status message indicating success or failure |
get_table_structure | Get the structure of a table including columns, data types, and constraints. Args:
ctx: FastMCP context for progress reporting and logging
table_name: Name of the table to inspect
schema: Schema name (default: public)
Returns:
Table structure information as a string |
list_indexes | List all indexes for a specific table. Args:
ctx: FastMCP context for progress reporting and logging
table_name: Name of the table to inspect
schema: Schema name (default: public)
Returns:
Index information as a string |
list_views | List all views in a schema. Args:
ctx: FastMCP context for progress reporting and logging
schema: Schema name (default: public)
Returns:
View information as a string |