pgcli is a command-line PostgreSQL client with auto-completion and syntax colouring, built for quick interactive querying directly from the terminal. Features include:

• Context-aware suggestions that surface tables, columns or keywords as you type
• Fuzzy filter on history
• Syntax highlighting
• Multi-line editing
• Smart pager selection
• Auto switch to vertical output when a result exceeds terminal width
• Configurable row-limit prompt
• Primitive support for psql slash commands
• Optional warnings before destructive statements
• Rich configuration file for prompts and colours