Hologres

Hologres

Connect to a Hologres instance, get table metadata, query and analyze data.

24
Stars
12
Forks
0
Releases

Overview

Hologres MCP Server serves as a universal interface between AI Agents and Hologres databases, enabling seamless communication and enabling AI agents to retrieve Hologres metadata and execute SQL operations. It supports two deployment modes: Local File mode and Python Package (PIP) mode. In Local File mode, you clone the repository and configure the MCP client to run via uv, providing connection details through environment variables HOLOGRES_HOST, HOLOGRES_PORT, HOLOGRES_USER, HOLOGRES_PASSWORD, and HOLOGRES_DATABASE. In PIP mode, install hologres-mcp-server and configure the MCP client either with uv (run hologres-mcp-server) or uvx mode, using the same environment variables. The MCP Server exposes a suite of tools to perform common database tasks, including executing SELECT, DML, and DDL statements, gathering table statistics, obtaining query and execution plans, and invoking procedures. It also provides metadata access helpers and resource templates to discover schemas, tables, DDL, and statistics, along with system paths for runtime information. This design enables AI agents to work with Hologres data without direct database access while retaining rich capabilities for exploration and analysis.

Details

Owner
aliyun
Language
Python
License
Apache License 2.0
Updated
2025-12-07

Features

execute_hg_select_sql

Execute a SELECT SQL query in Hologres database

execute_hg_select_sql_with_serverless

Execute a SELECT SQL query in Hologres database with serverless computing

execute_hg_dml_sql

Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database

execute_hg_ddl_sql

Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database

gather_hg_table_statistics

Collect table statistics in Hologres database

get_hg_query_plan

Get query plan in Hologres database

get_hg_execution_plan

Get execution plan in Hologres database

call_hg_procedure

Invoke a procedure in Hologres database

Audience

AI agentsEnable AI agents to retrieve Hologres metadata and execute SQL operations via MCP.

Tags

HologresMCPAISQLmetadatadatabaseserverintegration