MCP Vertica is a Model Context Protocol server that provides comprehensive database connectivity and management tools for Vertica databases.
Execute SQL queries - Run any SQL operations including SELECT, INSERT, UPDATE, DELETE statements
Stream large query results - Process query results in configurable batches for efficient handling of large datasets
Bulk data operations - Use COPY command for efficient bulk data loading into Vertica tables
Schema inspection - Get detailed table structures including columns, data types, and constraints
Index and view management - List all indexes for tables and views within schemas along with their definitions
Connection management - Configurable connection pooling with SSL/TLS support, automatic cleanup, and timeout handling
Security controls - Operation-level permissions (INSERT, UPDATE, DELETE, DDL) and schema-specific access controls
Configuration options - Set database connection parameters (host, port, database, user, password, connection limits) and enable debug logging for troubleshooting
Provides instructions for running Vertica with Docker Compose, including environment setup and container configuration for testing purposes.
Supports configuration through environment variables files, allowing users to set connection parameters, security settings, and operation permissions without command-line arguments.
MCP Vertica
A Vertica MCP(model-context-protocol) Server
Example: MCP Server Setting
Create or edit the file your mcp client config file with the following content:
[!Note]
For boolean flags like
--sslor--ssl-reject-unauthorized, simply add the flag (e.g.,"--ssl") to enable it, or omit it to disable.For an empty password, use an empty string as shown above.
Features
Database Connection Management
Connection pooling with configurable limits
SSL/TLS support
Automatic connection cleanup
Connection timeout handling
Query Operations
Execute SQL queries
Stream large query results in batches
Copy data operations
Transaction management
Schema Management
Table structure inspection
Index management
View management
Constraint information
Column details
Security Features
Operation-level permissions (INSERT, UPDATE, DELETE, DDL)
Schema-specific permissions
SSL/TLS support
Password masking in logs
Related MCP server: SQLite MCP Server
Tools
Database Operations
execute_queryExecute SQL queries
Support for all SQL operations
stream_queryStream large query results in batches
Configurable batch size
copy_dataBulk data loading using COPY command
Efficient for large datasets
Schema Management
get_table_structureGet detailed table structure
Column information
Constraints
list_indexesList all indexes for a table
Index type and uniqueness
Column information
list_viewsList all views in a schema
View definitions
Configuration
Environment Variables
Operation Permissions
Schema Permissions
Installation
Installing via Smithery
To install Vertica Database Connector for Claude Desktop automatically via Smithery:
Installing Manually
License
This project is licensed under the MIT License - see the LICENSE file for details.
Running in Docker Environment
When running Vertica with Docker Compose, you can run the MCP server as follows:
1. Run with Direct Parameters
2. Run with Environment Variables
Create a .env file with the following content:
Then run with .env