Supagrate

The missing tool for Supabase migrations.

Installation

Commands

| Command | Description | |---------------------------|----------------------------------------------------| | supagrate init | Setup your project with supagrate | | supagrate migrate down | Rollback your migrations one by one | | supagrate migrate new | Generate a new migration | | supagrate migrate reset | Reset your database and apply all migrations again | | supagrate migrate up | Apply your migrations one by one | | supagrate seed apply | Apply a seeder to your database | | supagrate seed new | Generate a new seeder | | supagrate status | View the migration status of your database |

Roadmap

• [ ] Use already setup Supabase CLI to login to the DB
• [ ] Allow 0 setup for remote DB (to be able to run migrations on GitHub Actions)
• [ ] Assume local DB is postgresql://postgres:postgres@localhost:54322/postgres?sslmode=disable
• [x] Allow the generation of migrations
• [x] Use up.sql and down.sql files for migrations
• [x] Allow complete reset of the DB
• [ ] Allow the application (up) of migrations
• [ ] Allow the rollback of migrations
• [ ] Allow the generation of arbitrary seeder
• [ ] Allow the application of arbitrary seeder