{"type":"mcp_server","name":"alibabacloud-hologres-mcp-server","description":"The Hologres MCP Server provides a universal interface for AI Agents to interact with Hologres databases, enabling metadata retrieval and SQL operation execution. It supports local file and PIP installation modes.","category":"Database","language":"Python","stars":33,"forks":1,"owner":"aliyun","github_url":"https://github.com/aliyun/alibabacloud-hologres-mcp-server","homepage":null,"setup":"## Setup\n\n**Mode 1: Using Local File**\n\n1.  Download from Github:\n\n    ```shell\n    git clone https://github.com/aliyun/alibabacloud-hologres-mcp-server.git\n    ```\n\n2.  MCP Integration: Add the following configuration to the MCP client configuration file:\n\n    ```json\n    \"mcpServers\": {\n      \"hologres-mcp-server\": {\n        \"command\": \"uv\",\n        \"args\": [\n          \"--directory\",\n          \"/path/to/alibabacloud-hologres-mcp-server\",\n          \"run\",\n          \"hologres-mcp-server\"\n        ],\n        \"env\": {\n          \"HOLOGRES_HOST\": \"host\",\n          \"HOLOGRES_PORT\": \"port\",\n          \"HOLOGRES_USER\": \"access_id\",\n          \"HOLOGRES_PASSWORD\": \"access_key\",\n          \"HOLOGRES_DATABASE\": \"database\"\n        }\n      }\n    }\n    ```\n\n**Mode 2: Using PIP Mode**\n\n1.  Installation: Install MCP Server using the following package:\n\n    ```bash\n    pip install hologres-mcp-server\n    ```\n\n2.  MCP Integration: Add the following configuration to the MCP client configuration file:\n\n    ```json\n      \"mcpServers\": {\n        \"hologres-mcp-server\": {\n          \"command\": \"uv\",\n          \"args\": [\n            \"run\",\n            \"--with\",\n            \"hologres-mcp-server\",\n            \"hologres-mcp-server\"\n          ],\n          \"env\": {\n            \"HOLOGRES_HOST\": \"host\",\n            \"HOLOGRES_PORT\": \"port\",\n            \"HOLOGRES_USER\": \"access_id\",\n            \"HOLOGRES_PASSWORD\": \"access_key\",\n            \"HOLOGRES_DATABASE\": \"database\"\n          }\n        }\n      }\n    ```","tools":"## Available Tools\n\n1.  `execute_sql` (Execute queries in Hologres)\n2.  `analyze_table` (Collect table statistics)\n3.  `get_query_plan` (Get query plan)\n4.  `get_execution_plan` (Get execution plan)\n","faq":null,"created_at":"2025-03-20T03:30:27+00:00","updated_at":"2025-03-27T02:05:23+00:00","source_url":"https://model-context-protocol.com/servers/hologres-ai-agent-database-interaction-server","related_articles":[]}