MCP Vertica
by p2k3m
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 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryC | Execute a SQL query and return the results. |
| stream_queryB | 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_structureC | Get the structure of a table including columns, data types, and constraints. |
| list_indexesC | 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/p2k3m/vertica'
If you have feedback or need assistance with the MCP directory API, please join our Discord server