Regarding CLI: mycli and pgcli are both much nicer than the built in alternatives.