Vertica Database Connector is an MCP server that enables AI assistants to interact with Vertica analytical databases through SQL queries and schema management. Key features of Vertica Database Connector: - Execute SQL queries directly against Vertica databases - Stream large query results in configurable batches for efficient data handling - Inspect database schemas and metadata - Connection pooling with configurable limits for optimal performance - Secure connections via SSL/TLS encryption - Automatic connection cleanup and timeout handling - Connection parameter support via environment variables or command-line arguments

[](https://mseep.ai/app/nolleh-mcp-vertica)

MCP Vertica

[](https://pypi.org/project/mcp-vertica/) [](https://opensource.org/licenses/MIT) [](https://pepy.tech/project/mcp-vertica) [](https://smithery.ai/server/@nolleh/mcp-vertica) [](https://github.com/modelcontextprotocol/servers)

🏆 First implementation of Vertica MCP Server • Learn more

✅ Listed in Model Context Protocol Official Registry

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:

#### UVX

{
  "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
      }
    }
  }
}

Or with args

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=test_password",
        "--connection-limit=10"
      ]
    }
  }
}

#### Docker

{
  "mcpServers": {
    "vertica": {
      "command": "docker",
      "args": ["run", "-i", "--rm", "nolleh/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
      }
    }
  }
}

> [!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

Query Operations

Schema Management

Security Features

Tools

Database Operations

1. execute_query

- Execute SQL queries - Support for all SQL operations

2. stream_query

- Stream large query results in batches - Configurable batch size

3. copy_data - Bulk data loading using COPY command - Efficient for large datasets

Schema Management

1. get_table_structure

- Get detailed table structure - Column information - Constraints

2. list_indexes

- List all indexes for a table - Index type and uniqueness - Column information

3. list_views - List all views in a schema - View definitions

Configuration

Environment Variables

VERTICA_HOST=localhost
VERTICA_PORT=5433
VERTICA_DATABASE=VMart
VERTICA_USER=newdbadmin
VERTICA_PASSWORD=vertica
VERTICA_CONNECTION_LIMIT=10
VERTICA_SSL=false
VERTICA_SSL_REJECT_UNAUTHORIZED=true

Operation Permissions

ALLOW_INSERT_OPERATION=false
ALLOW_UPDATE_OPERATION=false
ALLOW_DELETE_OPERATION=false
ALLOW_DDL_OPERATION=false

Schema Permissions

SCHEMA_INSERT_PERMISSIONS=schema1:true,schema2:false
SCHEMA_UPDATE_PERMISSIONS=schema1:true,schema2:false
SCHEMA_DELETE_PERMISSIONS=schema1:true,schema2:false
SCHEMA_DDL_PERMISSIONS=schema1:true,schema2:false

Installation

Installing via Smithery

To install Vertica Database Connector for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install @nolleh/mcp-vertica --client claude

Installing Manually

Open your favorite mcp client's config file, then configure with uvx mcp-vertica

[Example: Mcp Server Setting](#example%