pgcli ☆

« Back to VersTracker

Description:
CLI for Postgres with auto-completion and syntax highlighting

Type: Formula | Latest Version: 4.3.0@0 | Tracked Since: Dec 25, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql database cli sql developer-tools

Install: brew install pgcli

About:
pgcli is a feature-rich command-line interface for PostgreSQL that significantly enhances the default psql experience. It provides intelligent auto-completion for database schemas, tables, and SQL syntax as you type. Additionally, it offers syntax highlighting to make queries and results more readable and visually distinct.

Key Features:

Intelligent auto-completion for SQL and database objects
Syntax highlighting for queries and output
Support for connection profiles and SSL connections
Prettified, scrollable output tables

Use Cases:

Interactive database exploration and schema discovery
Writing and testing complex SQL queries efficiently
Daily database administration and management tasks

Alternatives:

psql – The standard, ubiquitous PostgreSQL CLI; lacks built-in auto-completion and syntax highlighting out of the box.
mycli – A similar tool for MySQL/MariaDB, offering the same core feature set of auto-completion and syntax highlighting.

Version History

Detected	Version	Rev	Change	Commit
Dec 25, 2025 2:58am	4.3.0	0	VERSION_BUMP	2bbb0c71
Oct 9, 2024 8:22pm		1	VERSION_BUMP	52eab00d
Feb 17, 2024 5:40pm		0	VERSION_BUMP	c7353cff
Jan 11, 2024 5:19pm		0	VERSION_BUMP	6cedff11
Oct 27, 2023 5:13pm		0	VERSION_BUMP	569e72ae
Oct 6, 2023 3:07am		1	VERSION_BUMP	62d7c60f
Nov 28, 2022 10:16pm		1	VERSION_BUMP	1d26a2ae
Nov 23, 2022 6:26am		0	VERSION_BUMP	1ad89d16
Nov 22, 2022 9:05am		0	VERSION_BUMP	ac0af49d
Nov 22, 2022 9:04am		0	VERSION_BUMP	dae18d64