How to add Hologres MCP Server to Windsurf

Universal interface between AI agents and Alibaba Cloud Hologres — query metadata, run SQL, diagnose performance. Paste the config into ~/.codeium/windsurf/mcp_config.json and restart Windsurf.

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

Windsurf 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 Windsurf → Cascade → the hammer/MCP icon → Configure (or edit ~/.codeium/windsurf/mcp_config.json).
2Paste the Hologres MCP Server config below.
3Fill in placeholder secrets, then save.
4Click Refresh in the MCP panel.
5Hologres MCP Server's tools become available to Cascade.

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 Windsurf

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 + Windsurf FAQ

Where is the Windsurf config file?

Windsurf reads MCP servers from ~/.codeium/windsurf/mcp_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 Windsurf?

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