Vertica Mcp

@hechtcarmel

About Vertica Mcp

Allows to query and inspect Vertica databases

Config

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

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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/[email protected] --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

FAQ from Vertica Mcp

Is the server truly readonly?

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

What runtime does it require?

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

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.

What tools are available?

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

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.

Frequently asked questions

Is the server truly readonly?

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

What runtime does it require?

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

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

What tools are available?

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

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

Basic information

More Other MCP servers

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

MCP Toolbox for Databases

googleapis

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

15.9K

XcodeBuildMCP

cameroncooke

A Model Context Protocol (MCP) server and CLI that provides tools for agent use when working on iOS and macOS projects.

6.0K

Mcp

browsermcp

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

🪟 Windows-MCP

CursorTouch

MCP Server for Computer Use in Windows

6.3K