MCP 버티카

MCP Vertica

A Vertica MCP(model-context-protocol) Server

Important

If you have troubles to connect this mcp server, try to run uv cache clean, and then retry.

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

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

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

Development

Appendix: For Testing, VerticaDB Docker Compose Example

version: "3.8"

services:
  vertica:
    # image: vertica/vertica-ce:11.1.0-0
    image: vertica/vertica-ce:latest
    platform: linux/amd64
    container_name: vertica-ce
    environment:
      VERTICA_MEMDEBUG: 2
    ports:
      - "5433:5433"
      - "5444:5444"
    volumes:
      - vertica_data:/home/dbadmin/VMart
    healthcheck:
      test:
        [
          "CMD",
          "/opt/vertica/bin/vsql",
          "-h",
          "localhost",
          "-d",
          "VMart",
          "-U",
          "dbadmin",
          "-c",
          "SELECT 1",
        ]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s
    restart: unless-stopped

volumes:
  vertica_data:
    driver: local

Then run server by following instruction Example: Mcp Server Setting, Then see everything works as fine

License

This project is licensed under the MIT License - see the LICENSE file for details.

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

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.

Tools

Vertica 데이터베이스에 대한 SQL 쿼리 실행 및 데이터베이스 관리 기능을 제공하는 모델-컨텍스트-프로토콜 서버로, 연결 풀링, 스키마 관리, 보안 제어 기능을 제공합니다.

Related MCP Servers

MySQL-MCP
zajTools
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
Last updated -
JavaScript
SQLite MCP Server
isaacgounton
-
security
F
license
-
quality
A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
Last updated -
41
JavaScript
MSSQL MCP Server
knight0zh
A
security
A
license
A
quality
A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.
Last updated -
1
54
5
TypeScript
MIT License
MSSQL MCP Server
jensenloke
-
security
F
license
-
quality
A Model Context Protocol server that provides comprehensive access to Microsoft SQL Server databases, enabling Language Models to inspect schemas, execute queries, manage database objects, and perform advanced database operations.
Last updated -
6
Python

View all related MCP servers

MCP Vertica

Example: MCP Server Setting

UVX

Docker

Features

Database Connection Management

Query Operations

Schema Management

Security Features

Tools

Database Operations

Schema Management

Configuration

Environment Variables

Operation Permissions

Schema Permissions

Installation

Installing via Smithery

Installing Manually

Development

Appendix: For Testing, VerticaDB Docker Compose Example

License

Tools

Related MCP Servers

MySQL-MCP

SQLite MCP Server

MSSQL MCP Server

MSSQL MCP Server

MCP directory API