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_select_sql
: Execute a SELECT SQL query on the Hologres serverexecute_dml_sql
: Execute a DML (INSERT, UPDATE, DELETE) SQL query on the Hologres serverexecute_ddl_sql
: Execute a DDL (CREATE, ALTER, DROP) SQL query on the Hologres servergather_table_statistics
: 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}/partitions
: List all partitions of a partitioned tablehologres:///{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.
- 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.
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.
Tools
A universal interface that enables AI Agents to communicate with Hologres databases, allowing them to retrieve database metadata and execute SQL operations.
Related MCP Servers
- AsecurityAlicenseAqualityAllows 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 -1360PythonMIT License
- -securityFlicense-qualityEnables 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 -9JavaScript
- -securityFlicense-qualityEnables 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
StarRocks MCP Serverofficial
AsecurityAlicenseAqualityActs 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 -520PythonApache 2.0