data-transform-gen
Generate ETL and data transformation scripts. Use when migrating data between systems.
Best use case
data-transform-gen is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Generate ETL and data transformation scripts. Use when migrating data between systems.
Teams using data-transform-gen should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/data-transform-gen/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How data-transform-gen Compares
| Feature / Agent | data-transform-gen | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Generate ETL and data transformation scripts. Use when migrating data between systems.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# 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.
Related Skills
database-optimizer
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures. Masters advanced indexing, N+1 resolution, multi-tier caching, partitioning strategies, and cloud database optimization. Handles complex query analysis, migration strategies, and performance monitoring. Use PROACTIVELY for database optimization, performance issues, or scalability challenges.
database-optimization
Use when optimizing database queries, indexes, N+1 problems, slow queries, or analyzing query performance. Triggers on keywords like "slow query", "N+1", "index", "query optimization", "database performance", "eager loading".
database
Database design, optimization, and management for SQL and NoSQL databases. Covers schema design, indexing, query optimization, migrations, and database best practices. Use when designing database schemas, optimizing queries, troubleshooting database performance, or implementing data models.
database-migrator
Handle schema changes and data migrations safely. Creates migration files with rollback plans. Use when user says 'migration', 'schema change', 'add column', 'database change', or 'alter table'.
database-migrations-sql-migrations
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server Use when: the user asks to run the `sql-migrations` workflow and the task requires multi-step orchestration. Do not use when: the task is small, single-step, and can be completed directly without orchestration overhead.
database-migration
Guides database migration projects including engine changes (MySQL to PostgreSQL, Oracle to PostgreSQL, SQL Server to PostgreSQL), version upgrades, cloud migrations (on-premise to RDS/Cloud SQL/Azure Database), schema migrations, zero-downtime migrations, replication setup, and data migration strategies. Covers homogeneous and heterogeneous migrations, ETL processes, cutover procedures, and rollback plans. Use when migrating databases, changing database engines, upgrading database versions, moving databases to cloud, or when users mention "database migration", "DB migration", "PostgreSQL migration", "MySQL to Postgres", "Oracle migration", "database upgrade", or "cloud database migration".
database-master
World-class expert database master covering PostgreSQL, MySQL, MongoDB, Redis, and database architecture. Use when designing schemas, optimizing queries, planning migrations, implementing caching strategies, or solving complex database challenges at production scale.
database-management
Database schema design, migrations, query optimization, and ORM best practices. Use for database setup, performance tuning, and data modeling.
database-expert
Advanced database design and administration for PostgreSQL, MongoDB, and Redis. Use when designing schemas, optimizing queries, managing database performance, or implementing data patterns.
database-expert-advisor
Database design, optimization, and operations expert
database-engine-implementation
Guide for implementing database engines in IterableData. Use when adding support for new SQL or NoSQL databases, implementing DBDriver classes, or extending database capabilities.
database-designer
Provides expert-level database design with schema analysis, index optimization, and migration generation. Supports PostgreSQL, MySQL, MongoDB, and DynamoDB. Use when designing schemas, optimizing queries, planning migrations, or analyzing database performance.