MCP.so
ログイン

MCP Vertica

@nolleh

リポジトリ

MCP Vertica について

MCP server for Vertica database (OpenText - Vertica)

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

基本情報

カテゴリ

その他

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

nolleh

設定

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

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

ツール

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

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

概要

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

FAQ from MCP Vertica

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.

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.

Where does my data live?

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

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.

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.

コメント

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

ghidraMCP

LaurieWired

MCP Server for Ghidra

9.4K

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K