Skip to main content
Glama
deenesjakoruzh

MCP Vertica

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

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

  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

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
A
security – no known vulnerabilities
A
license - permissive license
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

Un servidor de modelo-contexto-protocolo que proporciona ejecución de consultas SQL y capacidades de administración de bases de datos para bases de datos Vertica, con agrupación de conexiones, administración de esquemas y controles de seguridad.

  1. Ejemplo: Configuración del servidor MCP
    1. Características
      1. Gestión de la conexión a bases de datos
      2. Operaciones de consulta
      3. Gestión de esquemas
      4. Características de seguridad
    2. Herramientas
      1. Operaciones de base de datos
      2. Gestión de esquemas
    3. Configuración
      1. Variables de entorno
      2. Permisos de operación
      3. Permisos de esquema
    4. Instalación
      1. Licencia
        1. Ejecución en el entorno Docker
          1. 1. Ejecutar con parámetros directos
          2. 2. Ejecutar con variables de entorno
          3. Para pruebas, ejemplo de Docker Compose de VerticaDB

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