Sql Migration Generator
ListedProvides migration guidance and assistance for working with databases and data persistence.
Install on your platform
Showing Claude Code. One command installs this skill into any of the agents below.
- 1
Run this in your project
terminal$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill sql-migration-generator -a claude-code Uses the open-source
skillsCLI and needs Node.js. Add-gto install it for your user instead of this project.
What we know about this skill
Publisher
jeremylongshore
Taken from the source listing. We haven't verified who controls this account.
Install target
Live repository
Not pinned. Installing fetches whatever the repository holds at the time you run the command.
Automated safety checks
We could not read this skill's source, so none of the checks below were run.
About this skill
What it does
The SQL Migration Generator skill creates SQL migration scripts based on provided database schema changes. It can generate the necessary up and down migrations, allowing for automated database version control. This facilitates safer deployments and rollbacks by applying or reverting changes in a controlled manner.
When to use it
- Database Refactoring: Generate migration scripts when altering table structures, adding new columns, or changing data types.
- Application Deployment: Automate the process of updating your database schema during application releases.
- Rollback Scenarios: Easily revert database changes by generating
downmigrations to undo previous alterations. - Team Collaboration: Standardize database change management across development teams.
Key capabilities
- Generates SQL migration scripts (
upanddown). - Handles schema modifications (table creation, column additions/removals).
- Supports data type changes.
- Automated version control for databases.
Example prompts
- "Generate a migration to add a new 'email' column of type VARCHAR(255) to the 'users' table."
- "Create a migration script that drops the 'old_table' table and renames it to 'new_table'."
- “I need a migration to change the data type of the ‘quantity’ column in the ‘products’ table from INT to BIGINT.”
Tips & gotchas
The quality of generated SQL depends on the clarity and accuracy of the provided schema changes. Ensure you clearly define the desired modifications for optimal results.