広告掲載
MCP.so
ログイン
V

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

よくある質問

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.

コメント

「その他」の他のコンテンツ

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.

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

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

広告掲載