smith-nathanh/vertica-mcp-server
3.2
If you are the rightful owner of vertica-mcp-server 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.
The Vertica MCP Server is a Model Context Protocol server designed to integrate Vertica Database capabilities with AI assistants and agents.
Tools
Functions exposed to the LLM to take actions
execute_query
Execute SQL queries (SELECT, DESCRIBE, EXPLAIN only)
describe_table
Get detailed table column information
list_tables
List all tables with metadata
list_views
List all database views
list_projections
List Vertica projections (unique to Vertica)
explain_query
Get query execution plans
generate_sample_queries
Generate example queries for tables
export_query_results
Export query results as JSON or CSV
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client