| Port details |
- pgbot Read-only observability and health reports for PostgreSQL
- 0.8.1 databases
 =1      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-09-07 01:58:36
- Commit Hash: e5ca6d7
- People watching this port, also watch:: zrep
- 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 = 1788720551
SHA256 (go/databases_pgbot/pgbot-v0.8.1/v0.8.1.mod) = 634784d1e8f02b00d6a942c6a3e53d555864bca9a730916cdead612709b7f061
SIZE (go/databases_pgbot/pgbot-v0.8.1/v0.8.1.mod) = 2004
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- go127 : lang/go127
- Fetch dependencies:
-
- go127 : lang/go127
- This port is required by:
- for Run
-
- databases/pgterm
Configuration Options:- No options to configure
- Options name:
- databases_pgbot
- USES:
- go:1.27,modules zip
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
0.8.1
07 Sep 2026 01:58:36
 |
Jimmy Olgeni (olgeni) |
databases/pgbot: Update to 0.8.1
Upstream now requires Go 1.27, so pin USES=go:1.27,modules. |
0.7.2
04 Sep 2026 12:53:11
|
Jimmy Olgeni (olgeni) |
databases/pgbot: Update to 0.7.2 |
0.6.0_1
03 Sep 2026 04:50:55
|
Adam Weinberger (adamw) |
many: Bump go ports for 1.26.8 and 1.27.1 |
0.6.0
01 Sep 2026 19:23:02
|
Jimmy Olgeni (olgeni) |
databases/pgbot: Update to 0.6.0 |
0.5.1
29 Aug 2026 11:31:38
|
Jimmy Olgeni (olgeni) |
databases/pgbot: New port: Read-only observability and health reports for
PostgreSQL |
As an Amazon Associate I earn from qualifying purchases.