Vertica Mcp

Name: Vertica Mcp
Author: hechtcarmel

@hechtcarmel

リポジトリ

Vertica Mcp について

Allows to query and inspect Vertica databases

#vertica #database #query

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

hechtcarmel

投稿者

כרמל הכט

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.