by aliyun
Provides a universal interface for AI agents to retrieve Hologres metadata and execute SQL operations directly against Hologres databases.
Hologres MCP Server acts as a bridge between AI agents and Hologres databases, enabling agents to query schema information, run SELECT/DML/DDL statements, gather statistics, retrieve execution plans, and invoke stored procedures without needing direct database credentials.
uv
or uvx
.pip install hologres-mcp-server
and launch via uv
.HOLOGRES_HOST
, HOLOGRES_PORT
, HOLOGRES_USER
, HOLOGRES_PASSWORD
, HOLOGRES_DATABASE
).execute_hg_select_sql
, list_hg_schemas
) or use built‑in resource URIs (e.g., hologres:///schemas
).uv run hologres-mcp-server
; in pip mode you can also use uvx hologres-mcp-server
.execute_hg_select_sql_with_serverless
leverages Hologres serverless computing.hologres:///{schema}/tables
or system paths such as system:///stat_activity
.create_hg_maxcompute_foreign_table
tool enables this integration.English | 中文
Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases. It enables seamless communication between AI Agents and Hologres, helping AI Agents retrieve Hologres database metadata and execute SQL operations.
Download from Github
git clone https://github.com/aliyun/alibabacloud-hologres-mcp-server.git
Add the following configuration to the MCP client configuration file:
{
"mcpServers": {
"hologres-mcp-server": {
"command": "uv",
"args": [
"--directory",
"/path/to/alibabacloud-hologres-mcp-server",
"run",
"hologres-mcp-server"
],
"env": {
"HOLOGRES_HOST": "host",
"HOLOGRES_PORT": "port",
"HOLOGRES_USER": "access_id",
"HOLOGRES_PASSWORD": "access_key",
"HOLOGRES_DATABASE": "database"
}
}
}
}
Install MCP Server using the following package:
pip install hologres-mcp-server
Add the following configuration to the MCP client configuration file:
Use uv mode
{
"mcpServers": {
"hologres-mcp-server": {
"command": "uv",
"args": [
"run",
"--with",
"hologres-mcp-server",
"hologres-mcp-server"
],
"env": {
"HOLOGRES_HOST": "host",
"HOLOGRES_PORT": "port",
"HOLOGRES_USER": "access_id",
"HOLOGRES_PASSWORD": "access_key",
"HOLOGRES_DATABASE": "database"
}
}
}
}
Use uvx mode
{
"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"
}
}
}
}
execute_hg_select_sql
: Execute a SELECT SQL query in Hologres databaseexecute_hg_select_sql_with_serverless
: Execute a SELECT SQL query in Hologres database with serverless computingexecute_hg_dml_sql
: Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres databaseexecute_hg_ddl_sql
: Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres databasegather_hg_table_statistics
: Collect table statistics in Hologres databaseget_hg_query_plan
: Get query plan in Hologres databaseget_hg_execution_plan
: Get execution plan in Hologres databasecall_hg_procedure
: Invoke a procedure in Hologres databasecreate_hg_maxcompute_foreign_table
: Create MaxCompute foreign tables in Hologres database.Since some Agents do not support resources and resource templates, the following tools are provided to obtain the metadata of schemas, tables, views, and external tables.
list_hg_schemas
: Lists all schemas in the current Hologres database, excluding system schemas.list_hg_tables_in_a_schema
: Lists all tables in a specific schema, including their types (table, view, external table, partitioned table).show_hg_table_ddl
: Show the DDL script of a table, view, or external table in the Hologres database.hologres:///schemas
: Get all schemas in Hologres databasehologres:///{schema}/tables
: List all tables in a schema in Hologres database
hologres:///{schema}/{table}/partitions
: List all partitions of a partitioned table in Hologres database
hologres:///{schema}/{table}/ddl
: Get table DDL in Hologres database
hologres:///{schema}/{table}/statistic
: Show collected table statistics in Hologres database
system:///{+system_path}
:
System paths include:
hg_instance_version
- Shows the hologres instance version.guc_value/<guc_name>
- Shows the guc (Grand Unified Configuration) value.missing_stats_tables
- Shows the tables that are missing statistics.stat_activity
- Shows the information of current running queries.query_log/latest/<row_limits>
- Get recent query log history with specified number of rows.query_log/user/<user_name>/<row_limits>
- Get query log history for a specific user with row limits.query_log/application/<application_name>/<row_limits>
- Get query log history for a specific application with row limits.query_log/failed/<interval>/<row_limits>
- Get failed query log history with interval and specified number of rows.None at this time
Please log in to share your review and rating for this MCP.
{ "mcpServers": { "hologres-mcp-server": { "command": "uv", "args": [ "run", "--with", "hologres-mcp-server", "hologres-mcp-server" ], "env": { "HOLOGRES_HOST": "<HOST>", "HOLOGRES_PORT": "<PORT>", "HOLOGRES_USER": "<ACCESS_ID>", "HOLOGRES_PASSWORD": "<ACCESS_KEY>", "HOLOGRES_DATABASE": "<DATABASE>" } } } }
Discover more MCP servers with similar functionality and use cases
by googleapis
Provides a configurable MCP server that abstracts connection pooling, authentication, observability, and tool management to accelerate development of database‑backed AI tools.
by bytebase
DBHub is a universal database gateway that implements the Model Context Protocol (MCP) server interface, enabling MCP-compatible clients to interact with various databases.
by neo4j-contrib
Provides Model Context Protocol servers for interacting with Neo4j databases, managing Aura instances, and handling personal knowledge graph memory through natural‑language interfaces.
by mongodb-js
Provides a Model Context Protocol server that connects to MongoDB databases and Atlas clusters, exposing a rich set of tools for querying, managing, and administering data and infrastructure.
by benborla
A Model Context Protocol (MCP) server that provides read-only access to MySQL databases, enabling Large Language Models (LLMs) to inspect database schemas and execute read-only queries.
by ClickHouse
Provides tools that let AI assistants run read‑only SQL queries against ClickHouse clusters or the embedded chDB engine, plus a health‑check endpoint for service monitoring.
by elastic
Provides direct, natural‑language access to Elasticsearch indices via the Model Context Protocol, allowing AI agents to query and explore data without writing DSL.
by motherduckdb
Provides an MCP server that enables SQL analytics on DuckDB and MotherDuck databases, allowing AI assistants and IDEs to execute queries via a unified interface.
by redis
Provides a natural language interface for agentic applications to manage and search data in Redis efficiently.