Database Commands

Andurel wraps common PostgreSQL lifecycle and migration operations.

Database lifecycle

1andurel database create
2andurel database drop
3andurel database nuke
4andurel database rebuild
5andurel database seed

rebuild drops and recreates the database, applies migrations, and runs seeds. Pass --skip-seed when seed data is not needed.

Migrations

1andurel database migrate new add_status_to_products
2andurel database migrate up
3andurel database migrate down
4andurel database migrate status
5andurel database migrate reset

Use up-to and down-to to target a version. Use fix to renumber migration gaps.

Database console

Open a console using the current .env connection settings:

1andurel console

The project toolchain provides usql and dblab for command-line and browser-based inspection.