Etl Generator

v1.0.0

大数据 ETL 流程生成器 - 根据源表 DDL 生成标准化 ETL 加工 SQL(HiveSQL/MySQL)

0· 80·1 current·1 all-time
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
VirusTotalVirusTotal
Benign
View report →
OpenClawOpenClaw
Benign
high confidence
Purpose & Capability
Name/description (ETL SQL generator) match the included README, SKILL.md, and the Python script. The code implements DDL parsing, type/field conversion, ETL SQL and quality-check generation — all expected for the described functionality.
Instruction Scope
SKILL.md and README instruct the agent/user to provide DDL via file or stdin and show how to call the Python functions; etl_generator.py reads a local file or stdin and prints SQL to stdout. The docs mention 'query source table (if accessible)' but there is no code that performs network/database queries or reads system config/credentials — this is a documentation note rather than hidden behavior.
Install Mechanism
No install spec is provided and the skill is instruction-plus-script only. Nothing is downloaded or written by an installer; risk from install mechanism is minimal.
Credentials
The skill requires no environment variables, credentials, or config paths. It only reads DDL from a local file or stdin as documented. There is no use of SECRET/TOKEN/KEY env vars in code or docs.
Persistence & Privilege
Flags show default behavior (not always:true). The skill does not request persistent system privileges, does not modify other skill configs, and contains no autorun/install logic.
Assessment
This skill appears to do what it claims: parse a provided CREATE TABLE DDL and emit target DDL, ETL SQL, and quality-check SQL. Before using: (1) provide DDL input yourself (the script does not connect to databases or fetch schemas), (2) review generated SQL for correctness and environment-specific settings (table/db names, partition handling, storage format), and (3) be aware the DDL parser is simple (regex-based) and may not handle complex/edge-case DDL — validate outputs in a safe environment before applying to production.

Like a lobster shell, security has layers — review code before you run it.

latestvk976jkxjek3khb4vhgngqvj15583nc48

License

MIT-0
Free to use, modify, and redistribute. No attribution required.

Comments