Hologres
About
Connect to a [Hologres](https://www.alibabacloud.com/en/product/hologres) instance, get table metadata, query and analyze data.
Details
- Author
- aliyun
- GitHub stars
- 34
- Downloads
- 282
- Categories
- Developer Tools, Database, Other
Jump to
- Execute SELECT, DML, and DDL SQL queries on Hologres
- Retrieve metadata: schemas, tables, views, external tables, DDL
- Collect table statistics and get query plans
- Analyze slow queries and active queries
- Manage dynamic tables, query queues, warehouses, and recycling bin
- Generate charts from query results (bar, line, scatter, pie, histogram, area)
- Access system information via resource templates
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
HologresCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Configure via an MCP client configuration file (e.g., using uv, uvx, or pip). Set environment variables (HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, HOLOGRES_DATABASE) and specify the command and arguments. Alternatively, use Streamable HTTP transport for remote deployment: start with hologres-mcp-server --transport streamable-http --host 0.0.0.0 --port 8000. Use with Claude Code via claude mcp add hologres-mcp-server.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"hologres": {
"alibabacloud-hologres-mcp-server": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
]
}
}
}
}McpServers
{
"alibabacloud-hologres-mcp-server": {
"command": "uvx",
"args": [
"hologres-mcp-server",
"--transport",
"streamable-http",
"--host",
"0.0.0.0",
"--port",
"8000"
]
}
}Hologres MCP Server
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.
Configuration
Mode 1: Using Local File
Download
Download from Github
git clone https://github.com/aliyun/alibabacloud-hologres-mcp-server.git
MCP Integration
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"
}
}
}
}
Mode 2: Using PIP Mode
Installation
Install MCP Server using the following package:
pip install hologres-mcp-server
MCP Integration
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"
}
}
}
}
{
"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"
}
}
}
}
Mode 3: Using Streamable HTTP Transport
The server supports Streamable HTTP transport for remote deployment scenarios where STDIO is not available.
Start the server
Before starting the server, set the Hologres connection environment variables:
export HOLOGRES_HOST="your-hologres-instance.hologres.aliyuncs.com"
export HOLOGRES_PORT="80"
export HOLOGRES_USER="your_access_id"
export HOLOGRES_PASSWORD="your_access_key"
export HOLOGRES_DATABASE="your_database"
Then start the server:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
