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
This server cannot be installed
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.
Related MCP Servers
- -securityFlicense-qualityA Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.Last updated -JavaScript
- -securityAlicense-qualityA Model Context Protocol server that provides Claude access to Turso-hosted LibSQL databases, enabling database table listing, schema retrieval, and SELECT query execution.Last updated -685TypeScriptMIT License
- -security-license-qualityA Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.Last updated -Python
- -securityAlicense-qualityA Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.Last updated -3TypeScriptMIT License