Postgres CLI with autocompletion and syntax highlighting
pgcli integrates with
Why people like pgcli
Add a one-liner

This is a postgres client that does auto-completion and syntax highlighting.

pgcli's Features
  • Auto-completion as you type for SQL keywords as well as tables and columns in the database.
  • Syntax highlighting using Pygments.
  • Smart-completion (enabled by default) will suggest context-sensitive completion.