Loading subscription status...
💡 Description
A Model Context Protocol server that provides SQL query execution and database management functionality for Vertica databases, including connection pool management, schema management, and security controls.
📝 JSON Entries
{
"mcpServers": [
{
"vertica": {
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"command": "uvx"
}
}
]
}🛠️ Tools
execute_querystream_querycopy_dataget_table_structurelist_indexeslist_views
⚡ Features
- Connection pool management with configurable limits
- SQL query execution support
- Schema management capabilities
- Security features with operation-level permissions
💬 Example Queries
- Execute a SQL query to retrieve data from the VMart database.
- Stream large query results in batches.