pgterm

pgterm is a read-only interactive terminal UI for monitoring multiple PostgreSQL databases. It presents one tab per database and runs background checks through the pgbot diagnostic engine, surfacing database health, blocked locks, query regressions, unused indexes, vacuum status, replication lag, connections, and cache statistics.

The interface provides views for inspection, queries, indexes, tables, and explanations, along with a command bar and configurable check intervals. Databases can be added from environment-variable references or session-only connection strings; configuration stores variable names rather than credentials, and connection strings are passed to pgbot through the child-process environment. The tool runs only whitelisted diagnostics and has no SQL console, shell, or repair action.

It is distributed as a platform-specific installer or a Rust source build for Linux and macOS on amd64 and arm64 systems. The repository is licensed under Apache-2.0.