Hologres MCP Server

Official
by aliyun

Integrations

  • Enables downloading the Hologres MCP Server source code for local integration.

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/ - Get recent query log history with specified number of rows.
    • query_log/user// - Get query log history for a specific user with row limits.
    • query_log/application// - Get query log history for a specific application with row limits.
    • query_log/failed/<interval>/ - Get failed query log history with interval and specified number of rows.

Prompts

None at this time

You must be authenticated.

A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.

  1. Configuration
    1. Mode 1: Using Local File
    2. Mode 2: Using PIP Mode
  2. Components
    1. Tools
    2. Resources
    3. Prompts

Related MCP Servers

  • A
    security
    A
    license
    A
    quality
    Allows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
    Last updated -
    1
    360
    Python
    MIT License
    • Linux
    • Apple
  • -
    security
    F
    license
    -
    quality
    Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.
    Last updated -
    9
    JavaScript
    • Apple
  • -
    security
    F
    license
    -
    quality
    Enables AI assistants to interact with Metabase, providing access to dashboards, questions, databases, and tools for executing queries and viewing data through natural language.
    Last updated -
    JavaScript
    • Apple
  • A
    security
    A
    license
    A
    quality
    Acts as a bridge between AI assistants and StarRocks databases, allowing for direct SQL execution and database exploration without requiring complex setup or configuration.
    Last updated -
    5
    20
    Python
    Apache 2.0

View all related MCP servers

ID: rds5y1z8q6