← 返回 Skills 市场

Alibabacloud Odps Sql Generation

Name: Alibabacloud Odps Sql Generation
Author: sdk-team

作者 alibabacloud-skills-team · GitHub ↗ · v0.0.1 · MIT-0

cross-platform ✓ 安全检测通过

总下载

当前安装

版本数

在 OpenClaw 中安装

/install alibabacloud-odps-sql-generation

功能描述

Provides MaxCompute SQL intelligent generation capabilities for AI agents, covering text2sql conversion principles, dialect syntax differences (DQL/DDL/DML),...

使用说明 (SKILL.md)

MaxCompute SQL Engine Syntax Skill

Provides MaxCompute SQL engine syntax guidance for text2sql scenarios. MaxCompute is based on Hive SQL extensions and has significant differences from ANSI standard SQL.

Usage

Load corresponding reference files based on question type (can be combined). The load column indicates relative loading weight (heavy ≈ large, medium ≈ moderate), for budget estimation, not exact token counts. Each file's opening paragraph describes its own scope.

Trigger condition	File	load
NL→SELECT generation / text2sql (determine intent, granularity, table-column mapping, output format first)	`references/text2sql_principles.md`	light
Generate MaxCompute SELECT queries (dialect rules, DQL default must-read)	`references/maxcompute_select_guide.md`	heavy
Match query pattern keywords: Top N / top-N per group / year-over-year / month-over-month / consecutive N days / retention / row-to-column / column-to-row / PIVOT / UNPIVOT / array expansion / LATERAL VIEW / EXPLODE / JSON extraction / GET_JSON_OBJECT / cumulative / running total / Range Join / GROUPING SETS / CUBE / ROLLUP / pagination / paging	`references/sql_query_patterns.md`	medium
SQL execution failure requiring diagnosis and recovery (including `ODPS-0xxx` error codes)	`references/sql_common_errors.md`	medium

Relationship: text2sql_principles.md provides engine-independent NL→SELECT generation principles; maxcompute_select_guide.md is the single authoritative source for MaxCompute DQL dialect rules (unsupported syntax/functions/partitioning/types/SET parameters). sql_query_patterns.md provides query template snippets only, without duplicating rules.

Out of Scope

The following scenarios exceed this skill's scope:

MaxCompute non-SQL interfaces: Tunnel / MapReduce / Graph / PyODPS DataFrame API, SDK invocation methods
Console and permission management: Quota requests, IAM / RAM roles, project owner operations — use Aliyun console or support tickets
Execution plan-level deep tuning: Only lists common SET parameters and hints; does not analyze specific plan nodes / Fuxi DAG / data skew formation paths
Cluster-side / platform-side failures: Worker crashes, resource scheduling failures, MetaStore transaction conflicts, storage layer read/write errors — these are support ticket issues, not SQL issues

安全使用建议

This result is low confidence because metadata.json and artifact/ could not be inspected in the workspace during this run. Re-run the review where those files are readable before relying on this installation decision.

能力标签

crypto

能力评估

✓ Purpose & Capability

No purpose mismatch or unsafe capability could be confirmed from the accessible context.

✓ Instruction Scope

No overbroad or deceptive runtime instruction could be confirmed from the accessible context.

✓ Install Mechanism

No risky install behavior could be confirmed from the accessible context.

✓ Credentials

No disproportionate environment access could be confirmed from the accessible context.

✓ Persistence & Privilege

No persistence, privilege escalation, or credential handling concern could be confirmed from the accessible context.

如何使用

确保已安装 OpenClaw（本地或 Docker 部署）
在对话框中输入安装命令：/install alibabacloud-odps-sql-generation
安装完成后，直接呼叫该 Skill 的名称或使用 /alibabacloud-odps-sql-generation 触发
根据 Skill 的参数说明提供必要输入，即可获得结构化输出

版本历史

v0.0.1

Initial release providing MaxCompute SQL generation and guidance for AI agents. - Covers text-to-SQL conversion principles, syntax differences, query pattern templates, and ODPS error diagnostics. - Includes documentation to trigger relevant guides for text2sql, SELECT query generation, pattern matching, and error handling. - Clearly describes usage and file loading weights to help with resource estimation. - Specifies topics that are out of scope, such as non-SQL interfaces, permission management, deep execution tuning, and cluster/platform failures.

元数据

Slug alibabacloud-odps-sql-generation

版本 0.0.1

许可证 MIT-0

累计安装 0

当前安装数 0

历史版本数 1

常见问题