zaporylie/drupal-composer-sql-sync-policy

Prevent syncing in wrong direction (i.e. from @dev to @prod).

drupal-composer-sql-sync-policy

, _(*1)

Add following to your drushrc.php:, _(*2)

$options['env-flow'] = array(
  '@prod' => array(),
  '@staging' => array('@prod'),
  '@dev' => array('@prod', '@staging'),
  '@local' => array('@prod', '@staging', '@dev'),
);

You can modify list of environments., _(*3)