pgcmd

pgcmd is a non-interactive PostgreSQL query tool designed for use from the command line. Version 1.2.0 (current stable) outputs results in JSON by default, making them pipeable to tools like jq, and also supports CSV output. It is released under the MIT license with a low release cadence (last update 2020). Key differentiators: minimal dependencies, simple CLI, and supports parameterized queries via -m options. Compared to psql, it offers machine-friendly output with no interactive features.