Hologres MCP Server

Universal interface between AI agents and Alibaba Cloud Hologres — query metadata, run SQL, diagnose performance.

Unverified

stdio (local)

API key

Python

View repo 34

Add to your client

Copy the config for your MCP client and paste it into its config file.

Install / run

pip install hologres-mcp-server

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "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.

Step-by-step guides: Add to Claude Desktop · Add to Cursor · Add to Windsurf

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

About Hologres MCP Server

Official Alibaba Cloud MCP server for Hologres, a cloud-native real-time data warehouse. It exposes Hologres metadata and SQL execution to AI agents alongside a broad set of operational and diagnostic tools (query plans, slow-query and lock analysis, storage trends, warehouse and query-queue management, dynamic tables, recycle bin, MaxCompute foreign tables, and OSS file queries). Supports stdio, SSE, and Streamable HTTP transports.

Tools & capabilities (39)

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.

create_hg_maxcompute_foreign_table

Create MaxCompute foreign tables in the Hologres database.

list_hg_schemas

List all schemas in the current database, excluding system schemas.

list_hg_tables_in_a_schema

List all tables in a schema with their types (table, view, external, partitioned).

show_hg_table_ddl

Show the DDL script of a table, view, or external table.

query_and_plotly_chart

Run a SELECT query and generate a chart (bar/line/scatter/pie/histogram/area), returning results and a base64 PNG.

analyze_hg_query_by_id

Analyze a query's performance profile by query_id from hg_query_log (duration, memory, CPU, I/O).

get_hg_slow_queries

Get slow queries from hg_query_log ordered by duration.

list_hg_dynamic_tables

List all Dynamic Tables with status, freshness settings, and last-refresh info.

get_hg_dynamic_table_refresh_history

Get refresh history for a Dynamic Table (duration, status, latency).

list_hg_recyclebin

List all dropped tables in the recycle bin that can be restored.

restore_hg_table_from_recyclebin

Restore a dropped table from the recycle bin.

list_hg_warehouses

List all computing groups (warehouses) with CPU, memory, cluster count, and status.

switch_hg_warehouse

Switch the current session's computing resource to a specified warehouse.

get_hg_table_storage_size

Get storage size breakdown of a table (total, data, index, metadata).

cancel_hg_query

Cancel or terminate a running query by its process ID.

list_hg_active_queries

List active queries and connections from pg_stat_activity.

list_hg_query_queues

List Query Queues and their classifiers (concurrency limits, routing). Requires V3.0+.

get_hg_table_properties

Get table properties: distribution_key, clustering_key, segment_key, bitmap_columns, binlog settings, etc.

get_hg_table_shard_info

Get a table's Table Group and shard count for diagnosing data skew.

list_hg_external_databases

List External Databases and Foreign Servers for Lakehouse acceleration. Requires V3.0+.

get_hg_lock_diagnostics

Diagnose lock contention by showing blocking and waiting queries.

get_hg_table_info_trend

Get table storage trend from hg_table_info (daily size, file count, row count changes).

manage_hg_query_queue

Create, drop, or clear a Query Queue. Requires V3.0+ and superuser.

manage_hg_classifier

Create or drop a classifier for a Query Queue. Requires V3.0+.

set_hg_query_queue_property

Set or remove properties on a Query Queue or classifier. Requires V3.0+.

manage_hg_warehouse

Manage a computing group: suspend, resume, restart, rename, or resize. Requires superuser.

get_hg_warehouse_status

Get detailed running status and scaling progress of a computing group.

rebalance_hg_warehouse

Trigger shard rebalancing for a computing group to eliminate data skew.

list_hg_data_masking_rules

List data masking rules configured via the hg_anon extension (column- and user-level).

query_hg_external_files

Query files directly from OSS via EXTERNAL_FILES without creating foreign tables. Requires V4.1+.

get_hg_guc_config

Get the current value of a GUC (Grand Unified Configuration) parameter.

What this server can do

Hologres MCP Server provides tools for these capabilities — tap one to see every MCP server that does the same:

Execute SQL Inspect database schema

When to use it

Let an AI agent explore Hologres schemas, tables, and DDL, then run ad-hoc SELECT/DML/DDL queries
Diagnose performance: inspect query/execution plans, analyze slow queries, detect lock contention and data skew
Operate the warehouse: list, switch, suspend/resume/resize computing groups and rebalance shards
Manage query queues and classifiers for concurrency control and request routing
Track storage usage and trends, restore dropped tables from the recycle bin, and query OSS files or MaxCompute foreign tables

Security notes

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 FAQ

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.

Can the server modify data and infrastructure?

Yes — it can run DML/DDL and manage warehouses and query queues (some operations require superuser). Use a least-privilege Hologres account and restrict network access for HTTP deployments.

#hologres #alibaba-cloud #sql #database #olap #data-warehouse #maxcompute #analytics

Alternatives to Hologres MCP Server

Compare all alternatives →

MCP Toolbox for Databases (BigQuery)

Databases

16k

Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials.

Verified

stdio (local)

OAuth

10 tools

Updated 23 days agoRepo

InstantDB MCP

Databases

10k

Create, manage, and query your InstantDB apps, schemas, permissions, and data from your AI editor.

Unverified

HTTP (remote)

OAuth

TypeScript

7 tools

Updated 1 day agoRepo

DBHub

Databases

3.0k

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, and SQLite.

Unverified

stdio (local)

No auth

TypeScript

3 tools

Updated 1 day agoRepo

Compare Hologres MCP Server with:

vs MCP Toolbox for Databases (BigQuery)vs InstantDB MCP vs DBHub vs Postgres MCP Pro