安装

其他安装命令

macOS

Homebrew已验证 · 100%

brew install pgcli

local Homebrew formula metadata

MacPorts已验证 · 94%

sudo port install pgcli

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

Linux

Alpine Linux apk已验证 · 92%

sudo apk add pgcli

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

Debian apt已验证 · 92%

sudo apt install pgcli

Debian stable package indexes · pgcli · 来源: deb.debian.org

Fedora dnf已验证 · 92%

sudo dnf install pgcli

Fedora Rawhide package metadata · pgcli · 来源: dl.fedoraproject.org

Nix已验证 · 92%

nix profile install nixpkgs#pgcli

nixpkgs package indexes · pgcli · 来源: raw.githubusercontent.com

Arch Linux pacman已验证 · 92%

sudo pacman -S pgcli

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

概览

软件包摘要

CLI for Postgres with auto-completion and syntax highlighting

项目链接

命令和别名

pgcli

历史

项目历史与用法

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

项目历史

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.

采用历史

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.

使用方式

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.

为什么软件包爱好者会关心

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.

时间线

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.

来源

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

安全态势

风险级别：绿色

narrow executable package without higher-risk signals.

风险分类器

绿色风险 · 低置信度 · appliance

原因

narrow executable package without higher-risk signals

信号

metadata:no-higher-risk-signals

安装行为

formula 元数据中未记录 Homebrew post-install 钩子。
Homebrew bottle 元数据适用于 6 个平台目标。
安装时包含 2 个运行时依赖。

建议审查

在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。

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

可执行文件

已安装的可执行文件

命令	类型	暴露范围	备注
`pgcli`	cli	全局可执行文件

新鲜度

版本和新鲜度

这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。

页面生成时间2026-09-19

管理器版本4.6.0

管理器更新时间2026-09-12

本地数据OK

上游not checked

检测到的最新版本未检测到

https://pgcli.com/

信息Release/tag comparison is only available for GitHub repositories.https://pgcli.com/none 置信度

安装元数据

软件包元数据

软件包键	brew:pgcli
版本	4.6.0
软件包管理器	Homebrew
软件包管理器页面	https://formulae.brew.sh/formula/pgcli
主页	https://pgcli.com/
上游文档	https://pgcli.com/
许可证	BSD-3-Clause
源码归档	https://files.pythonhosted.org/packages/97/5d/d6fcf98556e6089915e12af12c6189e9d774d82b473c4ce9e124a62ec235/pgcli-4.6.0.tar.gz
最后更新	2026-09-12T23:11:17Z
Pulse	updated
依赖	libpq, python@3.14
Bottle	可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	未定义
服务	未声明

注册表事实

源数据库详情

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	pgcli
Version Scheme	0
Revision	0
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	stable

源数据库匹配

其他软件包管理器记录

匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。

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 依赖
normalized package name match
匹配方式：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
匹配方式：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 依赖
normalized package name match
匹配方式：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 依赖
1 提供
normalized package name match
匹配方式：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 依赖
normalized package name match
匹配方式：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 依赖
6 提供
normalized package name match
匹配方式：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 依赖
5 提供
normalized package name match
匹配方式：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 依赖
5 提供
normalized package name match
匹配方式：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 依赖
2 可选依赖
normalized package name match
匹配方式：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
匹配方式：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

软件包图谱

链接来自本地软件包关系图、补充数据、依赖边、生态匹配和软件包 hub 归属。

来源线索

由仓库数据生成

此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。

Combined YAML source

View the package source record on GitHub.

combined/pgcli.yml

使用的来源

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

使用 Homebrew, apk, apt, dnf, MacPorts, Nix, pacman 安装 pgcli

其他安装命令

macOS

Linux

软件包摘要

项目链接

命令和别名

项目历史与用法

项目历史

采用历史

使用方式

为什么软件包爱好者会关心

时间线

Related projects

来源

风险级别：绿色

风险分类器

原因

信号

安装行为

建议审查

Configuration and credential file locations

Configuration files

Credential files

已安装的可执行文件

版本和新鲜度

软件包元数据

源数据库详情

其他软件包管理器记录

内部软件包链接

主题 hub

相关工具

相同工作流

代理安全指南

由仓库数据生成

Combined YAML source

使用的来源