MCP Vertica

by nolleh

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
VERTICA_SSLNoEnable SSL/TLS for database connectionfalse
VERTICA_HOSTNoVertica database hostlocalhost
VERTICA_PORTNoVertica database port5433
VERTICA_USERNoVertica database userdbadmin
VERTICA_DATABASENoVertica database nameVMart
VERTICA_PASSWORDNoVertica database password
ALLOW_DDL_OPERATIONNoAllow DDL operationsfalse
ALLOW_DELETE_OPERATIONNoAllow DELETE operationsfalse
ALLOW_INSERT_OPERATIONNoAllow INSERT operationsfalse
ALLOW_UPDATE_OPERATIONNoAllow UPDATE operationsfalse
SCHEMA_DDL_PERMISSIONSNoSchema-specific DDL permissions (format: schema1:true,schema2:false)
VERTICA_CONNECTION_LIMITNoMaximum number of database connections10
SCHEMA_DELETE_PERMISSIONSNoSchema-specific DELETE permissions (format: schema1:true,schema2:false)
SCHEMA_INSERT_PERMISSIONSNoSchema-specific INSERT permissions (format: schema1:true,schema2:false)
SCHEMA_UPDATE_PERMISSIONSNoSchema-specific UPDATE permissions (format: schema1:true,schema2:false)
VERTICA_SSL_REJECT_UNAUTHORIZEDNoReject unauthorized SSL certificatestrue

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

ID: iie8p4p6vy