fr: Add confirmation prompts prior to executing migration

[jvliwanag]

Requesting a feature to prompt first for a confirmation prior to running migrations. Something like:

About to run migration <xxx>. Continue (y/N)?

Ideally there's also a flag for --skip-confirmation to restore prior behavior that's auto enabled when CI=true so as to lessen breaking existing workflows.