db-migrate

Manage database schema migrations with Flyway and Atlas.

33|5|Updated Jan 2, 2026
One-click install
npx skills add https://github.com/y1feng200156/ham-study --skill db-migrate-y1feng200156
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-migrate
Source: https://github.com/y1feng200156/ham-study/tree/main/.agent/skills/db-migrate
Command: npx skills add https://github.com/y1feng200156/ham-study --skill db-migrate-y1feng200156

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines database schema management by providing robust tools for version-controlled migrations, ensuring consistency and reliability across development and production environments.

Core Features & Use Cases

  • Versioned Migrations: Manage database schema changes using SQL scripts with Flyway.
  • Declarative Schema Management: Define and evolve your database schema using HCL with Atlas.
  • Automated Diffing & Generation: Automatically compare schema states and generate migration scripts.
  • Use Case: When adding a new feature that requires database changes, use this Skill to create, apply, and track the migration scripts, ensuring your database schema stays up-to-date and consistent.

Quick Start

Use the db-migrate skill to create a new Flyway migration script named "add_users_table".

Frequently Asked Questions about db-migrate

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

FAQPage Schema
How do I manage database schema migrations with version-controlled SQL scripts?

Database schema migrations are managed using version-controlled SQL scripts with Flyway, allowing you to create, execute, and track changes to ensure consistency across development and production environments.

What is the difference between versioned migrations and declarative schema management?

Versioned migrations apply schema changes sequentially using SQL scripts with Flyway, while declarative schema management defines the desired database state using HCL with Atlas to automatically calculate and apply differences.

How can I automatically generate a migration script from a database schema diff?

Automated diffing with Atlas compares schema states and automatically generates the required migration scripts, streamlining the process of evolving your relational database schema without manual SQL writing.

Do I need Java to run Flyway for database migrations?

Yes, running Flyway for database migrations requires a Java 11+ environment to execute the version-controlled SQL scripts and manage the schema evolution process.

Can I use Atlas for declarative schema management without writing SQL?

Atlas allows you to define and evolve your database schema declaratively using HCL, comparing the defined state against your database to auto-generate and apply the necessary migration scripts.