Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version using:

$ pip install -U pgcli

After the update of pgcli to use prompt-toolkit 2.0, there were quite a few complaints about performance, in particular, slow autocompletions. This release attempts to address the problem. Additionally, thanks to our newest contributor Ignacio Campabadal, it is now possible to supply username with a -u flag, same as mycli.