Skip to main content

A MCP server for MaxCompute(tapdb revised)

Project description

MaxCompute MCP Server

本项目是基于阿里云的MCP的修改版,对业务进行了加固以及迭代
阿里云项目地址: https://github.com/datafe/maxcompute-mcp-server
主要修改:
1. 增加了sqlglot的依赖,实现对sql的专业化解析和处理,而不是简单的字符串查找
2. 移除了describe_table这个tool。实际上AI是完全自己能知道使用desc来获得表描述,
   这个方法有点多此一举。
3. 相应的readme文案调整   

Overview

A Model Context Protocol (MCP) server for MaxCompute.

Components

Tools

The server offers 3 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 read-only query on the MaxCompute project, such as SELECT or DESC query is allowed.
    • Input:
      • query (string): The read only SQL query
      • save_file_path (string,opitional): local file that save the query results as json list
    • 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

Build from source

cd /path/to/tapdb-maxcompute-mcp
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": {
  "tapdb-maxcompute-mcp": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "tapdb-maxcompute-mcp",
      "tapdb-maxcompute-mcp"
    ],
    "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"
    }
  }
}

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

tapdb_maxcompute_mcp-0.1.9.tar.gz (55.5 MB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

tapdb_maxcompute_mcp-0.1.9-py3-none-any.whl (9.3 kB view details)

Uploaded Python 3

File details

Details for the file tapdb_maxcompute_mcp-0.1.9.tar.gz.

File metadata

  • Download URL: tapdb_maxcompute_mcp-0.1.9.tar.gz
  • Upload date:
  • Size: 55.5 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.11

File hashes

Hashes for tapdb_maxcompute_mcp-0.1.9.tar.gz
Algorithm Hash digest
SHA256 b36bbfad60feed4bbc06ac937566988ef492a6dd1aab235c24c0fb0b9e8370c5
MD5 bc810b67f70a60c65ce51e31ba3e8d5d
BLAKE2b-256 ba3c9298942e646463f5418cce5e002fe85c7c1d2d15810681ea9b9826556fd1

See more details on using hashes here.

File details

Details for the file tapdb_maxcompute_mcp-0.1.9-py3-none-any.whl.

File metadata

File hashes

Hashes for tapdb_maxcompute_mcp-0.1.9-py3-none-any.whl
Algorithm Hash digest
SHA256 90502d72a5881d4fbc368896a9750db655c7d104fe689deba2ac122340428d21
MD5 2626455630eaea9cc9986c4eac2e926c
BLAKE2b-256 d5ed323b9eb38c34f7d2b85c66be2b27f1a6f099edc91d2245db675ff47edbd8

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page