Connects agents to a Vertica database with configurable access controls and schema inspection.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
claude mcp add vertica --env VERTICA_HOST='<VERTICA_HOST>' --env VERTICA_PORT='<VERTICA_PORT>' --env VERTICA_DATABASE='<VERTICA_DATABASE>' --env VERTICA_USER='<VERTICA_USER>' --env VERTICA_PASSWORD='<VERTICA_PASSWORD>' -- uvx mcp-vertica --host=localhost --db-port=5433 --database=VMart --user=dbadmin --password= --connection-limit=10~/.codex/config.toml
[mcp_servers.vertica]
command = "uvx"
args = ["mcp-vertica", "--host=localhost", "--db-port=5433", "--database=VMart", "--user=dbadmin", "--password=", "--connection-limit=10"]
env = { VERTICA_HOST = "<VERTICA_HOST>", VERTICA_PORT = "<VERTICA_PORT>", VERTICA_DATABASE = "<VERTICA_DATABASE>", VERTICA_USER = "<VERTICA_USER>", VERTICA_PASSWORD = "<VERTICA_PASSWORD>" }
# codex mcp add vertica --env VERTICA_HOST='<VERTICA_HOST>' --env VERTICA_PORT='<VERTICA_PORT>' --env VERTICA_DATABASE='<VERTICA_DATABASE>' --env VERTICA_USER='<VERTICA_USER>' --env VERTICA_PASSWORD='<VERTICA_PASSWORD>' -- uvx mcp-vertica --host=localhost --db-port=5433 --database=VMart --user=dbadmin --password= --connection-limit=10~/.cursor/mcp.json
{
"mcpServers": {
"vertica": {
"command": "uvx",
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"env": {
"VERTICA_HOST": "<VERTICA_HOST>",
"VERTICA_PORT": "<VERTICA_PORT>",
"VERTICA_DATABASE": "<VERTICA_DATABASE>",
"VERTICA_USER": "<VERTICA_USER>",
"VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"vertica": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"env": {
"VERTICA_HOST": "<VERTICA_HOST>",
"VERTICA_PORT": "<VERTICA_PORT>",
"VERTICA_DATABASE": "<VERTICA_DATABASE>",
"VERTICA_USER": "<VERTICA_USER>",
"VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"vertica": {
"command": "uvx",
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"env": {
"VERTICA_HOST": "<VERTICA_HOST>",
"VERTICA_PORT": "<VERTICA_PORT>",
"VERTICA_DATABASE": "<VERTICA_DATABASE>",
"VERTICA_USER": "<VERTICA_USER>",
"VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"vertica": {
"command": "uvx",
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"env": {
"VERTICA_HOST": "<VERTICA_HOST>",
"VERTICA_PORT": "<VERTICA_PORT>",
"VERTICA_DATABASE": "<VERTICA_DATABASE>",
"VERTICA_USER": "<VERTICA_USER>",
"VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"vertica": {
"command": "uvx",
"args": [
"mcp-vertica",
"--host=localhost",
"--db-port=5433",
"--database=VMart",
"--user=dbadmin",
"--password=",
"--connection-limit=10"
],
"env": {
"VERTICA_HOST": "<VERTICA_HOST>",
"VERTICA_PORT": "<VERTICA_PORT>",
"VERTICA_DATABASE": "<VERTICA_DATABASE>",
"VERTICA_USER": "<VERTICA_USER>",
"VERTICA_PASSWORD": "<VERTICA_PASSWORD>"
}
}
}
}需要的环境变量
VERTICA_HOSTVERTICA_PORTVERTICA_DATABASEVERTICA_USERVERTICA_PASSWORD
把占位值换成你自己的密钥；不要把密钥提交到代码仓库。