Command-line tool

pgcli

brew/pgcli

Checked 25 Oct 2026, 21:09 UTC · Listing refreshed from Homebrew, winget, npm, Scoop and cargo; npm packages checked against OSV.dev

CLI for Postgres with auto-completion and syntax highlighting

Website

At a glance

Type

Command-line tool

Install on

Windows, macOS, Linux

Last checked

25 Oct 2026, 21:09 UTC

Install it

Windows

pipx install pgcli

macOS

brew install pgcli
pipx install pgcli

Linux

brew install pgcli
pipx install pgcli

Connect to a PostgreSQL database using a connection string

pgcli postgresql://user@host/database

Connect to a database using flags

pgcli -h host -U username -d database

Display help

pgcli --help

Browse

• Databases

Related command-line tools

• litecli
  CLI for SQLite Databases with auto-completion and syntax highlighting
• mycli
  CLI for MySQL with auto-completion and syntax highlighting
• zerobrane-studio
  Lightweight Lua IDE with code completion, syntax highlighting, live coding, code analyzer and debugging support
• Syntax Highlight
  Quicklook extension for source files
• nu_plugin_highlight
  A nushell plugin for syntax highlighting
• source-highlight
  Source-code syntax highlighter
• nyan
  Colorizing `cat` command with syntax highlighting
• iredis
  Terminal Client for Redis with AutoCompletion and Syntax Highlighting

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents