| Port details |
- pgbot Read-only observability and health reports for PostgreSQL
- 0.5.1 databases
 =0      Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one. - Maintainer: olgeni@FreeBSD.org
- Port Added: 2026-08-29 11:33:06
- Last Update: 2026-08-29 11:31:38
- Commit Hash: cd48829
- License: APACHE20
- WWW:
- https://pgbot.dev/
- https://github.com/pgrundev/pgbot
- Description:
- pgbot is a single static binary that connects to a PostgreSQL server with
a read-only role, reads the server's own statistics views and prints a
findings-first health report, including what changed since the previous
run. It needs no agent, no external service and no write privilege
anywhere in the path.
Features:
- Checks connections, cache hit ratio, locks, slow and regressed queries,
unused and missing indexes, table bloat, vacuum and replication lag
- Findings are ranked by severity, with a per-database health score
- Snapshots are stored locally so consecutive runs can be diffed
- Versioned --json output with a published JSON Schema, plus SARIF output
for CI integration
- Works as an MCP server so AI agents and applications can query it
- Supports PostgreSQL 14 through 18
pgbot is the diagnostic engine behind pgterm (databases/pgterm).
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - USE_RC_SUBR (Service Scripts)
- no SUBR information found for this port
- Dependency lines:
-
- To install the port:
- cd /usr/ports/databases/pgbot/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/pgbot
- pkg install pgbot
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: pgbot
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1787912380
SHA256 (go/databases_pgbot/pgbot-v0.5.1/v0.5.1.mod) = fcd3ee5513ac4eb3b21069f94af6fab604a3811c9ceb1b462779c72dbd1c7c94
SIZE (go/databases_pgbot/pgbot-v0.5.1/v0.5.1.mod) = 1917
No package information for this port in our database- Sometimes this happens. Not all ports have packages. This is doubly so for new ports, like this one.
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- go126 : lang/go126
- Fetch dependencies:
-
- go126 : lang/go126
- This port is required by:
- for Run
-
- databases/pgterm
Configuration Options:- No options to configure
- Options name:
- databases_pgbot
- USES:
- go:modules zip
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
As an Amazon Associate I earn from qualifying purchases.
