Maxcompute Mcp Server
What is Maxcompute Mcp Server
maxcompute-mcp-server is a Model Context Protocol (MCP) server implemented in Python for Alibaba Cloud’s MaxCompute (ODPS), facilitating interaction with MaxCompute projects.
Use cases
Use cases include executing SQL queries on large datasets, managing table schemas, and automating data retrieval processes within MaxCompute projects.
How to use
To use maxcompute-mcp-server, install it from source using pip, and configure it in your cline_mcp_settings.json file with necessary environment variables such as ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_MAXCOMPUTE_PROJECT.
Key features
Key features include query tools for executing SELECT queries and retrieving the latest partition names, as well as schema tools for listing tables and describing table structures.
Where to use
maxcompute-mcp-server is used in data analytics, big data processing, and cloud computing environments, particularly for projects utilizing Alibaba Cloud’s MaxCompute service.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Maxcompute Mcp Server
maxcompute-mcp-server is a Model Context Protocol (MCP) server implemented in Python for Alibaba Cloud’s MaxCompute (ODPS), facilitating interaction with MaxCompute projects.
Use cases
Use cases include executing SQL queries on large datasets, managing table schemas, and automating data retrieval processes within MaxCompute projects.
How to use
To use maxcompute-mcp-server, install it from source using pip, and configure it in your cline_mcp_settings.json file with necessary environment variables such as ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_MAXCOMPUTE_PROJECT.
Key features
Key features include query tools for executing SELECT queries and retrieving the latest partition names, as well as schema tools for listing tables and describing table structures.
Where to use
maxcompute-mcp-server is used in data analytics, big data processing, and cloud computing environments, particularly for projects utilizing Alibaba Cloud’s MaxCompute service.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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
- 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"
}
}
}
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
