CortexRidge has released pgSherpa, a free desktop companion for PostgreSQL on macOS, now available on the Mac App Store.
pgSherpa sits in a corner of the screen and polls one or more PostgreSQL servers (PostgreSQL 12 to 18). When something needs attention it says so in a sentence, with the rows behind it:
- Health: lock-wait chains, long-running and idle-in-transaction sessions, replication lag and replication slots, vacuum and transaction ID wraparound, connection limits.
- Security: the server's version compared with the latest PostgreSQL minor release and the CVEs fixed since, plus configuration such as SSL, MD5 passwords and superuser count.
- Cloud: backups, failovers, maintenance windows and replicas for DigitalOcean Managed Databases, Supabase and Amazon RDS / Aurora PostgreSQL, read from the provider's API.
- SQL: a query box with PostgreSQL completion and
\hsyntax help for the server's own version. Every statement runs in a read-only transaction unless the user switches it to write. - Reports: ready-made views of
pg_stat_activity,pg_locks,pg_stat_statements, vacuum progress, indexes and replication.
pgSherpa needs only a role with pg_monitor. It installs no extension and no agent on the server, and it has no account and no telemetry; passwords and keys stay in the macOS Keychain.
It runs on macOS 12 or later, on Apple silicon and Intel Macs.
- Mac App Store: https://apps.apple.com/app/id6833955115
- More information: https://cortexridge.com/