pgcli vs PostgREST: What are the differences?
pgcli: Postgres CLI with autocompletion and syntax highlighting. This is a postgres client that does auto-completion and syntax highlighting; PostgREST: Automatic REST API for Any Postgres Database. PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
pgcli and PostgREST can be categorized as "Database" tools.
pgcli and PostgREST are both open source tools. PostgREST with 12.5K GitHub stars and 585 forks on GitHub appears to be more popular than pgcli with 8.01K GitHub stars and 365 GitHub forks.