alibabacloud-odps-sql-generation

Name: alibabacloud-odps-sql-generation
Author: aliyun

github.com/aliyunData & databases281206 installsUpdated 1d ago

About alibabacloud-odps-sql-generation

A syntax guidance skill for MaxCompute SQL, aimed at text-to-SQL generation and query troubleshooting. It directs users to dialect rules, query patterns, and error references based on the task.

Key features

01Guide natural-language-to-SELECT generation
02Provide MaxCompute DQL dialect rules
03Cover common query-pattern templates
04Diagnose SQL errors and recovery

Use cases

01Turn a business question into MaxCompute SELECT
02Write group-ranking or retention queries
03Troubleshoot ODPS-0xxx execution errors

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/aliyun/alibabacloud-aiops-skills --skill alibabacloud-odps-sql-generation

After installing, type/alibabacloud-odps-sql-generationin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

references/

maxcompute_select_guide.md

sql_common_errors.md

sql_query_patterns.md

text2sql_principles.md

Details

From the project README

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

Comments

Markdown supported

Details

Author: aliyun
Repository: aliyun/alibabacloud-aiops-skills
Category: Data & databases
Installs: 206
GitHub stars: 281

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).