Database Migration Runner

Overview

This skill helps you safely execute database migrations for Budget Buddy's SQLite database. It ensures backups are created, migrations run in correct order, and provides rollback capabilities if something goes wrong.

Prerequisites

• SQLite database exists: budget_buddy.db
• Backend dependencies installed
• Working directory: /Users/franklindickinson/Projects/budget-buddy-2

Quick Start

Step 1: List Pending Migrations

ls -1 backend/database/migrations/*.py backend/database/migrations/*.sql 2>/dev/null | sort