by aliyun
Connect AI systems to Alibaba Cloud's Hologres for seamless data analysis using SQL, metadata, and statistics. AI for da
Connects AI systems to Alibaba Cloud Hologres databases for executing SQL queries and retrieving database metadata. Enables AI agents to analyze data stored in Hologres through a standardized interface.
Hologres is an official MCP server published by aliyun that provides AI assistants with tools and capabilities via the Model Context Protocol. Connect AI systems to Alibaba Cloud's Hologres for seamless data analysis using SQL, metadata, and statistics. AI for da It is categorized under databases.
You can install Hologres in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.
Apache-2.0
Hologres is released under the Apache-2.0 license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.
Enable Claude to query your database directly using natural language
Example
Ask 'Show me top 10 customers by revenue this month' and get SQL results instantly
Eliminate manual SQL writing for ad-hoc queries, get insights 10x faster
Generate complex reports and analytics without leaving conversation
Example
Analyze sales trends, cohort retention, user behavior patterns conversationally
Democratize data access—non-technical team members can query databases
Understand database structure, relationships, and data models
Example
'Explain the user_orders table schema and its relationships'
Onboard engineers faster, explore unfamiliar databases efficiently
Share your MCP server with the developer community
I recommend Hologres for teams standardizing on MCP; the explainx.ai page compares cleanly with sibling servers.
Hologres is among the better-indexed MCP projects we tried; the explainx.ai summary tracks the official description.
Strong directory entry: Hologres surfaces stars and publisher context so we could sanity-check maintenance before adopting.
According to our notes, Hologres benefits from clear Model Context Protocol framing — fewer ambiguous “AI plugin” claims.
Hologres is a well-scoped MCP server in the explainx.ai directory — install snippets and categories matched our Claude Code setup.
Hologres reduced integration guesswork — categories and install configs on the listing matched the upstream repo.
Hologres is among the better-indexed MCP projects we tried; the explainx.ai summary tracks the official description.
I recommend Hologres for teams standardizing on MCP; the explainx.ai page compares cleanly with sibling servers.
Hologres is among the better-indexed MCP projects we tried; the explainx.ai summary tracks the official description.
We wired Hologres into a staging workspace; the listing’s GitHub and npm pointers saved time versus hunting across READMEs.
showing 1-10 of 73
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
Run data quality queries to catch anomalies and inconsistencies
Example
Find duplicate records, missing values, orphaned foreign keys automatically
Maintain data integrity with less manual SQL work
Prerequisites
Time Estimate
15-30 minutes including configuration and testing
Steps
Troubleshooting
✓ Do
✗ Don't
💡 Pro Tips
Architecture
MCP server acts as bridge between Claude and database, translating natural language to SQL queries and returning results in structured format.
Protocols
Compatibility
✓ Use when
Use for ad-hoc data queries, exploratory analysis, report generation, schema exploration, and democratizing data access. Best for read-heavy analytics workloads.
✗ Avoid when
Avoid for production write operations, mission-critical transactions, real-time OLTP workloads, or when database contains sensitive PII without proper access controls. Use read replicas, not primary.