alibabacloud-hologres-mcp-server

alibabacloud-hologres-mcp-server

20
databases

Hologres MCP Server is designed to integrate AI Agents seamlessly with Hologres databases. It enables effective interaction by supporting SQL operations and metadata retrieval between AI Agents and the databases.

Hologres MCP Server

Hologres MCP Server acts as a universal interface between AI Agents and Hologres databases. It facilitates seamless communication, allowing AI Agents to retrieve metadata and execute SQL operations on Hologres databases.

Configuration

  • Mode 1: Using Local File
    • Download from GitHub.
    • Add configuration to the MCP client configuration file using 'uv' mode.
  • Mode 2: Using PIP Mode
    • Install via PIP.
    • Compatible with 'uv' and 'uvx' modes.

Components

Tools

  • Execute SQL queries such as SELECT, DML (INSERT, UPDATE, DELETE), DDL (CREATE, ALTER), and more.
  • Collect table statistics and obtain query execution plans.

Resources

  • Built-in and resource templates for accessing schemas, tables, and statistics in the Hologres database.