database-migrations

Automate database schema changes and data migrations across PostgreSQL and MySQL.

Updated Nov 19, 2025
One-click install
npx skills add https://github.com/Sake-Team/SmartSake --skill database-migrations-sake-team
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-migrations
Source: https://github.com/Sake-Team/SmartSake/tree/main/backup/skills/database-migrations
Command: npx skills add https://github.com/Sake-Team/SmartSake --skill database-migrations-sake-team

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires prisma, drizzle, kysely, django, typeorm, golang-migrate, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the complexities of database migrations, ensuring safe and efficient schema changes, data migrations, rollbacks, and zero-downtime deployments across various database systems and ORMs.

Core Features & Use Cases

  • Schema Changes: Handles the creation, alteration, and removal of database tables and columns.
  • Data Migrations: Manages data backfill, transformation, and zero-downtime updates.
  • Rollbacks: Provides mechanisms to revert changes safely.
  • ORM Support: Integrates with Prisma, Drizzle, Kysely, Django, TypeORM, and golang-migrate.
  • Use Case: Ideal for developers and database administrators looking to automate database migrations, maintain data integrity, and reduce downtime during deployments.

Quick Start

Activate the database-migrations skill to apply a new migration for adding a user avatar column to the 'users' table.

Frequently Asked Questions about database-migrations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate database schema changes without downtime?

Automating database schema changes without downtime requires applying best practices for data backfill and transformation. This approach supports PostgreSQL and MySQL alongside various ORMs to ensure reversible, zero-downtime deployments.

Does this database migration approach support Prisma and Drizzle?

Yes, this database migration approach supports Prisma and Drizzle, alongside Kysely, Django, TypeORM, and golang-migrate. It integrates with these ORMs to automate schema changes, data migrations, and rollbacks efficiently.

What is the best way to handle data backfill and transformation during a migration?

The best way to handle data backfill and transformation during a migration is to use automated data migration mechanisms. This ensures data integrity and zero-downtime updates while managing schema changes across supported database systems.

How do I safely rollback database migrations if a deployment fails?

To safely rollback database migrations after a failed deployment, you need mechanisms that provide reversible changes. This approach ensures you can revert schema alterations and data migrations securely without losing data integrity.

How do I add a new column to a PostgreSQL table using an ORM migration?

Adding a new column to a PostgreSQL table using an ORM migration involves applying a new schema change through the ORM setup. This process handles the creation and alteration of database tables while maintaining zero-downtime deployment standards.