Vertica FAQs

Question 1

What is mcp-vertica?

Accepted Answer

mcp-vertica is a local development tool that provides a REST API and a terminal-based Natural Language Processing (NLP) interface for interacting with a Vertica database, running entirely on your laptop via Docker.

Question 2

How does mcp-vertica use Natural Language Processing (NLP)?

Accepted Answer

It converts natural language questions (e.g., 'Top 5 incident categories') into Vertica SQL queries. It leverages local Large Language Models (LLMs) like Ollama for intelligent query generation and can execute the generated SQL or show a dry-run.

Question 3

Does mcp-vertica require an existing Vertica instance?

Accepted Answer

No, mcp-vertica can deploy a Vertica Community Edition instance locally using Docker Compose, including default VMart data. You can also configure it to connect to an existing Vertica instance.

Question 4

Is mcp-vertica suitable for production environments?

Accepted Answer

No, mcp-vertica is designed for local demos and development, with security intentionally disabled. It is explicitly warned not to expose it to the public internet or use it in production environments.

Question 5

What are the key features of the mcp-vertica REST API?

Accepted Answer

The REST API allows you to execute standard SQL queries and offers a dedicated NLP endpoint to convert natural language questions into SQL, returning results. It runs locally without authentication, ideal for development and testing.

Vertica

About

Key Features

Use Cases