Skip to main content

de en es ja ko ru zh

MCP Vertica

MIT License

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

Server Configuration

Describes the environment variables required to run the server.

Name	Required	Description	Default
`VERTICA_SSL`	No	Enable SSL/TLS for database connection	false
`VERTICA_HOST`	No	Vertica database host	localhost
`VERTICA_PORT`	No	Vertica database port	5433
`VERTICA_USER`	No	Vertica database user	dbadmin
`VERTICA_DATABASE`	No	Vertica database name	VMart
`VERTICA_PASSWORD`	No	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	Maximum number of database connections	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	Reject unauthorized SSL certificates	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 stream the results in batches. Args: ctx: FastMCP context for progress reporting and logging query: SQL query to execute batch_size: Number of rows to fetch at once Yields: Batches of query results as strings
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

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/nolleh/mcp-vertica'

If you have feedback or need assistance with the MCP directory API, please join our Discord server