Using pgcli with YugabyteDB

pgcli is popular postgres client that does auto completion and syntax highlighting.

YugabyteDB is popular open source distributed database. If you see the architecture diagram below, YugabyteDB has Postgres Compatible YSQL API.

What this means is that most clients which work for Postgres work out of box with YugabyteDB. Let's take pgcli as an example.

• Install the pgcli. On mac, if you are using brew you can simply do this (for linux see instructions here):

brew install pgcli 

• Once installed, let's connect to the YugabyteDB. Example:

pgcli -h 127.0.0.1 -p 5433 -U yugabyte

• That's it - enjoy all the goodies offered by pgcli on YugabyteDB