Ease Postgres SQL queries with auto-completion and syntax-highlighting

Recently, I've just explored some wonderful postgres CLI extensions/plugins which make data query much comfortable. One of my favorite one is pgcli - a postgres client that does auto-completion and syntax highlighting.

To install on macOS with Homebrew:

brew install pgcli

Connect to your postgres db:

pgcli -h <HOST_ADDRESS> -d <DB_NAME> -U <USERNAME> -W

My quick demo: