How to add Hologres MCP Server to Cursor

Universal interface between AI agents and Alibaba Cloud Hologres — query metadata, run SQL, diagnose performance. Paste the config into ~/.cursor/mcp.json and restart Cursor.

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

Cursor 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 Cursor → Settings → MCP → Add new MCP server (or edit ~/.cursor/mcp.json directly).
2Paste the Hologres MCP Server config below into the "mcpServers" object.
3Fill in placeholder secrets, then save.
4Cursor reloads MCP servers automatically — check Settings → MCP for a green status dot.
5Ask Cursor to use one of Hologres MCP Server's tools to confirm it's connected.

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 Cursor

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

Where is the Cursor config file?

Cursor reads MCP servers from ~/.cursor/mcp.json. Paste the Hologres MCP Server config there under the "mcpServers" key and restart the client.

Is Hologres MCP Server safe to use with Cursor?

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