Databases & Storage

pgSherpa launches as free macOS desktop monitor for PostgreSQL 12-18

Key Takeaway

pgSherpa is a zero-install, agentless PostgreSQL monitoring tool for macOS that requires only pg_monitor privileges and reads cloud APIs for managed database services.

Summary

CortexRidge has released pgSherpa, a free macOS desktop application for monitoring PostgreSQL servers without installing extensions or agents on the database host. The tool supports PostgreSQL versions 12 through 18 and provides health, security, cloud, SQL query, and reporting capabilities through a corner-of-screen interface that polls servers and surfaces issues in plain language with underlying data rows.

pgSherpa distinguishes itself through minimal server footprint: it needs only a role with the pg_monitor system privilege, stores credentials in the macOS Keychain, and transmits no telemetry. For cloud deployments, it integrates directly with provider APIs to display backup status, failover events, maintenance windows, and replica topology for DigitalOcean Managed Databases, Supabase, and Amazon RDS/Aurora PostgreSQL. The built-in SQL query box runs statements in read-only transactions by default, with PostgreSQL-specific completion and \h syntax help tailored to the connected server's version.

Architecture and operational model

  • Agentless monitoring: pgSherpa requires no server-side extension, agent, or account creation; it authenticates using standard PostgreSQL roles and stores passwords and API keys in the macOS Keychain.
  • Privilege scope: The tool functions with only the pg_monitor built-in role, avoiding superuser requirements or custom extension installations on monitored databases.
  • Health diagnostics: Lock-wait chains, long-running and idle-in-transaction sessions, replication lag and slot status, vacuum progress, transaction ID wraparound risk, and connection limit proximity are all polled and summarized.
  • Security posture checks: Version comparison against latest PostgreSQL minor releases with CVE enumeration, plus configuration audits for SSL, MD5 password usage, and superuser count.
  • Cloud API integration: Direct reads from DigitalOcean, Supabase, and Amazon RDS/Aurora APIs expose managed-database operational events including backups, failovers, and maintenance scheduling without requiring database-level access to those metadata.

Why it matters

pgSherpa fills a gap for macOS-based developers and database administrators who need lightweight, privacy-respecting PostgreSQL visibility without the infrastructure overhead of web-based monitoring stacks like pgAdmin or Prometheus/Grafana. Its agentless design and read-only-default query execution reduce operational risk and deployment friction, particularly for consultants and teams managing heterogeneous PostgreSQL fleets across self-hosted and cloud-managed environments.

Original reference: www.postgresql.org →