← Back to Skills Marketplace

Alibabacloud Odps Sql Generation

Name: Alibabacloud Odps Sql Generation
Author: sdk-team

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

cross-platform ✓ Security Clean

Downloads

Stars

Active Installs

Versions

Install in OpenClaw

/install alibabacloud-odps-sql-generation

Description

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

README (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

Usage Guidance

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.

Capability Tags

crypto

Capability Assessment

✓ 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.

How to Use

Make sure OpenClaw is installed (local or Docker)
Run the install command in chat: /install alibabacloud-odps-sql-generation
After installation, invoke the skill by name or use /alibabacloud-odps-sql-generation
Provide required inputs per the skill's parameter spec and get structured output

Version History

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.

Metadata

Slug alibabacloud-odps-sql-generation

Version 0.0.1

License MIT-0

All-time Installs 0

Active Installs 0

Total Versions 1

Frequently Asked Questions

What is Alibabacloud Odps Sql Generation?

Provides MaxCompute SQL intelligent generation capabilities for AI agents, covering text2sql conversion principles, dialect syntax differences (DQL/DDL/DML),... It is an AI Agent Skill for Claude Code / OpenClaw, with 81 downloads so far.

How do I install Alibabacloud Odps Sql Generation?

Run "/install alibabacloud-odps-sql-generation" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Alibabacloud Odps Sql Generation free?

Yes, Alibabacloud Odps Sql Generation is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Alibabacloud Odps Sql Generation support?

Alibabacloud Odps Sql Generation is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Alibabacloud Odps Sql Generation?

It is built and maintained by alibabacloud-skills-team (@sdk-team); the current version is v0.0.1.

More Skills