Loading connector details…
Hologres MCP Server
MCPOfficialOpen SourceApache-2.040.5
by aliyun • Data & Databases
Connects AI Agents with Hologres databases for seamless SQL operations.
Example Use Cases
- 1
Retrieve and manage database metadata in Hologres
- 2
Execute SQL queries in Hologres databases
- 3
A seamless interface to interact with Hologres
Description
The Hologres MCP Server acts as a universal interface, facilitating easy communication and data operations between AI Agents and Hologres databases. It allows agents to retrieve metadata and execute SQL queries effortlessly. The server supports both local and PIP installation, making it versatile for different integration needs.
Capabilities(13 total)
Tools (12)
execute_hg_select_sql
Execute SELECT SQL to query data from Hologres database.
query:string*
execute_hg_select_sql_with_serverless
Use Serverless Computing resources to execute SELECT SQL to query data in Hologres database. When the error like "Total memory used by all existing queries exceeded memory limitation" occurs during execute_hg_select_sql execution, you can re-execute the SQL with the tool execute_hg_select_sql_with_serverless.
query:string*
execute_hg_dml_sql
Execute (INSERT, UPDATE, DELETE) SQL to insert, update, and delete data in Hologres databse.
query:string*
execute_hg_ddl_sql
Execute (CREATE, ALTER, DROP) SQL statements to CREATE, ALTER, or DROP tables, views, procedures, GUCs etc. in Hologres databse.
query:string*
gather_hg_table_statistics
Execute the ANALYZE TABLE command to have Hologres collect table statistics, enabling QO to generate better query plans
schema:string*table:string*
Resources (1)
All Schemas in Hologres database
Hologres is a PostgreSQL-compatible OLAP product. List all schemas in Hologres database
URI: hologres:///schemasMIME: text/plain
Quick Actions
Security
Scanned 3 month(s) agoRisk Level
MINIMAL
Read-only data retrieval, no side effects
Trust Score
C64/100
10/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities12 Tools / 0 Prompts / 1 Resources
Owneraliyun
CategoryData & Databases
DependenciesStandalone
Tags
DatabaseSQLMetadataInterface