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 \h syntax 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.