database-migration-generator

What problem does it solve?

This Skill automates the creation of database migration scripts, ensuring consistent and version-controlled database schema changes across different environments.

Core Features & Use Cases

• SQL Script Generation: Creates UP scripts for table creation, column alterations, and index additions.
• Rollback Scripts: Generates corresponding DOWN scripts to revert changes.
• TypeORM Integration: Produces TypeScript migration files compatible with TypeORM.
• Use Case: When adding a new users table with specific columns and indexes, this Skill can generate both the SQL CREATE TABLE statement and its corresponding DROP TABLE statement, or a TypeORM migration class.

Quick Start

Generate a SQL migration script to create a 'products' table with 'id', 'name', and 'price' columns.