How to add Hologres MCP Server to Claude Desktop

Universal interface between AI agents and Alibaba Cloud Hologres — query metadata, run SQL, diagnose performance. Paste the config into ~/Library/Application Support/Claude/claude_desktop_config.json and restart Claude Desktop.

Last updated June 14, 2026 · 34★ · stdio · apikey

Claude Desktop config for Hologres MCP Server

pip install hologres-mcp-server

{
  "mcpServers": {
    "hologres-mcp-server": {
      "command": "uvx",
      "args": [
        "hologres-mcp-server"
      ],
      "env": {
        "HOLOGRES_HOST": "host",
        "HOLOGRES_PORT": "port",
        "HOLOGRES_USER": "access_id",
        "HOLOGRES_PASSWORD": "access_key",
        "HOLOGRES_DATABASE": "database"
      }
    }
  }
}

Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.

Setup steps

1Open Claude Desktop → Settings → Developer → Edit Config (this opens ~/Library/Application Support/Claude/claude_desktop_config.json).
2Paste the Hologres MCP Server config below under the top-level "mcpServers" key.
3Fill in any placeholder secrets (API keys, paths) in the snippet.
4Save the file, then fully quit and reopen Claude Desktop.
5Open a chat and confirm Hologres MCP Server's tools appear under the 🔌 tools menu.

Before you start

An Alibaba Cloud Hologres instance with host, port, and database
Alibaba Cloud AccessKey ID and Secret (used as HOLOGRES_USER / HOLOGRES_PASSWORD)
Python with uv/uvx (or pip) to install and run the server

What Hologres MCP Server can do in Claude Desktop

execute_hg_select_sql

Execute a SELECT SQL query in the Hologres database.

execute_hg_select_sql_with_serverless

Execute a SELECT SQL query using Hologres serverless computing.

execute_hg_dml_sql

Execute a DML (INSERT, UPDATE, DELETE) SQL query.

execute_hg_ddl_sql

Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query.

gather_hg_table_statistics

Collect table statistics for a given schema and table.

get_hg_query_plan

Get the query plan for a SQL statement.

get_hg_execution_plan

Get the execution plan for a SQL statement.

call_hg_procedure

Invoke a stored procedure in the Hologres database.

Security

Authentication uses Alibaba Cloud AccessKey credentials (HOLOGRES_USER = access_id, HOLOGRES_PASSWORD = access_key) supplied via environment variables. The server can execute DML and DDL (INSERT/UPDATE/DELETE, CREATE/ALTER/DROP) and warehouse/queue management operations, several of which require superuser privileges — grant a least-privilege Hologres account scoped to the intended database. When using the Streamable HTTP transport bound to 0.0.0.0, restrict network access since the /mcp endpoint exposes full database operations.

Hologres MCP Server + Claude Desktop FAQ

Where is the Claude Desktop config file?

Claude Desktop reads MCP servers from ~/Library/Application Support/Claude/claude_desktop_config.json. Paste the Hologres MCP Server config there under the "mcpServers" key and restart the client.

Is Hologres MCP Server safe to use with Claude Desktop?

How do I provide Hologres credentials?

Set the HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER (access_id), HOLOGRES_PASSWORD (access_key), and HOLOGRES_DATABASE environment variables in your MCP client config or shell before launching the server.

What installation modes are supported?

Three: running from a local clone via uv --directory, installing the hologres-mcp-server package with pip/uvx (stdio), or running Streamable HTTP transport for remote deployment where stdio is unavailable.

Does it support remote/HTTP deployment?

Yes. Start it with --transport streamable-http --host 0.0.0.0 --port 8000 and point the client at http://<host>:<port>/mcp. SSE transport is also available via --transport sse.

View repo Full Hologres MCP Server page