Hologres MCP Server
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.
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
MCP Integration
Add the following configuration to the MCP client configuration file:
Mode 2: Using PIP Mode
Installation
Install MCP Server using the following package:
MCP Integration
Add the following configuration to the MCP client configuration file:
Components
Tools
execute_sql
: Execute queries in Hologresanalyze_table
: Collect table statisticsget_query_plan
: Get query planget_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 schemahologres:///{schema}/{table}/ddl
: Get table DDLhologres:///{schema}/{table}/statistic
: Show collected table statisticssystem:///{+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.
Prompts
None at this time
This server cannot be installed
A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.