SKILLEMALL.ai
GitHub ↗ RU Sign in

BF alibabacloud-migration-sdm-sql-trans

跨大数据引擎的 SQL 语法转换技能（DML/DDL/存储过程）。覆盖标识符、数据类型、函数、查询语法、分布/分区策略、存储过程/函数、外表等重写场景。目前已实现 Synapse → Hologres，框架为其他引擎对（如 SQL Server → MaxCompute、Hive → Hologres、PostgreSQL → Hologres、Oracle → MaxCompute 等）预留了可扩展位置（TODO）。当用户需要将 SQL/T-SQL/PL-SQL 从一个数仓转换到另一个数仓、跨源迁移查询语句、T-SQL 转 PostgreSQL、数仓 SQL 兼容性改写时使用。不适用于：表结构 DDL 迁移（用 ddl-trans）、ADF 工作流迁移（用 adf2dw）、数据集成作业生成（用 dw-di-generator）。已知局限：不支持递归 CTE、动态 SQL 拼接、SQL Server GEOGRAPHY/GEOMETRY 等空间类型；基于规则匹配，转换结果建议人工审核。

ClawHub Agent Skills author: alibabacloud-skills-team v0.0.1 MIT-0 5 files body ≈ 5 879 tokens Open the sourceclawhub.ai↗ analyzed 2 d ago

跨大数据引擎的 SQL 语法转换技能（DML/DDL/存储过程）。覆盖标识符、数据类型、函数、查询语法、分布/分区策略、存储过程/函数、外表等重写场景。目前已实现 Synapse → Hologres，框架为其他引擎对（如 SQL Server → MaxCompute、Hive →…

As a process F 40/100 · Will not run — References files that are not bundled: references/sqlserver_to_maxcompute.md, references/hive_to_hologres.md, references/hive_to_maxcompute.md

ProcedurePostgreSQLData and analyticsAI and agentsWriting and documentstype and topics are labelled automatically from the skill text
Runs in: OpenClaw Claude / Claude Code ChatGPT / Codex Gemini CLI Cursor GitHub Copilot / VS Code Qwen Code Kimi Code CLI Z.ai (GLM) DeepSeek (Deep Code) Mistral Vibe LangChain (deepagents) Goose OpenCode
JSON
Technical rating
B
80/100
safety, quality, tests
Safety 60%
100
Quality 40%
50
Run on models
none yet
Process rating
F
40/100
Will not run
References files that are not bundled: references/sqlserver_to_maxcompute.md, references/hive_to_hologres.md, references/hive_to_maxcompute.md
Tools and files w 18
0
Inputs and preconditions w 11
0
When it triggers w 12
20
the three weakest of ten parameters · all ten

How to improve

  1. Say in the description WHEN to use the skill ("use when…", example requests): that is the agent's main cue.
  2. The SKILL.md body is over 5,000 tokens: move reference detail into references/ and load it when needed.
  3. The text references files that are not there: add them or drop the references.
For the model run — optional
  • Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
  • A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.

Guard findings · 0

✓ No critical or high findings

Files scanned: 5. Evidence is masked. Grey chips explain why severity was lowered.

Against the Agent Skills spec

  • warning description-no-when description does not say WHEN to use the skill (no "use when")
  • warning body-long SKILL.md body ≈ 5879 tokens (recommended < 5000); move details to references/
  • warning missing-ref reference to a missing file: references/sqlserver_to_maxcompute.md
  • warning missing-ref reference to a missing file: references/hive_to_hologres.md
  • warning missing-ref reference to a missing file: references/hive_to_maxcompute.md
  • warning missing-ref reference to a missing file: references/postgresql_to_hologres.md
  • warning missing-ref reference to a missing file: references/oracle_to_maxcompute.md
  • warning missing-ref reference to a missing file: references/teradata_to_*.md
  • warning missing-ref reference to a missing file: references/snowflake_to_*.md
  • warning missing-ref reference to a missing file: references/<src>_to_<dst>.md

Process rating: all ten parameters 40/100

Will not run. References files that are not bundled: references/sqlserver_to_maxcompute.md, references/hive_to_hologres.md, references/hive_to_maxcompute.md
  • 0Tools and files. 8 referenced file(s) missing: references/sqlserver_to_maxcompute.md, references/hive_to_hologres.md, references/hive_to_maxcompute.md
  • 0Inputs and preconditions. Does not say what the process needs to start
  • 20When it triggers. No condition that starts the skill
  • 30Running it twice. 14 mutating operations with no state check
  • 50Failures and branches. 0 branches, has a failure section
  • 60Steps. 72 steps, 6 vague phrases
  • 60Result and completion. Output format stated, no completion criterion
  • 70Execution cost. Instruction body is 5879 tokens
  • 100Consistency. Name and required fields are in place
  • 100Progress reporting. Reports progress
  • medium Safety rules and hard prohibitions inside a skill: they belong in the system prompt, here they protect nothing
  • low 14 top-level sections: this looks like several domains in one skill
  • low The response is described with custom markup (10 tags): a typed call is more reliable

Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.

Quality signals

  • +5Description has no quoted example phrases that should trigger the skill
  • +4Description does not say when NOT to use the skill (false activations)
  • -5TODO / placeholder text left in the skill
  • -224 emoji in the instructions: noise for the model
  • +1No license
  • +2Single-language instructions
  • +3Description length 449: enough signal without eating the budget
  • +4Structure: 33 headings
  • +3Step-by-step instructions: 72 items
  • +3Output format is stated explicitly
  • +4Has examples (5 code blocks)
  • +4Reference files are cited in the instructions (3 of 3)

Quality base 70; lint remarks subtract, signals add up to 100. Result: 50.

External checks

ClawHub: clean
This is a content-only SQL translation skill with minor instruction ambiguities, but no evidence of hidden tools, credential access, exfiltration, or persistence.
LLM: benign (high) · VirusTotal: · 9 Jul 2026