GitHub - pgrundev/pgbot: Postgres intelligence for ai agents & apps
Postgres intelligence for ai agents & apps. Contribute to pgrundev/pgbot development by creating an account on GitHub.
Database Monitoring Tool
Summary
pgterm is an interactive terminal UI designed to monitor multiple PostgreSQL databases simultaneously, functioning much like 'htop' for database health. It leverages pgbot's read-only diagnostics to provide real-time visibility into connections, locks, queries, indexes, and replication status across a tabbed interface.
Highlights
- Multi-tabbed interface allows for monitoring several PostgreSQL databases in a single view
- Provides real-time health metrics including locks, query regressions, unused indexes, and replication lag
- Uses pgbot as a read-only diagnostic engine to ensure monitoring is non-intrusive and safe
- Security-focused design with masked connection strings and no SQL console or shell access
- Easy installation via shell script or building from source using Rust/Cargo
auto-generated
Context
Audience
Database Administrators, DevOps Engineers, and Backend Developers
DomainDatabase Administration
FormatTerminal User Interface
AccessOpen source
Source Overview
pgterm is a terminal UI that monitors multiple PostgreSQL databases in tabbed views, showing metrics for connections, locks, queries, indexes, vacuum, and replication via pgbot's read-only diagnostics.
Databases are configured through environment variables; connection strings are masked, held in memory only, and never written to disk. It installs via shell script or cargo build on Linux and macOS (amd64/arm64) and runs strictly read-only with no SQL console or shell access.
Topics
Related
PostgreSQLpgbotRustDevOpsDatabase Observability
