Loading connector details…
Hologres MCP Server
MCPOfficialOpen SourceApache-2.016.0
by spyfree • Data & Databases
Facilitates AI Agents' interaction with Hologres databases via a universal interface.
Example Use Cases
- 1
Execute SQL operations on Hologres databases
- 2
Retrieve and analyze Hologres database metadata
- 3
Flexible transport modes for database communication
Description
The Hologres MCP Server serves as a middleware, enabling AI Agents to seamlessly communicate with Hologres databases. It provides multiple transport modes, allowing for easy configuration and integration in various environments. Key features include database metadata access, SQL execution, and comprehensive statistics management, supporting flexible and efficient database operations.
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 2 month(s) agoRisk Level
MINIMAL
Read-only data retrieval, no side effects
Trust Score
C56/100
6/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
Ownerspyfree
CategoryData & Databases
DependenciesStandalone
Tags
SQLDatabasesMetadataTransport