Hologres MCP Server

1. execute_hg_select_sql

Execute a SELECT SQL query in Hologres database.

2. execute_hg_select_sql_with_serverless

Execute a SELECT SQL query in Hologres database with serverless computing.

3. execute_hg_dml_sql

Execute a DML (INSERT, UPDATE, DELETE) SQL query in Hologres database.

4. execute_hg_ddl_sql

Execute a DDL (CREATE, ALTER, DROP, COMMENT ON) SQL query in Hologres database.

5. gather_hg_table_statistics

Collect table statistics in Hologres database.

6. get_hg_query_plan

Get query plan in Hologres database.

7. get_hg_execution_plan

Get execution plan in Hologres database.

8. call_hg_procedure

Invoke a procedure in Hologres database.

9. create_hg_maxcompute_foreign_table

Create MaxCompute foreign tables in Hologres database.

10. list_hg_schemas

Lists all schemas in the current Hologres database, excluding system schemas.

11. list_hg_tables_in_a_schema

Lists all tables in a specific schema, including their types (table, view, external table, partitioned table).

12. show_hg_table_ddl

Show the DDL script of a table, view, or external table in the Hologres database.

{
    "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"
            }
        }
    }
}