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 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:
Prompts
None at this time
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 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:
Prompts
None at this time