pkg.soopen package index

brew / rank 1259

Install pgcli with Homebrew, apk, apt, dnf, MacPorts, Nix, pacman

CLI for Postgres with auto-completion and syntax highlighting. Version 4.6.0 via Homebrew; verified 2026-09-12. Also installable with debian: sudo apt install pgcli.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install pgcli

local Homebrew formula metadata

MacPortsverified · 94%
sudo port install pgcli

MacPorts ports tree · databases/pgcli/Portfile · source: api.github.com

Linux

Alpine Linux apkverified · 92%
sudo apk add pgcli

Alpine Linux edge package indexes · pgcli · source: dl-cdn.alpinelinux.org

Debian aptverified · 92%
sudo apt install pgcli

Debian stable package indexes · pgcli · source: deb.debian.org

Fedora dnfverified · 92%
sudo dnf install pgcli

Fedora Rawhide package metadata · pgcli · source: dl.fedoraproject.org

Nixverified · 92%
nix profile install nixpkgs#pgcli

nixpkgs package indexes · pgcli · source: raw.githubusercontent.com

Arch Linux pacmanverified · 92%
sudo pacman -S pgcli

Arch Linux sync databases · pgcli · source: geo.mirror.pkgbuild.com

overview

Package summary

CLI for Postgres with auto-completion and syntax highlighting

Commands and aliases

  • pgcli

history

Project history and usage

pgcli is an interactive PostgreSQL command-line client focused on auto-completion, syntax highlighting, readable tabular output, and an improved REPL experience.

Project history

pgcli is maintained under the dbcli organization, a family of enhanced database command-line clients. Its development has continued through a long-running public release and changelog history.

Adoption history

pgcli is available through multiple Unix-oriented packaging systems, including Homebrew, Debian, Ubuntu, Fedora-family repositories, Arch Linux, Alpine Linux, MacPorts, and Nix, making it a broadly packaged alternative PostgreSQL shell.

How it is used

Users invoke pgcli with PostgreSQL connection parameters or a connection URI, then work interactively with SQL, slash commands, completion, query history, named queries, and configurable key bindings.

Why package nerds care

pgcli applies modern interactive-shell features—context-aware completion, syntax highlighting, multiline editing, persistent history, and configurable output—to the traditional PostgreSQL command-line workflow.

Timeline

  • 2010s: pgcli emerged as part of the dbcli family of enhanced database shells.
  • Present: The project remains publicly developed and packaged across major Unix package ecosystems.

Related projects

  • pgcli is part of the dbcli ecosystem and is conceptually related to PostgreSQL's psql client and dbcli's mycli client for MySQL-compatible databases.

Sources

  • Official changelog: https://github.com/dbcli/pgcli/blob/main/changelog.rst
  • Official homepage: https://www.pgcli.com/
  • Official repository: https://github.com/dbcli/pgcli

security posture

Risk level: green

narrow executable package without higher-risk signals.

Risk classifier

green risk · low confidence · appliance

Why

  • narrow executable package without higher-risk signals

Signals

  • metadata:no-higher-risk-signals

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 6 platform targets.
  • Installs with 2 runtime dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

Configuration and credential file locations

These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval.

Configuration files

Config paths the tool may read or write during local use.

Unix
~/.config/pgcli/config

Credential files

Credential-bearing paths to review before unattended agent runs.

Unix
~/.pgpass
Windows
%APPDATA%\postgresql\pgpass.conf

executables

Installed executables

CommandKindExposureNote
pgclicliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-09-19
manager version4.6.0
manager updated2026-09-12
local dataok
upstreamnot checked
latest detectednot detected

https://pgcli.com/

  • infoRelease/tag comparison is only available for GitHub repositories.https://pgcli.com/none confidence

install metadata

Package metadata

Package keybrew:pgcli
Version4.6.0
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/pgcli
Homepagehttps://pgcli.com/
Upstream docshttps://pgcli.com/
LicenseBSD-3-Clause
Source archivehttps://files.pythonhosted.org/packages/97/5d/d6fcf98556e6089915e12af12c6189e9d774d82b473c4ce9e124a62ec235/pgcli-4.6.0.tar.gz
Last updated2026-09-12T23:11:17Z
Pulseupdated
Dependencieslibpq, python@3.14
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepgcli
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

pgcli 4.3.0-2

CLI for PostgreSQL with auto-completion and syntax highlighting

https://www.pgcli.com

sudo apt install pgcli
  • Section: database
  • Architecture: all
  • 11 dependencies
  • normalized package name match
  • Matched by: Pgcli
Debian stable package indexes · deb.debian.org · Debian stable package indexes: pgcli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

pgcli

nix profile install nixpkgs#pgcli
  • normalized package name match
  • Matched by: Pgcli
nixpkgs package indexes · raw.githubusercontent.com · nixpkgs package indexes: pgcli from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix
Ubuntu apt95%

pgcli 4.0.1-1

CLI for PostgreSQL with auto-completion and syntax highlighting

https://www.pgcli.com

sudo apt install pgcli
  • Section: universe/database
  • Architecture: all
  • 14 dependencies
  • normalized package name match
  • Matched by: Pgcli
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: pgcli from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz
apk95%

pgcli 4.6.0-r0

Postgres CLI with autocompletion and syntax highlighting

https://www.pgcli.com

sudo apk add pgcli
  • License: BSD-3-Clause
  • Architecture: x86_64
  • Source Package: pgcli
  • 1 dependencies
  • 1 provides
  • normalized package name match
  • Matched by: Pgcli
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pgcli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

pgcli-pyc 4.6.0-r0

Precompiled Python bytecode for pgcli

https://www.pgcli.com

sudo apk add pgcli-pyc
  • License: BSD-3-Clause
  • Architecture: x86_64
  • Source Package: pgcli
  • 1 dependencies
  • normalized package name match
  • Matched by: Pgcli
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pgcli-pyc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
dnf95%

pgcli 4.6.0-1.fc46

CLI for Postgres Database. With auto-completion and syntax highlighting

https://www.pgcli.com/

sudo dnf install pgcli
  • License: BSD-3-Clause
  • Category: Unspecified
  • Architecture: noarch
  • Source Package: pgcli
  • 3 dependencies
  • 6 provides
  • normalized package name match
  • Matched by: Pgcli
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: pgcli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst
dnf95%

python3-pgcli+keyring 4.6.0-1.fc46

Metapackage for python3-pgcli: keyring extras

https://www.pgcli.com/

sudo dnf install python3-pgcli+keyring
  • License: BSD-3-Clause
  • Category: Unspecified
  • Architecture: noarch
  • Source Package: pgcli
  • 3 dependencies
  • 5 provides
  • normalized package name match
  • Matched by: Pgcli
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: python3-pgcli+keyring from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst
dnf95%

python3-pgcli+sshtunnel 4.6.0-1.fc46

Metapackage for python3-pgcli: sshtunnel extras

https://www.pgcli.com/

sudo dnf install python3-pgcli+sshtunnel
  • License: BSD-3-Clause
  • Category: Unspecified
  • Architecture: noarch
  • Source Package: pgcli
  • 3 dependencies
  • 5 provides
  • normalized package name match
  • Matched by: Pgcli
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: python3-pgcli+sshtunnel from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst
pacman95%

pgcli 4.6.0-1

A command line interface for PostgreSQL with auto-completion and syntax highlighting

https://www.pgcli.com/

sudo pacman -S pgcli
  • License: BSD-3-Clause
  • Architecture: any
  • 11 dependencies
  • 2 optional deps
  • normalized package name match
  • Matched by: Pgcli
Arch Linux sync databases · geo.mirror.pkgbuild.com · Arch Linux sync databases: pgcli from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz
MacPorts95%

pgcli

sudo port install pgcli
  • normalized package name match
  • Matched by: Pgcli
MacPorts ports tree · api.github.com · MacPorts ports tree: databases/pgcli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Related tools

  • python@3.14Runtime dependency declared by Homebrew.
  • libpqRuntime dependency declared by Homebrew.

Same workflow

  • litecliShares pkgdb curated category or tags: autocomplete, cli, database, database-client, developer-tools.
  • pgbouncerShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pg_partmanShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbadgerShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pg-schema-diffShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbackrestShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated configuration and credential file locations
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment
  • pkg.so package database
  • pkgdb category and tag curation