MCP Vertica

MCP Vertica is an MCP server that connects large language model clients to Vertica analytical databases for querying, schema inspection, and data management. Data engineers, analysts, and developers interact with Vertica clusters through automated AI workflows without writing manual connection code. The server enables clients to execute standard SQL queries, stream large datasets in configurable batch sizes, and perform high-volume bulk data loading via the Vertica COPY command. In addition to data operations, the server exposes tools to inspect schema structures, including table columns, primary and foreign key constraints, indexes, and view definitions. Administrators can restrict database operations using granular environment variables, enforcing read-only behavior or selectively enabling insert, update, delete, or DDL operations at global or per-schema levels. MCP Vertica includes built-in connection pooling, SSL/TLS encryption, and automatic credential masking within logs to protect database integrity. By bridging MCP-compliant agents with Vertica data warehouses, it facilitates automated analytics, schema exploration, and database management tasks.

Category: Data & Analytics

Tags: analytics, database-management, SQL, vertica

Visit MCP Vertica

How to install and configure MCP Vertica

1. Install automatically via Smithery for Claude Desktop by executing npx -y @smithery/cli install @nolleh/mcp-vertica --client claude. 2. Alternatively, configure your MCP client manually using uvx. Open your client's configuration file and add the vertica server entry: json { "mcpServers": { "vertica": { "command": "uvx", "args": ["mcp-vertica"], "env": { "VERTICA_HOST": "localhost", "VERTICA_PORT": 5433, "VERTICA_DATABASE": "VMart", "VERTICA_USER": "dbadmin", "VERTICA_PASSWORD": "test_password", "VERTICA_CONNECTION_LIMIT": 10, "VERTICA_SSL": false, "VERTICA_SSL_REJECT_UNAUTHORIZED": true } } } } 3. Alternatively, deploy using Docker with the image nolleh/mcp-vertica. 4. Restart your MCP client to initialize the database connection.

What you can do with MCP Vertica

• Querying data tables by executing ad-hoc SQL queries or streaming large analytical result sets in batches through LLM interfaces. - Inspecting database schemas by retrieving table definitions, column types, constraints, and view structures directly from connected Vertica clusters. - Ingesting high-volume datasets into Vertica tables using the automated copy data tool to execute COPY commands efficiently. - Enforcing database safety policies by restricting specific schemas or operation types such as DDL, insert, update, or delete commands. - Auditing table indexes and checking index uniqueness and column alignment during database performance reviews and optimizations.

Key facts

• https://github.com/nolleh/mcp-vertica
• Data & Analytics, Databases & Data Stores
• analytics, database-management, SQL, vertica

Part of MCP Servers

How do I install MCP Vertica?

You can install MCP Vertica automatically for Claude Desktop using Smithery by running npx -y @smithery/cli install @nolleh/mcp-vertica --client claude. Alternatively, you can add it manually to your client configuration file using uvx with the package name mcp-vertica or run the docker image nolleh/mcp-vertica with the appropriate Vertica connection environment variables.

What can MCP Vertica do?

MCP Vertica enables MCP clients to interact directly with Vertica databases. It provides tools to execute SQL queries, stream large query results in batches, bulk load records using the COPY command, and inspect schema elements such as table columns, constraints, indexes, and view definitions while supporting granular operation-level permissions.

Which MCP clients work with MCP Vertica?

MCP Vertica works with any client that implements the Model Context Protocol, including Claude Desktop and custom MCP setups. Configuration can be applied via uvx command execution or containerized Docker deployments depending on what your specific client environment supports.

Is MCP Vertica open source?

Yes, MCP Vertica is open-source software released under the MIT License. You can access, review, modify, and contribute to its codebase freely on GitHub at https://github.com/nolleh/mcp-vertica. Its MIT license allows both personal and commercial use in accordance with standard open-source licensing terms.

How does MCP Vertica manage database security?

MCP Vertica secures database access using configurable environment variables that can restrict insert, update, delete, and DDL operations globally or per schema. It supports SSL/TLS encryption for database communication, enables connection pooling with configurable limits, and masks passwords in server logs.