Hologres MCP
A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.
What is Hologres MCP?
Hologres MCP is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to universal interface that enables ai agents to communicate with hologres databases, allowing them to retrieve database metadata and execute sql operations.
A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- A universal interface that enables AI Agents to communicate
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx hologres-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Hologres MCP
The Hologres MCP server is an official Alibaba Cloud integration that enables AI agents to communicate directly with Hologres — Alibaba's cloud-native real-time data warehouse — to retrieve schema metadata, execute SQL operations, analyse query performance, manage warehouses, and generate data visualisations. It exposes a comprehensive set of tools covering DDL, DML, SELECT queries, slow-query diagnostics, lock detection, and even Plotly chart generation from query results. Data engineers and analysts use it to explore and operate Hologres databases through natural-language conversations without writing raw SQL manually.
Prerequisites
- A Hologres instance on Alibaba Cloud with connection credentials
- Python 3.10+ and pip or uvx installed
- Your Hologres host, port, database name, access ID (user), and access key (password)
- An MCP client such as Claude Desktop, Claude Code, or Cursor
Install the Hologres MCP server
Install the package from PyPI using pip or use uvx for an isolated run without a permanent install.
pip install hologres-mcp-serverGather your Hologres connection details
From the Alibaba Cloud Hologres console, collect the instance endpoint (HOLOGRES_HOST), port (HOLOGRES_PORT), database name (HOLOGRES_DATABASE), your AccessKey ID (HOLOGRES_USER), and AccessKey secret (HOLOGRES_PASSWORD).
Add the server to your MCP client configuration
Configure your MCP client to launch the server via uvx and inject the connection credentials as environment variables.
{
"mcpServers": {
"hologres-mcp-server": {
"command": "uvx",
"args": ["hologres-mcp-server"],
"env": {
"HOLOGRES_HOST": "your-instance.hologres.aliyuncs.com",
"HOLOGRES_PORT": "80",
"HOLOGRES_USER": "your_access_id",
"HOLOGRES_PASSWORD": "your_access_key",
"HOLOGRES_DATABASE": "your_database"
}
}
}
}Connect via Claude Code CLI (alternative)
If you use Claude Code, you can add the server in one command using the 'claude mcp add' subcommand with environment variable flags.
claude mcp add hologres-mcp-server \
-e HOLOGRES_HOST=your-instance.hologres.aliyuncs.com \
-e HOLOGRES_PORT=80 \
-e HOLOGRES_USER=your_access_id \
-e HOLOGRES_PASSWORD=your_access_key \
-e HOLOGRES_DATABASE=your_database \
-- uvx hologres-mcp-serverTest the connection
Ask your AI assistant to list all schemas in the database. If the server is connected correctly, it will call list_hg_schemas and return the schema names.
Hologres MCP Examples
Client configuration
Full MCP client config for Hologres using uvx. All five connection environment variables are required.
{
"mcpServers": {
"hologres-mcp-server": {
"command": "uvx",
"args": ["hologres-mcp-server"],
"env": {
"HOLOGRES_HOST": "your-instance.hologres.aliyuncs.com",
"HOLOGRES_PORT": "80",
"HOLOGRES_USER": "your_access_id",
"HOLOGRES_PASSWORD": "your_access_key",
"HOLOGRES_DATABASE": "your_database"
}
}
}
}Prompts to try
Use these prompts to explore your Hologres database, run queries, diagnose performance issues, and generate charts.
- "List all schemas in my Hologres database and describe each one"
- "Show me the DDL for the orders table in the public schema"
- "Run this SELECT and generate a bar chart of monthly revenue: SELECT DATE_TRUNC('month', created_at), SUM(amount) FROM orders GROUP BY 1 ORDER BY 1"
- "Find the 5 slowest queries from the last 24 hours and suggest optimisations"
- "Gather table statistics for the customer_events table and tell me if it needs a vacuum"Troubleshooting Hologres MCP
Connection refused or timeout when starting the server
Verify that HOLOGRES_HOST and HOLOGRES_PORT are correct and that your IP address is whitelisted in the Hologres instance's security group on Alibaba Cloud. Hologres instances default to port 80.
Authentication failed (invalid AccessKey)
Ensure HOLOGRES_USER contains the AccessKey ID (not your Alibaba Cloud account name) and HOLOGRES_PASSWORD contains the AccessKey secret. Generate a new AccessKey pair from the Alibaba Cloud RAM console if needed.
uvx command not found
Install uv first: 'pip install uv' or 'brew install uv' on macOS. uvx is included with uv and allows running Python packages in temporary isolated environments.
Frequently Asked Questions about Hologres MCP
What is Hologres MCP?
Hologres MCP is a Model Context Protocol (MCP) server that universal interface that enables ai agents to communicate with hologres databases, allowing them to retrieve database metadata and execute sql operations. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Hologres MCP?
Follow the installation instructions on the Hologres MCP GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Hologres MCP?
Hologres MCP works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Hologres MCP free to use?
Yes, Hologres MCP is open source and available under the Apache 2.0 license. You can use it freely in both personal and commercial projects.
Hologres MCP Alternatives — Similar Databases Servers
Looking for alternatives to Hologres MCP? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Hologres MCP in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Hologres MCP?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.