Back to MCP Servers
MCP Vertica

MCP Vertica

Public
nolleh/mcp-vertica

Model Context Protocol server enabling secure, efficient Vertica database connection management, advanced SQL query execution, schema inspection, transaction handling, and fine-grained operation and schema-level permissions.

python
0 tools
May 30, 2025
Updated Jun 4, 2025

Supercharge Your AI with MCP Vertica

MCP Server

Unlock the full potential of MCP Vertica through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests
Configuration Requirements
none
Configure authentication and required variables to access this MCP server
Required Environment Variables
VERTICA_PASSWORD
Optional
string

Vertica database password

VERTICA_SSL
Optional
string

Enable SSL/TLS for database connection

Default: false
SCHEMA_DELETE_PERMISSIONS
Optional
string

Schema-specific DELETE permissions (format: schema1:true,schema2:false)

ALLOW_UPDATE_OPERATION
Optional
string

Allow UPDATE operations

Default: false
VERTICA_HOST
Optional
string

Vertica database host

Default: localhost
VERTICA_PORT
Optional
string

Vertica database port

Default: 5433
VERTICA_CONNECTION_LIMIT
Optional
string

Maximum number of database connections

Default: 10
VERTICA_DATABASE
Optional
string

Vertica database name

Default: VMart
SCHEMA_UPDATE_PERMISSIONS
Optional
string

Schema-specific UPDATE permissions (format: schema1:true,schema2:false)

ALLOW_DDL_OPERATION
Optional
string

Allow DDL operations

Default: false
VERTICA_SSL_REJECT_UNAUTHORIZED
Optional
string

Reject unauthorized SSL certificates

Default: true
ALLOW_INSERT_OPERATION
Optional
string

Allow INSERT operations

Default: false
SCHEMA_DDL_PERMISSIONS
Optional
string

Schema-specific DDL permissions (format: schema1:true,schema2:false)

SCHEMA_INSERT_PERMISSIONS
Optional
string

Schema-specific INSERT permissions (format: schema1:true,schema2:false)

ALLOW_DELETE_OPERATION
Optional
string

Allow DELETE operations

Default: false
VERTICA_USER
Optional
string

Vertica database user

Default: dbadmin

Security Notice

Your environment variables and credentials are securely stored and encrypted. LangDB never shares these configuration values with third parties.

Related MCPs5
  • Database MCP Server
    Database MCP Server

    Model Context Protocol server enabling seamless multi-database connectivity, unified query execution, schema and transaction management across SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server for efficient database operations.

    Added May 30, 2025
  • SQL Server Express MCP Server
    SQL Server Express MCP Server

    Model Context Protocol server enabling seamless interaction with Microsoft SQL Server Express, supporting Windows and SQL authentication, and offering database access, query execution, table management, and schema inspection capabilities.

    Added May 30, 2025
  • MySQL Navigator MCP
    MySQL Navigator MCP

    Powerful Model Context Protocol server enabling secure, type-safe MySQL/MariaDB database querying, dynamic database switching, schema retrieval, connection pooling, SSL/TLS support, and comprehensive logging for efficient database management.

    Added May 30, 2025
  • MySQL MCP Server
    MySQL MCP Server

    Connect local MySQL databases with large language models via Model Context Protocol, enabling direct SQL query execution, database schema retrieval, profile-based connection management, and secure stdio communication without port binding.

    Added May 29, 2025
  • mcp-turso-cloud
    mcp-turso-cloud

    Model Context Protocol server enabling seamless integration with Turso databases for LLMs, offering secure two-level authentication, comprehensive organization and database management, read-only and destructive query execution, and advanced features like vector similarity search.

    8 tools
    Added May 29, 2025