maxcompute-mcp-server

maxcompute-mcp-server

1
databases

The MaxCompute MCP Server is designed to interface with MaxCompute, providing tools for querying data and managing schemas. It focuses on SELECT queries and listing or describing tables within a MaxCompute project.

MaxCompute MCP Server

Overview

A Model Context Protocol (MCP) server for MaxCompute.

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

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