MaxCompute MCP Server

Overview

A Model Context Protocol (MCP) server for MaxCompute.

Related MCP server: getdot-database-skills

Components

Tools

The server offers 4 core tools:

Query Tools

• get_latest_partition

  • Get the latest partition name for a specific table

  • Input:

    • table_name (string): Name of the table

  • Returns: The latest partition name

• read_query

  • Execute a SELECT query on the MaxCompute project, only SELECT query is allowed

  • Input:

    • query (string): The SELECT SQL query

  • Returns: Query results as array of objects

Schema Tools

• list_tables

  • List all tables in the MaxCompute project

  • No input required

  • Returns: Array of table objects with name and comment

• describe_table

  • Get the schema information for a specific table

  • Input:

    • table_name (string): Name of the table

  • Returns: Raw output of DESC command

Build from source

• Code: GitHub

cd /path/to/maxcompute-mcp-server
uv pip install .
uv build

Usage with Cline

• maxcompute endpoints can view in endpoint

• maxcompute projects can view in projects

# Add the server to your cline_mcp_settings.json
"mcpServers": {
  "maxcompute-mcp-server": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "maxcompute-mcp-server",
      "maxcompute-mcp-server"
    ],
    "env": {
      "ALIBABA_CLOUD_ACCESS_KEY_ID": "",
      "ALIBABA_CLOUD_ACCESS_KEY_SECRET": "",
      "ALIBABA_CLOUD_MAXCOMPUTE_PROJECT": "",
      "ALIBABA_CLOUD_MAXCOMPUTE_ENDPOINT": "https://service.cn-shanghai.maxcompute.aliyun.com/api"
    }
  }
}