# Install pgcli with pip
CLI for Postgres Database. With auto-completion and syntax highlighting. Version 4.5.0 via PyPI; verified from local package data.
## Install
```sh
sudo av install pip:pgcli
```
Additional install commands:
### Portable and language managers
- pip (100%):
```sh
pip install pgcli
```
Evidence: local PyPI package metadata
## Package facts
- **Package key:** pip:pgcli
- **Package manager:** PyPI
- **Package manager page:**
- **Version:** 4.5.0
- **Source summary:** CLI for Postgres Database. With auto-completion and syntax highlighting.
- **Homepage:**
- **Upstream docs:**
- **License:** BSD
- **Source archive:**
- **Published:** 2026-06-03T00:03:19.371033Z
- **Generated:** 2026-07-07T07:26:23+00:00
## Executables
- pgcli (cli)
## Dependencies
- Pygments
- behave
- cli_helpers
- click
- configobj
- coverage
- docutils
- keyring
- keyrings.alt
- pexpect
- pgspecial
- prompt_toolkit
- psycopg
- psycopg-binary
- pytest
- pytest-cov
- ruff
- setproctitle
- sqlparse
- sshtunnel
- tox
- tzlocal
## Install behavior
- Python requires: >=3.10
- PyPI dependency specs: 22
- Bottle: not available
## Freshness
- Page generated: 2026-07-07
- Package-manager version: 4.5.0
- Package-manager updated: 2026-06-03
- Local data: ok
- Upstream repository: https://pgcli.com
- info: Release/tag comparison is only available for GitHub repositories.
## Security Notes
No matching local secret-handling manifest was found for pgcli. Nucleus package metadata is still published here so future coverage has a stable package URL.
## Source Database Details
- **Source Database:** PyPI JSON API
- **Release Count:** 53
- **Files For Latest:** 2
- **Package Types:** bdist_wheel, sdist
- **Requires Python:** >=3.10
- **Latest Serial:** 37,661,086
- **Latest Upload At:** 2026-06-03T00:03:19.371033Z
- **Vulnerability Count:** 0
- **Yanked File Count:** 0
- **Author Email:** Pgcli Core Team
## Other Package-Manager Records
- Debian apt - pgcli - 4.3.0-2: normalized package name match | Debian stable package indexes: pgcli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | CLI for PostgreSQL with auto-completion and syntax highlighting | https://www.pgcli.com
- Nix - pgcli: normalized package name match | nixpkgs package indexes: pgcli from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix
- Ubuntu apt - pgcli - 4.0.1-1: normalized package name match | Ubuntu 24.04 LTS package indexes: pgcli from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | CLI for PostgreSQL with auto-completion and syntax highlighting | https://www.pgcli.com
- apk - pgcli - 4.5.0-r0: normalized package name match | Alpine Linux edge package indexes: pgcli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | Postgres CLI with autocompletion and syntax highlighting | https://www.pgcli.com
- apk - pgcli-pyc - 4.5.0-r0: normalized package name match | Alpine Linux edge package indexes: pgcli-pyc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | Precompiled Python bytecode for pgcli | https://www.pgcli.com
- dnf - pgcli - 4.5.0-2.fc45: normalized package name match | Fedora Rawhide package metadata: pgcli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | CLI for Postgres Database. With auto-completion and syntax highlighting | https://www.pgcli.com/
- dnf - python3-pgcli+keyring - 4.5.0-2.fc45: normalized package name match | Fedora Rawhide package metadata: python3-pgcli+keyring from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Metapackage for python3-pgcli: keyring extras | https://www.pgcli.com/
- dnf - python3-pgcli+sshtunnel - 4.5.0-2.fc45: normalized package name match | Fedora Rawhide package metadata: python3-pgcli+sshtunnel from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst | Metapackage for python3-pgcli: sshtunnel extras | https://www.pgcli.com/
- pacman - pgcli - 4.5.0-1: normalized package name match | Arch Linux sync databases: pgcli from https://geo.mirror.pkgbuild.com/extra/os/x86_64/extra.db.tar.gz | A command line interface for PostgreSQL with auto-completion and syntax highlighting | https://www.pgcli.com/
- MacPorts - pgcli: normalized package name match | MacPorts ports tree: databases/pgcli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1
## Related links
- [Database and data packages](https://www.automicvault.com/pkg/database-data-tools/) - Matched curated package taxonomy and local package facts.
- [pgcli](https://www.automicvault.com/pkg/brew/pgcli/) - Same normalized package name appears in another local ecosystem. Shared terms: auto, auto-completion, completion, database, highlighting.
- [psycopg2](https://www.automicvault.com/pkg/pip/psycopg2/) - Both packages touch the same language runtime or ecosystem. Shared terms: audience, database, developers, intended, language.
- [litecli](https://www.automicvault.com/pkg/brew/litecli/) - Both packages touch the same language runtime or ecosystem. Shared terms: auto, auto-completion, completion, database, highlighting.
- [pgcli](https://www.automicvault.com/pkg/brew/pgcli/) - Same normalized package name exists in another local package ecosystem.
## Sources
- Python package overlay metadata
- package-page enrichment
- package version freshness
- package relationship graph
- external package-manager database matches
- cross-ecosystem install command graph