Vertica Mcp
About
Provides read-only access to Vertica databases.
Details
- Author
- hechtcarmel
- Downloads
- 369
- Categories
- Database, Other
Jump to
- Readonly execution enforced on all queries
- Schema discovery (tables, views, indexes/projections)
- Table structure analysis with columns and constraints
- Streaming support for large result sets
- Parameterized queries with SQL injection protection
- SSL/TLS connection support
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Vertica McpCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Configure an environment file with Vertica connection details (host, port, database, user, password), then add the server to your Cursor or Claude Desktop MCP configuration. Run via npx @hechtcarmel/vertica-mcp@1.2.2 --env-file /path/to/vertica.env. The server exposes six tools for querying and schema discovery.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"vertica mcp": {
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/vertica-mcp@1.2.2",
"--env-file",
"/path/to/your/vertica.env"
]
}
}
}
}McpServers
{
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/vertica-mcp@1.2.2",
"--env-file",
"/path/to/your/vertica.env"
]
}
}Vertica MCP Server
A Model Context Protocol (MCP) server for readonly communication with Vertica databases. This server enables AI assistants like Claude and Cursor to interact with Vertica databases safely through a comprehensive set of readonly operations.
Features
- 🔒 Readonly Operations Only - Ensures database safety with SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH queries only
- 🏗️ Comprehensive Schema Discovery - List tables, views, and indexes with detailed metadata
- 🔍 Table Structure Analysis - Get detailed column information, data types, and constraints
- 📊 Query Execution - Execute custom SQL queries with parameter support
- 🌊 Streaming Support - Handle large result sets efficiently with batch streaming
- ⚡ High Performance - Optimized connection handling and query execution for Vertica
- 🛡️ Type Safety - Full TypeScript implementation with comprehensive error handling
- 📋 MCP Standard Compliance - Built with official @modelcontextprotocol/sdk following MCP best practices
Prerequisites
- Node.js 18.x or higher
- Access to a Vertica database
- Environment variables for database connection
Installation & Usage
Quick Start with Cursor (Recommended)
The easiest way to use this MCP server with Cursor is to configure it in your MCP settings:
1. Create an environment file (e.g., ~/.cursor/vertica.env):
```env
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
