1.0.16 • Published 7 months ago
supagrate v1.0.16
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
- Allow the generation of migrations
- Use
up.sql
anddown.sql
files for migrations - 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