About MaxCompute MCP Server
A Python MCP server for Alibaba Cloud MaxCompute (ODPS). It lets MCP clients inspect project tables and schemas, retrieve the latest partition, and run read-only SELECT queries.
Key features
- 01List project tables
- 02Describe table schemas
- 03Get latest table partition
- 04Run SELECT queries
Use cases
- 01Inspect tables in a MaxCompute project
- 02Check a table's latest partition
- 03Read data with SELECT queries
MCP support
Exposes four tools to MCP clients for MaxCompute table and schema inspection, partition lookup, and SELECT-only querying.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEMaxCompute 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
- Code: GitHub
cd /path/to/maxcompute-mcp-server
uv pip install .
uv build
Usage with Cline
# 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"
}
}
}
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.