Vertica Mcp
About
Provides read-only access to Vertica databases.
Explore
- 🔒 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
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
- Node.js 18.x or higher
- Access to a Vertica database
- Environment variables for database connection
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):
Add the following to your Claude Desktop configuration file:
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/[email protected]",
"--env-file",
"/path/to/your/vertica.env"
]
}
}
}
npx @hechtcarmel/[email protected] --env-file /path/to/your/.env
npx @hechtcarmel/[email protected]
Create a .env file with your Vertica connection details:
npm install
{
"mcpServers": {
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/[email protected]",
"--env-file",
"/Users/yourusername/.cursor/vertica.env"
]
}
}
}
VERTICA_HOST=your-vertica-host.com
VERTICA_PORT=5433
VERTICA_DATABASE=your_database
VERTICA_USER=your_username
VERTICA_PASSWORD=your_password
VERTICA_DEFAULT_SCHEMA=public
```
---
Note: This server provides readonly access only. It cannot modify data, structure, or permissions in your Vertica database, ensuring safety for production environments.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"vertica mcp": {
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/[email protected]",
"--env-file",
"/path/to/your/vertica.env"
]
}
}
}
}McpServers
{
"vertica-mcp": {
"command": "npx",
"args": [
"@hechtcarmel/[email protected]",
"--env-file",
"/path/to/your/vertica.env"
]
}
}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.
