Hologres MCP Server

Official
by aliyun

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
HOLOGRES_HOSTYesHologres server host
HOLOGRES_PORTYesHologres server port
HOLOGRES_USERYesHologres access ID/username
HOLOGRES_DATABASEYesHologres database name
HOLOGRES_PASSWORDYesHologres access key/password

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
All SchemasHologres is a PostgreSQL-compatible OLAP product. List all schemas in Hologres database

Tools

Functions exposed to the LLM to take actions

NameDescription
execute_select_sql

Execute SELECT SQL to query data from Hologres database.

execute_dml_sql

Execute (INSERT, UPDATE, DELETE) SQL to insert, update, and delete data in Hologres databse.

execute_ddl_sql

Execute (CREATE, ALTER, DROP) SQL statements to CREATE, ALTER, or DROP tables, views, procedures, GUCs etc. in Hologres databse.

gather_table_statistics

Execute the ANALYZE TABLE command to have Hologres collect table statistics, enabling QO to generate better query plans

get_query_plan

Get query plan for a SQL query

get_execution_plan

Get actual execution plan with runtime statistics for a SQL query

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/aliyun/alibabacloud-hologres-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server