mcp-vertica

nolleh/mcp-vertica

3.3

If you are the rightful owner of mcp-vertica and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MCP Vertica is a model-context-protocol server designed to manage and interact with Vertica databases efficiently.

Tools

Functions exposed to the LLM to take actions

execute_query

Execute SQL queries with support for all SQL operations.

stream_query

Stream large query results in batches with configurable batch size.

copy_data

Bulk data loading using the COPY command, efficient for large datasets.

get_table_structure

Get detailed table structure, including column information and constraints.

list_indexes

List all indexes for a table, including index type and uniqueness.

list_views

List all views in a schema with view definitions.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources