Connects agents to a Hologres instance to read table metadata and run SQL queries for data analysis.
接入配置
选择客户端,复制配置,再按项目文档补齐环境变量。
claude mcp add hologres --env HOLOGRES_DATABASE='<HOLOGRES_DATABASE>' --env HOLOGRES_HOST='<HOLOGRES_HOST>' --env HOLOGRES_PASSWORD='<HOLOGRES_PASSWORD>' --env HOLOGRES_PORT='<HOLOGRES_PORT>' --env HOLOGRES_USER='<HOLOGRES_USER>' -- uvx hologres-mcp-server --transport streamable-http --host 0.0.0.0 --port 8000~/.codex/config.toml
[mcp_servers.hologres]
command = "uvx"
args = ["hologres-mcp-server", "--transport", "streamable-http", "--host", "0.0.0.0", "--port", "8000"]
env = { HOLOGRES_DATABASE = "<HOLOGRES_DATABASE>", HOLOGRES_HOST = "<HOLOGRES_HOST>", HOLOGRES_PASSWORD = "<HOLOGRES_PASSWORD>", HOLOGRES_PORT = "<HOLOGRES_PORT>", HOLOGRES_USER = "<HOLOGRES_USER>" }
# codex mcp add hologres --env HOLOGRES_DATABASE='<HOLOGRES_DATABASE>' --env HOLOGRES_HOST='<HOLOGRES_HOST>' --env HOLOGRES_PASSWORD='<HOLOGRES_PASSWORD>' --env HOLOGRES_PORT='<HOLOGRES_PORT>' --env HOLOGRES_USER='<HOLOGRES_USER>' -- uvx hologres-mcp-server --transport streamable-http --host 0.0.0.0 --port 8000~/.cursor/mcp.json
{
"mcpServers": {
"hologres": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
],
"env": {
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>",
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"hologres": {
"type": "stdio",
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
],
"env": {
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>",
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"hologres": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
],
"env": {
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>",
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"hologres": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
],
"env": {
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>",
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"hologres": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
],
"env": {
"HOLOGRES_DATABASE": "<HOLOGRES_DATABASE>",
"HOLOGRES_HOST": "<HOLOGRES_HOST>",
"HOLOGRES_PASSWORD": "<HOLOGRES_PASSWORD>",
"HOLOGRES_PORT": "<HOLOGRES_PORT>",
"HOLOGRES_USER": "<HOLOGRES_USER>"
}
}
}
}需要的环境变量
HOLOGRES_DATABASEHOLOGRES_HOSTHOLOGRES_PASSWORDHOLOGRES_PORTHOLOGRES_USER
把占位值换成你自己的密钥;不要把密钥提交到代码仓库。