数据转换生成器
diegosouzapw2026-10-28查看 1900复制 1074
生成 ETL 和数据转换脚本。在系统之间迁移数据时使用。
📘如何使用这个技能
- 1复制技能内容·点击上方「Copy SKILL.md」复制全部内容,或 Download 下载到本地
- 2打开你的 AI 客户端·支持 Claude Code、Trae、Cursor、ChatGPT、DeepSeek、Kimi 等任意 AI 助手
- 3粘贴为系统提示/知识文件·Claude Code:放入 .claude/skills/ 目录;普通对话:作为首条消息发送并说「请严格按这份技能文档执行」
- 4直接提出你的需求·AI 会按技能定义的工作流、格式和约束来处理,无需再解释背景
💡 提示:技能生效后,每次对话只需一句需求,AI 会按 SKILL.md 的流程执行。
SKILL.md2142 chars
--- name: data-transform-gen description: Generate ETL and data transformation scripts. Use when migrating data between systems. --- # Data Transform Generator Moving data between databases or formats requires writing tedious transformation scripts. Describe your source and destination and get a complete ETL script. **One command. Zero config. Just works.** ## Quick Start ```bash npx ai-data-transform "CSV to PostgreSQL" ``` ## What It Does - Generates complete data transformation scripts - Handles schema mapping between different formats - Supports databases, files, and APIs - Includes error handling and validation ## Usage Examples ```bash # File to database npx ai-data-transform "CSV to PostgreSQL" # API to database npx ai-data-transform "JSON API to SQLite" # Database to database npx ai-data-transform "MongoDB to Elasticsearch" # With transformations npx ai-data-transform "Excel to MySQL, convert dates and normalize names" ``` ## Best Practices - **Validate before loading** - catch bad data early - **Batch large datasets** - don't load 1M rows at once - **Log progress** - know where you are if it fails - **Test on sample data** - verify transforms work before full run ## When to Use This - Migrating to a new database - Loading data from external sources - Building ETL pipelines - One-time data imports ## Part of the LXGIC Dev Toolkit This is one of 110+ free developer tools built by LXGIC Studios. No paywalls, no sign-ups, no API keys on free tiers. Just tools that work. **Find more:** - GitHub: https://github.com/LXGIC-Studios - Twitter: https://x.com/lxgicstudios - Substack: https://lxgicstudios.substack.com - Website: https://lxgicstudios.com ## Requirements No install needed. Just run with npx. Node.js 18+ recommended. Needs OPENAI_API_KEY environment variable. ```bash npx ai-data-transform --help ``` ## How It Works Takes your description of source and destination formats, then generates a Node.js script that handles reading, transforming, and writing data. The AI includes proper error handling and progress logging. ## License MIT. Free forever. Use it however you want.