Vertica MCP Server

Vertica MCP Server is an MCP server that provides AI assistants with read-only database query execution and schema discovery for Vertica analytics environments. Built for data analysts, analytics engineers, and developers, it enables large language models like Claude to inspect columnar tables, inspect schema definitions, and execute SQL statements safely using natural language. The server connects directly to Vertica clusters using persistent connection handling and parameter binding to protect against SQL injection. Safety is enforced by default through a read-only execution layer that restricts operations to queries such as SELECT, SHOW, DESCRIBE, and EXPLAIN, though write permissions can be manually enabled if needed. Vertica MCP Server supports projection exploration to help users understand performance characteristics, along with streaming tools configured to batch up to one million rows for data extraction. It also integrates node redirect logic to transparently balance connection loads across Vertica cluster members.

Category: Data & Analytics

Tags: analytics, data-warehouse, SQL, vertica

Visit Vertica MCP Server

How to install and configure Vertica MCP Server

1. Ensure Node.js version 18.0.0 or higher is installed and network access to your Vertica instance is available. 2. Create an environment file containing your database credentials with VERTICA_HOST, VERTICA_PORT (default 5433), VERTICA_DATABASE, VERTICA_USER, and VERTICA_PASSWORD. 3. Add the server configuration to your Claude Desktop config file (claude_desktop_config.json) or Cursor's ~/.cursor/mcp.json under mcpServers: json { "mcpServers": { "vertica-mcp": { "command": "npx", "args": [ "@hechtcarmel/vertica-mcp", "--env-file", "/path/to/your/.env" ] } } } 4. Alternatively, register directly via Claude Code CLI by running claude mcp add vertica --scope user -- npx -y @hechtcarmel/vertica-mcp@latest --env-file /path/to/your/.env. 5. Restart your MCP client to initialize the server connection.

What you can do with Vertica MCP Server

• Exploring Vertica database schemas by listing tables, viewing column definitions, constraints, and data types via natural language prompts. - Executing analytical read-only SQL queries to aggregate warehouse metrics and retrieve grouped reporting insights without risking database mutations. - Streaming large analytical datasets in batches of up to 10,000 rows without exceeding client-side memory or token buffers. - Inspecting Vertica projections and running EXPLAIN statements to diagnose slow execution plans and optimize complex analytical queries. - Inspecting existing database views and structural definitions to verify ETL pipeline outputs and data transformation logic.

Key facts

• https://github.com/hechtcarmel/vertica-mcp
• Data & Analytics, Databases & Data Stores
• analytics, data-warehouse, SQL, vertica

Part of MCP Servers

How do I install Vertica MCP Server?

You can run Vertica MCP Server using npx with the package @hechtcarmel/vertica-mcp. Supply connection parameters via an environment file referencing your Vertica host, database, and user credentials, then register the command in your Claude Desktop or Cursor configuration file.

What can Vertica MCP Server do?

It provides six distinct tools for executing SQL queries, streaming batch results up to one million rows, and discovering schema structures. Assistants can list tables, retrieve view definitions, inspect table constraints, and analyze projections for query performance tuning.

Which MCP clients work with Vertica MCP Server?

The server works with any client supporting the Model Context Protocol over stdio. Documented configurations include Claude Desktop, Cursor, and the Claude Code command-line interface, provided Node.js 18 or later is installed.

Is Vertica MCP Server read-only by default?

Yes, safety-first read-only protection is enabled by default. It restricts queries to SELECT, SHOW, DESCRIBE, EXPLAIN, and WITH statements. Modifying operations like INSERT, UPDATE, or DROP require explicitly setting VERTICA_READONLY_MODE to false.

Is Vertica MCP Server open source?

Yes, Vertica MCP Server is open source and distributed under the MIT License on GitHub. You can freely inspect the code, customize connection parameters, or contribute improvements to the repository.