pgSherpa

PostgreSQL DBA companion

Only for Mac

Free

Mac

pgSherpa watches your PostgreSQL servers from the corner of your screen and tells you, in plain words, when something needs you. pgSherpa is a PostgreSQL companion that lives on your desktop. A small mountain guide stands in the corner of your screen, watches your servers, and tells you in plain words when something needs you. HEALTH One card per problem, with the rows behind it: lock queues and who blocks whom, long-running and idle-in-transaction sessions, replication lag and slots, vacuum and wraparound, connection limits, WAL and archiving. SECURITY Your server's version against the latest PostgreSQL release and known CVEs, plus configuration worth fixing. CLOUD Backups, failovers, maintenance windows, read replicas and resizes on DigitalOcean Managed Databases and Supabase, using a read-only token. SQL, READ-ONLY BY DEFAULT A SQL box beside him with PostgreSQL completion and formatting. To write, click its prompt and confirm with Touch ID or your password. Sort, filter and copy results. Ready-made reports for sessions, queries, vacuum, indexes, tables and replication. ASK Ask questions about your database and get answers that use live data, through the Claude API with your own Anthropic API key. ALERTS Desktop notifications for critical problems, and optionally Slack and PagerDuty. SAFE BY DESIGN pgSherpa reads by default. Every statement runs in a read-only transaction unless you switch the SQL box to write, which macOS confirms with Touch ID or your password. It never changes anything at a cloud provider. No analytics, no telemetry, no account: your settings stay on your Mac. Tested with PostgreSQL 16 and 17, self-hosted or managed. A role with pg_monitor is enough.

  • This app hasn’t received enough ratings or reviews to display an overview.

- Now for Intel Macs as well as Apple silicon - \h in the SQL box: type \h create index for that command's syntax in your server's PostgreSQL version (12 to 18); \h alone lists the commands - Servers are on the Overview (Health, Metrics, Servers): the list, adding one, changing one - Clearer, sharper text, most of all on displays that are not Retina - Text size (Settings, App, or Command + and Command -) and a choice of font - An eye on every password, key and token field shows what is typed - Click the ! or ? beside him and he says why; a click on him opens the panel on that problem - About (Settings, About): who makes pgSherpa, with support and privacy one click away - Changing a setting no longer asks for the Keychain password when no password or key was changed

The developer, rupeecom, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Not Collected

    The developer does not collect any data from this app.

    Privacy practices may vary, for example, based on the features you use or your age. Learn More

    The developer has not yet indicated which accessibility features this app supports. Learn More

    Seller
    BillionBright Solutions LLP
    Size
    312.6 MB
    Category
    Developer Tools
    Compatibility
    Requires macOS 12.0 or later.
    • Mac
      Requires macOS 12.0 or later.
    Languages
    English
    Age Rating
    4+
    Copyright
    © 2026 BillionBright Solutions LLP