Easy Drush Aliases

$ vim ~/.ssh/config

Host foo
HostName foo.devsite.com
User brant
Port 22
 
Host bar
HostName bar.stagingsite.com
User brant
Port 22
 
Host baz
HostName baz.productionsite.com
User brant
Port 22

$ vim ~/.drush/aliases.drushrc.php

$local_sites = '/users/brantwynn/Sites/';
$local_dumps = $local_sites . 'drush.dbdumps';
$remote_sites = '/var/www/sites/';
$hosts = array(
  'foo',
  'bar',
  'baz'
);
foreach ($hosts as $host) {
  // Local aliases.
  $aliases[$host . '.local'] = array(
    'root' => $local_sites . $host,
    'path-aliases' => array(
      '%dump-dir' => $local_dumps,
      '%files' => $local_sites . $host . '/sites/default/files'
    )
  );
  // Remote aliases.
  $aliases[$host . '.remote'] = array(
    'remote-host' => $host,
    'root' => $remote_sites . $host,
    'path-aliases' => array(
      '%files' => $remote_sites . $host . '/sites/default/files',
      '%dump-dir' => '/home/brant'
    ),
    'command-specific' => array (
       'sql-sync' => array (
       'skip-tables-list' => 'cache_menu',
       ),
    )
  );
}

$ drush sql-sync @foo.remote @foo.local --no-cache -y