广告合作
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.

评论

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

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

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

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.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

The Living Bread

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

广告合作