広告掲載
MCP.so
ログイン

MCP Vertica

@nolleh

リポジトリ

基本情報

カテゴリ

その他

ライセンス

MIT

トランスポート

stdio

作者

nolleh

MCP Vertica について

MCP server for Vertica database (OpenText - Vertica)

#mcp#vertica#model-context-protocol#mcp-server

MCP Vertica の設定

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

{
  "mcpServers": {
    "vertica": {
      "command": "uvx",
      "args": [
        "mcp-vertica",
        "--host=localhost",
        "--db-port=5433",
        "--database=VMart",
        "--user=dbadmin",
        "--password=",
        "--connection-limit=10"
      ]
    }
  }
}

MCP Vertica のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is MCP Vertica?

MCP Vertica is a Model Context Protocol (MCP) server that provides a standardized interface for AI assistants to interact with a Vertica database. It is designed for developers and data analysts who want to query, manage, and load data into Vertica using natural language or MCP-compatible clients.

How to use MCP Vertica?

Install via Smithery (npx -y @smithery/cli install @nolleh/mcp-vertica --client claude) or manually configure your MCP client’s settings file with either uvx or Docker. Set environment variables for connection details (e.g., VERTICA_HOST, VERTICA_PORT, VERTICA_DATABASE, VERTICA_USER, VERTICA_PASSWORD) or pass them as command-line arguments. Optionally configure operation permissions and schema-level permissions using environment variables.

Key features of MCP Vertica

  • Connection pooling with configurable limits
  • SSL/TLS support and automatic connection cleanup
  • Execute SQL queries and stream large results in batches
  • Bulk data loading via COPY command
  • Table structure inspection, index and view management
  • Operation-level and schema-specific permissions

Use cases of MCP Vertica

  • Querying Vertica databases using natural language through an AI assistant
  • Streaming large query results in batches for efficient processing
  • Bulk loading large datasets into Vertica tables
  • Inspecting database schemas, indexes, and views
  • Managing database permissions at the operation and schema level

よくある質問

1

What is MCP Vertica?

MCP Vertica is the first implementation of a Vertica MCP server, enabling AI tools to interact with Vertica databases via the Model Context Protocol.

2

What are the runtime requirements?

MCP Vertica requires Python (`uvx`), or can be run as a Docker container. A Vertica database instance must be accessible.

3

Where does my data live?

All data remains in the Vertica database; the server only acts as a bridge, executing queries and returning results.

4

What transport modes are supported?

The server supports both stdio (default) and HTTP transport. HTTP transport can be configured via the `TRANSPORT` and `PORT` environment variables.

5

How do I restrict write operations?

Set environment variables like `ALLOW_INSERT_OPERATION=false`, `ALLOW_UPDATE_OPERATION=false`, `ALLOW_DELETE_OPERATION=false`, `ALLOW_DDL_OPERATION=false`. Schema-specific permissions can be set via `SCHEMA_*_PERMISSIONS` variables.

コメント

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

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

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.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K
広告掲載