How does it ensure database safety?

The skill generates idempotent scripts and recommends wrapping steps in transactions to ensure that changes are applied atomically or not at all.

Which databases does the Migration Manager support?

The skill currently supports PostgreSQL, MySQL, SQLite, and MongoDB, providing specific syntax for each engine.

Does it create rollback scripts automatically?

Yes, every migration generated includes both 'up' scripts to apply changes and 'down' scripts to revert them, ensuring you can undo any modification.

Can I add specific columns using natural language?

Absolutely. You can request changes like 'add an email column to the users table' and the skill will generate the correct timestamped migration file.

Database Migration Manager

Name: Database Migration Manager
Author: intent-solutions-io

byintent-solutions-io

0•

Database Management

Automates the creation, application, and rollback of database schema migrations across multiple SQL and NoSQL engines.

This skill provides a robust framework for managing database schema evolution directly through Claude Code. It automates the generation of timestamped migration files containing both 'up' and 'down' scripts, ensuring that changes like adding columns or altering tables are version-controlled and reversible. Supporting popular databases like PostgreSQL, MySQL, SQLite, and MongoDB, it streamlines the development workflow by handling the boilerplate of schema changes while enforcing best practices like idempotency and transactional integrity.

Key Features

01Automated generation of timestamped migration files

02Bilateral migration logic with up and down scripts for safe rollbacks

03Idempotent script generation to prevent unintended side effects

04Transactional execution support to ensure atomic database updates

05Support for PostgreSQL, MySQL, SQLite, and MongoDB

060 GitHub stars

Use Cases

01Modifying database structure by adding or removing columns via natural language commands

02Safely rolling back the most recent database change in case of deployment errors

03Maintaining a version-controlled history of schema evolutions for collaborative development

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla skill-adapter

For use in Claude.ai and ChatGPT

Download Skill