DEV Community

Amit Chauhan
Amit Chauhan

Posted on

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.

YugabyteDB Architecture

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 
Enter fullscreen mode Exit fullscreen mode
  • Once installed, let's connect to the YugabyteDB. Example:
pgcli -h 127.0.0.1 -p 5433 -U yugabyte

Enter fullscreen mode Exit fullscreen mode
  • That's it - enjoy all the goodies offered by pgcli on YugabyteDB

Screenshot showing PGCLI in action using YugabyteDB

Top comments (0)