Overview
Vertica MCP is the first MCP server implementation for Vertica, providing a Python based MCP interface to a Vertica database with configurable access controls and schema inspection. It enables integration with MCP clients via UVX or Docker and ships with example configurations for local development. The server supports database connection management with pooling, SSL/TLS support, automatic connection cleanup, and connection timeouts. It exposes MCP operations to execute SQL queries, stream large results in batches, and perform bulk data loading using COPY, along with transaction management. For schema management, it can inspect table structures, list indexes, views, constraints, and column details. Security is built in with operation level permissions and schema level permissions, SSL/TLS, and password masking in logs. Configuration is driven by environment variables and MCP client settings, including host, port, database, user, password, connection limit, and SSL toggles. The README includes detailed UVX and Docker setup examples, Smithery installation guidance, and a development workflow with Docker, including a Vertica docker compose appendix for testing.
Features
Database Connection Management
Manages Vertica connections with pooling, SSL/TLS support, automatic cleanup, and timeouts.
Query Operations
Executes SQL queries, streams large results in batches, supports COPY, and handles transactions.
Schema Management
Allows inspection of table structures, indexes, views, constraints, and column details.
Security Features
Enforces operation- and schema-level permissions, enables SSL, and masks passwords in logs.
Who Is This For?
- Developers:Integrate Vertica data with MCP enabled clients using controlled access and schema visibility.
- DBA:Configure permissions and monitor schema details for Vertica via MCP.
- Data Scientists:Query and analyze data with controlled access through MCP, without exposing credentials.
