Summary
Vertica, answerable in conversation.
The streaming query is what makes it usable against a real warehouse: you can ask something that returns a lot of rows without waiting on one enormous response.
What it is
A Python MCP server for Vertica, installable with uvx or run from a Docker image. It executes queries, streams large result sets rather than returning them in one block, describes tables, lists views and indexes, and loads data with COPY.
What you get
- SQL executed against a Vertica database
- Large result sets streamed back rather than returned in one block
- A table's structure read: columns, types and constraints
- Views listed
- Indexes listed
- Data bulk-loaded with COPY
Requirements
A reachable Vertica instance and its credentials — VERTICA_HOST, VERTICA_PORT, VERTICA_DATABASE, VERTICA_USER and VERTICA_PASSWORD — set either as environment variables or as command-line flags. Connection limit and SSL behaviour are configured the same way.
Setup effort
One command plus a key — uvx mcp-vertica, then supply credentials