MaxCompute
Alibaba cloud MaxCompute (ODPS) MCP server implemented by python
What is MaxCompute?
MaxCompute is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to alibaba cloud maxcompute (odps) mcp server implemented by python
Alibaba cloud MaxCompute (ODPS) MCP server implemented by python
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Alibaba cloud MaxCompute (ODPS) MCP server implemented by py
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx maxcomputeConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use MaxCompute
The MaxCompute MCP server is a Python implementation that gives Claude Desktop and other MCP clients direct access to Alibaba Cloud MaxCompute (formerly ODPS), a serverless big-data computing service. It provides four tools for listing tables, describing schemas, executing SELECT queries, and retrieving the latest partition identifier—enabling natural-language data exploration and analysis against MaxCompute projects without writing SQL manually.
Prerequisites
- An Alibaba Cloud account with a MaxCompute project provisioned
- Alibaba Cloud Access Key ID and Access Key Secret with MaxCompute read permissions
- The MaxCompute project name and regional endpoint URL (e.g., http://service.cn-hangzhou.maxcompute.aliyun.com/api)
- uv package manager installed (curl -LsSf https://astral.sh/uv/install.sh | sh)
- Python 3.8 or higher
Clone the repository
Clone the maxcompute-mcp-server repository from GitHub.
git clone https://github.com/datafe/maxcompute-mcp-server.git
cd maxcompute-mcp-serverInstall the package with uv
Use uv to install the server and its dependencies in an isolated environment.
uv pip install .
# Or build first:
uv buildGather your Alibaba Cloud credentials
Collect the four required configuration values from the Alibaba Cloud console: Access Key ID, Access Key Secret, MaxCompute project name, and the regional endpoint URL.
# Find your endpoint at:
# https://www.alibabacloud.com/help/en/maxcompute/user-guide/endpoints
# Example endpoint: http://service.cn-hangzhou.maxcompute.aliyun.com/apiAdd to Claude Desktop configuration
Register the server in your Claude Desktop config, passing Alibaba Cloud credentials as environment variables.
{
"mcpServers": {
"maxcompute": {
"command": "uv",
"args": ["run", "--with", "maxcompute-mcp-server", "maxcompute-mcp-server"],
"env": {
"ALIBABA_CLOUD_ACCESS_KEY_ID": "your_access_key_id",
"ALIBABA_CLOUD_ACCESS_KEY_SECRET": "your_access_key_secret",
"ALIBABA_CLOUD_MAXCOMPUTE_PROJECT": "your_project_name",
"ALIBABA_CLOUD_MAXCOMPUTE_ENDPOINT": "http://service.cn-hangzhou.maxcompute.aliyun.com/api"
}
}
}
}Restart Claude Desktop and verify
Restart Claude Desktop. Ask Claude to list the tables in your MaxCompute project to confirm the connection is working.
MaxCompute Examples
Client configuration
Claude Desktop configuration for the MaxCompute MCP server with Alibaba Cloud credentials.
{
"mcpServers": {
"maxcompute": {
"command": "uv",
"args": ["run", "--with", "maxcompute-mcp-server", "maxcompute-mcp-server"],
"env": {
"ALIBABA_CLOUD_ACCESS_KEY_ID": "your_access_key_id",
"ALIBABA_CLOUD_ACCESS_KEY_SECRET": "your_access_key_secret",
"ALIBABA_CLOUD_MAXCOMPUTE_PROJECT": "your_project_name",
"ALIBABA_CLOUD_MAXCOMPUTE_ENDPOINT": "http://service.cn-hangzhou.maxcompute.aliyun.com/api"
}
}
}
}Prompts to try
Natural-language prompts for querying Alibaba Cloud MaxCompute data.
- "List all tables in my MaxCompute project"
- "Describe the schema of the table 'orders'"
- "What is the latest partition in the 'events' table?"
- "Run a SELECT query to show the top 10 rows from the 'sales' table"
- "How many records were inserted into the 'user_activity' table yesterday?"
- "Query the 'products' table and count distinct SKUs per category"Troubleshooting MaxCompute
Authentication failure or AccessDenied error
Confirm your ALIBABA_CLOUD_ACCESS_KEY_ID and ALIBABA_CLOUD_ACCESS_KEY_SECRET are correct in the Alibaba Cloud RAM console. The access key user must have AliyunMaxComputeReadOnlyAccess or equivalent permissions on the target project.
Endpoint connection timeout
Verify you are using the correct regional endpoint for your MaxCompute project. Project and endpoint regions must match. Find the correct endpoint at https://www.alibabacloud.com/help/en/maxcompute/user-guide/endpoints.
uv run command fails to find maxcompute-mcp-server
Run 'uv pip install .' inside the cloned repository directory first, or use the 'uv run --directory /path/to/maxcompute-mcp-server maxcompute-mcp-server' form in the config with the correct absolute path.
Frequently Asked Questions about MaxCompute
What is MaxCompute?
MaxCompute is a Model Context Protocol (MCP) server that alibaba cloud maxcompute (odps) mcp server implemented by python It connects AI assistants to external tools and data sources through a standardized interface.
How do I install MaxCompute?
Follow the installation instructions on the MaxCompute GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with MaxCompute?
MaxCompute works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is MaxCompute free to use?
Yes, MaxCompute is open source and available under the Apache-2.0 license. You can use it freely in both personal and commercial projects.
MaxCompute Alternatives — Similar Databases Servers
Looking for alternatives to MaxCompute? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up MaxCompute in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use MaxCompute?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.