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