Advertise
MCP.so
Sign In
V

Vertica MCP Server

@hechtcarmel

Repository

Basic information

Category

Other

Transports

stdio

Author

hechtcarmel

Submitted by

כרמל הכט

About Vertica MCP Server

Allows to query and inspect Vertica databases

#vertica#database#query

Vertica MCP Server config

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

{
  "mcpServers": {
    "vertica-mcp": {
      "command": "npx",
      "args": [
        "@hechtcarmel/vertica-mcp@1.2.2",
        "--env-file",
        "/path/to/your/vertica.env"
      ]
    }
  }
}

Vertica MCP Server 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 Vertica Mcp?

A Model Context Protocol (MCP) server for readonly communication with Vertica databases. It enables AI assistants like Claude and Cursor to safely execute SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH queries, explore schemas, and retrieve metadata from Vertica.

How to use Vertica Mcp?

Configure an environment file with Vertica connection details (host, port, database, user, password), then add the server to your Cursor or Claude Desktop MCP configuration. Run via npx @hechtcarmel/vertica-mcp@1.2.2 --env-file /path/to/vertica.env. The server exposes six tools for querying and schema discovery.

Key features of Vertica Mcp

  • Readonly execution enforced on all queries
  • Schema discovery (tables, views, indexes/projections)
  • Table structure analysis with columns and constraints
  • Streaming support for large result sets
  • Parameterized queries with SQL injection protection
  • SSL/TLS connection support

Use cases of Vertica Mcp

  • AI assistant safely querying Vertica for analytics
  • Exploring database schema and table definitions
  • Debugging queries with EXPLAIN plans
  • Streaming large fact tables into AI tools
  • Integration with Cursor or Claude for Vertica data access

Frequently asked questions

1

Is the server truly readonly?

Yes, it validates every query starts with SELECT, SHOW, DESCRIBE, EXPLAIN, or WITH. Write operations are blocked.

2

What runtime does it require?

Node.js 18.x or higher. It runs via npx and uses the official `@modelcontextprotocol/sdk`.

3

How do I configure the database connection?

Set environment variables: `VERTICA_HOST`, `VERTICA_PORT`, `VERTICA_DATABASE`, `VERTICA_USER`, `VERTICA_PASSWORD`. Optional: `VERTICA_SSL`, `VERTICA_CONNECTION_LIMIT`, `VERTICA_QUERY_TIMEOUT`.

4

What tools are available?

Six tools: `execute_query`, `stream_query`, `get_table_structure`, `list_tables`, `list_views`, `list_indexes`. Each accepts optional schema parameters.

5

How is performance handled?

Streaming queries support batching (default 1000 rows, max 10000) and max rows up to 1,000,000. Query timeouts prevent long-running operations.

Comments

More Other MCP servers

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Advertise