Connects agents to a Hologres instance to read table metadata and run SQL queries for data analysis.
Setup
Choose your client, copy the config, then fill in any required environment variables.
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>"
}
}
}
}Environment variables
HOLOGRES_DATABASEHOLOGRES_HOSTHOLOGRES_PASSWORDHOLOGRES_PORTHOLOGRES_USER
Replace the placeholders with your own credentials and keep them out of version control.