Hologres
Connect to a Hologres instance, get table metadata, query and analyze data.
Ads
Overview
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. Add the following configuration to the MCP client configuration file: Install MCP Server using the following package: Add the following configuration to the MCP client configuration file: The server supports Streamable HTTP transport for remote deployment scenarios where STDIO is not available.
Installation
pip install hologres-mcp-server
Configuration
{
"mcpServers": {
"hologres-mcp-server": {
"command": "uv",
"args": [
"--directory",
"/path/to/alibabacloud-hologres-mcp-server",
"run",
"hologres-mcp-server"
],
"env": {
"HOLOGRES_HOST": "host",
"HOLOGRES_PORT": "port",
"HOLOGRES_USER": "access_id",
"HOLOGRES_PASSWORD": "access_key",
"HOLOGRES_DATABASE": "database"
}
}Capabilities
- List schemas and tables
Ask the AI to explore your database structure using `list_hg_schemas`, `list_hg_tables_in_a_schema`, and `show_hg_table_ddl`.
- Run read-only queries
Execute SELECT statements via `execute_hg_select_sql` or `execute_hg_select_sql_with_serverless` and optionally chart results with `query_and_plotly_chart`.
- Manage database objects
Create, alter, or drop tables and other objects through `execute_hg_ddl_sql`, and run INSERT/UPDATE/DELETE operations with `execute_hg_dml_sql`.
- Diagnose query performance
Retrieve query plans (`get_hg_query_plan`, `get_hg_execution_plan`), analyze specific queries by ID, and identify slow queries with `get_hg_slow_queries`.
- Inspect and manage compute resources
List warehouses with `list_hg_warehouses`, switch sessions via `switch_hg_warehouse`, and manage warehouse lifecycle using `manage_hg_warehouse`.
- Recover dropped tables
View the recycle bin contents with `list_hg_recyclebin` and restore accidentally dropped tables using `restore_hg_table_from_recyclebin`.
Tags
- database
Related MCP servers
InstantDB
OfficialCreate, manage, and update applications on InstantDB, the modern Firebase.
Jitsu
OfficialManage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.
PostgreSQL MCP Server
OfficialRun read-only SQL queries and inspect PostgreSQL schemas from your MCP client.
Financial Datasets
OfficialStock market API made for AI agents