pgcli

pgcli provides an interactive command‑line interface for PostgreSQL databases. It connects to a database via a DSN, host/port, or environment variables and offers typical options such as password prompting, row‑limit control, and vertical output switching. The client also supports a subset of psql back‑slash commands and can be configured through a file created in the user’s config directory.

The tool is built on prompt_toolkit and adds features aimed at improving productivity. As the user types, pgcli suggests completions for SQL keywords, table names, and column names, with context‑aware filtering that narrows suggestions based on the current clause. Query results are displayed with syntax highlighting and formatted tables, and a smart‑completion mode is enabled by default.

pgcli is distributed as a Python package and can be installed via pip, Debian‑based package managers, or Homebrew. It is positioned as a more user‑friendly alternative to the default psql client, targeting developers and database administrators who work with PostgreSQL interactively.