Vertica MCP Server

@hechtcarmel

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

hechtcarmel

提交者

כרמל הכט

关于 Vertica MCP Server

Allows to query and inspect Vertica databases

#vertica#database #query

Vertica MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

Vertica MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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.

其他分类下的更多 MCP 服务器

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

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

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

ICSS

chokcoco

不止于 CSS

20.7K

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w