← 返回 Skills 市场
309
总下载
0
收藏
0
当前安装
2
版本数
在 OpenClaw 中安装
/install odps-sql
功能描述
Use this skill when the user wants to query, analyze, or explore data in Alibaba Cloud ODPS (MaxCompute / 阿里云大数据计算服务). This skill executes SQL queries, lists...
安全使用建议
This skill appears to do what it says (run queries against Alibaba ODPS) but the declared env variable names in the skill metadata and config template do not match the env names the included Python script actually reads. Before installing or handing over real credentials:
- Inspect scripts/odps_helper.py and decide which env var naming you want to use. Either: (a) set the env vars the script expects (ALIYUN_ACCESS_KEY_ID, ALIYUN_ACCESS_KEY_SECRET, ALIYUN_ODPS_PROJECT, ALIYUN_ODPS_ENDPOINT), or (b) edit the script to read the env names from config.example.env / SKILL.md (or update the .env).
- Use a dedicated, least-privilege Alibaba key (read-only / limited to the specific project) when testing. Never reuse high-privilege keys.
- Test the script locally in an isolated virtualenv and verify it connects to the expected ODPS endpoint before using it in production.
- Do not commit the filled .env to source control; follow the README note. Rotate keys if you accidentally exposed them.
If you want higher assurance, ask the skill author to reconcile the env var naming and update SKILL.md/config.example.env to match the script (or vice versa) and to provide a short test run log demonstrating a successful connection using a non-sensitive test account.
功能分析
Type: OpenClaw Skill
Name: odps-sql
Version: 1.0.1
The skill bundle is a legitimate tool for interacting with Alibaba Cloud ODPS (MaxCompute). The core logic in `scripts/odps_helper.py` uses the official `pyodps` library to perform data exploration tasks like listing tables and executing SQL queries as described in `SKILL.md`. While there is a minor configuration discrepancy (environment variable names differ slightly between the script and the documentation), there is no evidence of malicious intent, data exfiltration, or unauthorized access.
能力评估
Purpose & Capability
The skill's name, description, and provided scripts all consistently target Alibaba Cloud ODPS (MaxCompute) and require Alibaba credentials — that is appropriate for the stated purpose. However, the registry/SKILL.md declares env var names (ALIYUN_ACCESS_ID, ALIYUN_ACCESS_SECRET, ALIYUN_PROJECT_NAME, ALIYUN_END_POINT) and the config.example.env uses those names, while the runnable script (scripts/odps_helper.py) expects different env var names (ALIYUN_ACCESS_KEY_ID, ALIYUN_ACCESS_KEY_SECRET, ALIYUN_ODPS_PROJECT, ALIYUN_ODPS_ENDPOINT). This mismatch is an incoherence between the declared requirements and the code the skill will actually run.
Instruction Scope
SKILL.md provides a focused, limited workflow: create a .env with credentials, install pyodps, and run the helper script to list tables, describe schemas, or execute queries. The instructions do not request unrelated files or secrets and emphasize partition filters / limits to avoid full scans. The script loads a .env from the current working directory or the skill parent dir and only accesses ODPS via the pyodps library. No external endpoints beyond ODPS are contacted. The main concern is that following the SKILL.md as-written may still fail because of the env-name mismatch.
Install Mechanism
No automated install spec is provided (instruction-only install). The README instructs the user to pip install pyodps; this is a standard, low-risk dependency installation step and there are no archive downloads or arbitrary remote installs embedded in the skill package.
Credentials
The set of required environment variables (Alibaba Cloud access key/secret, project, endpoint) is proportionate for a tool that connects to ODPS. However the declared/advertised env var names differ from the names the script actually reads. Registry and config.example.env use ALIYUN_ACCESS_ID / ALIYUN_ACCESS_SECRET / ALIYUN_PROJECT_NAME / ALIYUN_END_POINT, while the script expects ALIYUN_ACCESS_KEY_ID / ALIYUN_ACCESS_KEY_SECRET / ALIYUN_ODPS_PROJECT / ALIYUN_ODPS_ENDPOINT. This mismatch can cause the script to report missing credentials even when the user has filled the .env per instructions, increasing the chance of confusion and accidental credential mishandling.
Persistence & Privilege
The skill does not request persistent special privileges; always:false and default model invocation settings are used. The skill is instruction-only with no install-time changes to system-wide config. It reads a .env file and environment variables but does not attempt to modify other skills or system configuration.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install odps-sql - 安装完成后，直接呼叫该 Skill 的名称或使用
/odps-sql触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.1
- Switched references from "skill/" to "mcp-odps/" throughout setup, script paths, and documentation.
- Added metadata section specifying required binaries and environment variables for integration.
- Updated example paths in setup instructions and SQL reference location.
- No changes to code or SQL usage; these are documentation updates for consistency and integration requirements.
v1.0.0
Initial release of the ODPS (MaxCompute) Data Query skill.
- Enables users to query, analyze, and explore data in Alibaba Cloud ODPS (MaxCompute) using SQL.
- Supports listing tables, inspecting table schemas, and executing SQL queries via a command-line script.
- Provides clear setup instructions for environment configuration and credential management.
- Includes workflow guidance for discovering tables, inspecting schemas, querying data, and presenting results.
- Documents key differences between ODPS SQL and standard SQL to help avoid common errors.
元数据
常见问题
odps-sql 是什么？
Use this skill when the user wants to query, analyze, or explore data in Alibaba Cloud ODPS (MaxCompute / 阿里云大数据计算服务). This skill executes SQL queries, lists... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 309 次。
如何安装 odps-sql？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install odps-sql」即可一键安装，无需额外配置。
odps-sql 是免费的吗？
是的，odps-sql 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
odps-sql 支持哪些平台？
odps-sql 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 odps-sql？
由 GuilongZh（@guilongzh）开发并维护，当前版本 v1.0.1。
推荐 Skills