skills.rest
evengul
evengulCOMMUNITY
Explore all skills by this author →
GitHub

migrate

Execute Flyway database migrations against a local PostgreSQL database.

Updated Jun 26, 2022
Search Tags:#development#database#postgresql#migration#flyway
One-click install
npx skills add https://github.com/evengul/mc-org --skill migrate-evengul
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migrate
Source: https://github.com/evengul/mc-org/tree/main/.claude/skills/migrate
Command: npx skills add https://github.com/evengul/mc-org --skill migrate-evengul

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the process of applying database schema changes to your local PostgreSQL instance, ensuring your development environment is up-to-date.

Core Features & Use Cases

  • Database Migrations: Executes Flyway migration scripts to manage database schema evolution.
  • Local Development: Ensures consistency between your application code and the local database schema.
  • Use Case: Before starting development on a new feature that requires database changes, run this Skill to apply all pending migrations.

Quick Start

Run webapp/scripts/migrate-locally.sh to apply database migrations.

Frequently Asked Questions about migrate

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

FAQPage Schema
How do I run Flyway database migrations for local PostgreSQL development?▼

Run Flyway database migrations for local PostgreSQL by executing the shell script `webapp/scripts/migrate-locally.sh`. This applies pending schema changes to keep your local development database up-to-date.

What are database migrations and when do I need to run them?▼

Database migrations manage schema evolution by applying sequential changes to a PostgreSQL database. You need to run them before starting development on new features that require database schema modifications to ensure environment consistency.

Do I need PostgreSQL installed locally to run database migrations?▼

Yes, you need a local PostgreSQL instance running to execute Flyway database migrations. The migration script applies schema changes directly against your local development database environment.

How do I apply pending schema changes to my local development database?▼

Apply pending schema changes to your local development database by running the `webapp/scripts/migrate-locally.sh` shell script, which triggers Flyway to execute all pending migration scripts sequentially.

Can I use this migration Skill for production database deployments?▼

No, this Skill is designed for local development environments to manage schema evolution for the MC-ORG web application. It executes migrations specifically against a local PostgreSQL database instance.

Related Skills

Explore More Software Engineering Skills→
leonj1leonj1

rds-postgres

Connect to Amazon RDS PostgreSQL databases and execute SQL queries.

Community
Intermediate
evengulevengul

devstart

Set up the local development environment for the MC-ORG project.

Community
Intermediate
dilipsundarraj1dilipsundarraj1
113

db-migration

Automate Flyway migrations for schema changes in Spring Boot Kafka consumer projects.

Community
Intermediate
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced