Skip to content
PostgreSQL

pgSherpa: a PostgreSQL companion for your Mac, now on the Mac App Store

A small mountain guide who stands in the corner of your screen and tells you, in plain words, when your PostgreSQL servers need you. Free.

D
2 min read
pgSherpa on a Mac desktop: the mountain guide stands in the corner, with the Overview panel open above him saying All good.

pgSherpa is a small mountain guide who stands in the corner of your Mac’s screen and watches your PostgreSQL servers. While they are fine, he stays out of the way. When one needs you, he says so in a sentence.

He is now on the Mac App Store, and he is free.

He tells you when something is wrong

Locks, long queries, replication, vacuum, wraparound, connections. One card per problem, with the rows behind it. That is the picture above: all good, with three notes worth a look.

He knows where your version stands

Your server against the latest PostgreSQL release and the known CVEs.

pgSherpa's Security panel: running PostgreSQL 17.8, latest 17.12, four releases behind, 36 CVEs fixed in 17.12.

He sees what your cloud does

Backups, failovers, maintenance and replicas, read from your provider’s account.

DigitalOcean, Supabase and AWS today. Google Cloud, Azure and Oracle Cloud are coming.

pgSherpa's Cloud panel listing a DigitalOcean database with its backup, point-in-time recovery, replica and maintenance window.

SQL, right beside him

PostgreSQL completion and formatting, and results you can sort, filter and copy. Read-only until you say otherwise.

pgSherpa's SQL box beside him, with a query against pg_stat_database and its results in the panel above.

Ready-made reports

Sessions, locks, queries, vacuum, indexes, tables, replication. One click each, always read-only.

pgSherpa's Actions panel with reports such as Active queries, Who blocks whom and Locks held and awaited.

Safe on production

  • He only reads. Every statement runs in a read-only transaction; writing takes a switch and Touch ID or your password.
  • He needs little. A role with pg_monitor. No extension, no agent.
  • He collects nothing. No account, no telemetry. Your passwords and keys stay in your Mac’s Keychain.

Get him

Download pgSherpa on the Mac App Store. It is free, and it runs on any Mac with macOS 12 or later. Direct downloads are on the home page.

Tell me what he gets wrong or what he is missing: open an issue.

Keep reading

All articles →

Contact

Talk to CortexRidge.

A question about the product, a pilot, or your data stack — it reaches us directly.