Hologres

official

Connect to a [Hologres](https://www.alibabacloud.com/en/product/hologres) instance, get table metadata, query and analyze data.

Source Code

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:

"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"
      }
    }
  }

Components

Tools

```
execute_select_sql
```
: Execute a SELECT SQL query on the Hologres server
```
execute_dml_sql
```
: Execute a DML (INSERT, UPDATE, DELETE) SQL query on the Hologres server
```
execute_ddl_sql
```
: Execute a DDL (CREATE, ALTER, DROP) SQL query on the Hologres server
```
gather_table_statistics
```
: Collect table statistics
```
get_query_plan
```
: Get query plan
```
get_execution_plan
```
: Get execution plan

Resources

Built-in Resources

```
hologres:///schemas
```
: Get all schemas in the database

Resource Templates

```
hologres:///{schema}/tables
```
: List all tables in a schema
```
hologres:///{schema}/{table}/partitions
```
: List all partitions of a partitioned table
```
hologres:///{schema}/{table}/ddl
```
: Get table DDL
```
hologres:///{schema}/{table}/statistic
```
: Show collected table statistics
```
system:///{+system_path}
```
: System paths include:
- 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.

Prompts

None at this time

Related Servers

Brave Search

reference

Web and local search using Brave's Search API

View Details

Git

reference

Tools to read, search, and manipulate Git repositories

View Details

Google Drive

reference

File access and search capabilities for Google Drive

View Details

Aiven

official

Navigate your [Aiven projects](https://go.aiven.io/mcp-server) and interact with the PostgreSQL®, Apache Kafka®, ClickHouse® and OpenSearch® services

View Details

Apify

official

[Actors MCP Server](https://apify.com/apify/actors-mcp-server): Use 3,000+ pre-built cloud tools to extract data from websites, e-commerce, social media, search engines, maps, and more

View Details