Skip to main content
Glama
deenesjakoruzh

MCP Vertica

by nolleh
GitHub
Python
MIT License
2
  • Linux
OverviewInspectNewEndpointsSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

MseeP.ai Security Assessment Badge

MCP Vertica

smithery badge

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:

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

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

  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

uvx mcp-vertica

License

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

Running in Docker Environment

When running Vertica with Docker Compose, you can run the MCP server as follows:

1. Run with Direct Parameters

uvx mcp-vertica \ --host localhost \ --db-port 5433 \ --database VMart \ --user dbadmin \ --password "" \ --connection-limit 10

2. Run with Environment Variables

Create a .env file with the following content:

VERTICA_HOST=localhost VERTICA_PORT=5433 VERTICA_DATABASE=test_db VERTICA_USER=test_user VERTICA_PASSWORD=test_password VERTICA_CONNECTION_LIMIT=10 VERTICA_SSL=false VERTICA_SSL_REJECT_UNAUTHORIZED=true

Then run with .env

uvx mcp-vertica \ --env-file .env

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
Deploy Server
A
security – no known vulnerabilities
-
license - not tested
A
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

A Model-Context-Protocol server that provides SQL query execution and database management capabilities for Vertica databases, featuring connection pooling, schema management, and security controls.

  1. Example: MCP Server Setting
    1. Features
      1. Database Connection Management
      2. Query Operations
      3. Schema Management
      4. Security Features
    2. Tools
      1. Database Operations
      2. Schema Management
    3. Configuration
      1. Environment Variables
      2. Operation Permissions
      3. Schema Permissions
    4. Installation
      1. Installing via Smithery
      2. Installing Manually
    5. License
      1. Running in Docker Environment
        1. 1. Run with Direct Parameters
        2. 2. Run with Environment Variables
        3. For Testing, VerticaDB Docker Compose Example

      Related Resources

      Related MCP Servers

      • MySQL-MCP

        zajTools
        -
        security
        -
        license
        -
        quality
        A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
        Last updated -

      • SQLite MCP Server

        isaacgounton
        -
        security
        -
        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 -
        18

      • MSSQL MCP Server

        knight0zh
        A
        security
        -
        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
        6
        MIT License

      • MSSQL MCP Server

        jensenloke
        -
        security
        -
        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 -
        7

      View all related MCP servers

      New MCP Servers

      MCP directory API

      We provide all the information about MCP servers via our MCP API.

      curl -X GET 'https://glama.ai/api/mcp/v1/servers/nolleh/mcp-vertica'

      If you have feedback or need assistance with the MCP directory API, please join our Discord server