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
--ssl
or--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
Tools
Database Operations
execute_query
Execute SQL queries
Support for all SQL operations
stream_query
Stream large query results in batches
Configurable batch size
copy_data
Bulk data loading using COPY command
Efficient for large datasets
Schema Management
get_table_structure
Get detailed table structure
Column information
Constraints
list_indexes
List all indexes for a table
Index type and uniqueness
Column information
list_views
List 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
For Testing, VerticaDB Docker Compose Example
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
A Model-Context-Protocol server that provides SQL query execution and database management capabilities for Vertica databases, featuring connection pooling, schema management, and security controls.
- Example: MCP Server Setting
- Features
- Tools
- Configuration
- Installation
- License
- Running in Docker Environment
Related Resources
Related MCP Servers
- -securityFlicense-qualityA Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.Last updated -18
- AsecurityAlicenseAqualityA Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.Last updated -1966MIT License
- -securityFlicense-qualityA Model Context Protocol server that provides comprehensive access to Microsoft SQL Server databases, enabling Language Models to inspect schemas, execute queries, manage database objects, and perform advanced database operations.Last updated -7