Advertise
MCP.so
Sign In

MCP Vertica

@nolleh

Repository

Basic information

Category

Other

License

MIT

Transports

stdio

Author

nolleh

About MCP Vertica

MCP server for Vertica database (OpenText - Vertica)

#mcp#vertica#model-context-protocol#mcp-server

MCP Vertica config

Add this server to your MCP-compatible client using the configuration below.

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

MCP Vertica tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is MCP Vertica?

MCP Vertica is a Model Context Protocol (MCP) server that provides a standardized interface for AI assistants to interact with a Vertica database. It is designed for developers and data analysts who want to query, manage, and load data into Vertica using natural language or MCP-compatible clients.

How to use MCP Vertica?

Install via Smithery (npx -y @smithery/cli install @nolleh/mcp-vertica --client claude) or manually configure your MCP client’s settings file with either uvx or Docker. Set environment variables for connection details (e.g., VERTICA_HOST, VERTICA_PORT, VERTICA_DATABASE, VERTICA_USER, VERTICA_PASSWORD) or pass them as command-line arguments. Optionally configure operation permissions and schema-level permissions using environment variables.

Key features of MCP Vertica

  • Connection pooling with configurable limits
  • SSL/TLS support and automatic connection cleanup
  • Execute SQL queries and stream large results in batches
  • Bulk data loading via COPY command
  • Table structure inspection, index and view management
  • Operation-level and schema-specific permissions

Use cases of MCP Vertica

  • Querying Vertica databases using natural language through an AI assistant
  • Streaming large query results in batches for efficient processing
  • Bulk loading large datasets into Vertica tables
  • Inspecting database schemas, indexes, and views
  • Managing database permissions at the operation and schema level

Frequently asked questions

1

What is MCP Vertica?

MCP Vertica is the first implementation of a Vertica MCP server, enabling AI tools to interact with Vertica databases via the Model Context Protocol.

2

What are the runtime requirements?

MCP Vertica requires Python (`uvx`), or can be run as a Docker container. A Vertica database instance must be accessible.

3

Where does my data live?

All data remains in the Vertica database; the server only acts as a bridge, executing queries and returning results.

4

What transport modes are supported?

The server supports both stdio (default) and HTTP transport. HTTP transport can be configured via the `TRANSPORT` and `PORT` environment variables.

5

How do I restrict write operations?

Set environment variables like `ALLOW_INSERT_OPERATION=false`, `ALLOW_UPDATE_OPERATION=false`, `ALLOW_DELETE_OPERATION=false`, `ALLOW_DDL_OPERATION=false`. Schema-specific permissions can be set via `SCHEMA_*_PERMISSIONS` variables.

Comments

More Other MCP servers

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K
Advertise