pgcli

pgcli is a PostgreSQL client designed to improve the interactive query experience. It provides several quality-of-life features over the standard psql client, including: - Auto-completion: Suggests SQL keywords, table names, and column names as you type. - Smart-completion: Provides context-sensitive suggestions (e.g., suggesting only column names after a WHERE clause). - Syntax Highlighting: Uses Pygments to colorize SQL queries for better readability. - Data Presentation: Pretty prints tabular data and supports automatic vertical output if the result exceeds the terminal width. - Compatibility: Supports many psql back-slash commands and standard PostgreSQL environment variables for connection settings. It can be installed via pip, Homebrew, or system package managers, and can also be run as a Docker container or integrated into IPython via a magic extension.