MCP Vertica
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| VERTICA_SSL | No | Enable SSL/TLS connection | 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 pool 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 | Whether to reject unauthorized SSL certificates | true |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| 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 |
|---|---|
| execute_queryC | Execute a SQL query and return the results. |
| stream_queryC | Execute a SQL query and return the results in batches as a single string. |
| copy_dataC | Copy data into a Vertica table using COPY command. |
| get_table_structureB | Get the structure of a table including columns, data types, and constraints. |
| list_indexesB | List all indexes for a specific table. |
| list_viewsB | List all views in a 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 | |
TDQS
Scored across 6 tools
Most tools are distinct, but 'execute_query' and 'stream_query' both execute SQL queries with only a difference in batch handling, leading to potential confusion for an agent.
All tools follow a consistent verb_noun pattern with underscores (e.g., copy_data, list_indexes, get_table_structure), making the naming predictable.
6 tools is a reasonable size for a focused database server, though it leans slightly low.
The set covers query execution and data copying but lacks essential operations like table creation, modification, and deletion, leaving significant gaps for typical database management.