GitHub - pgrundev/pgterm: Postgres Terminal
Postgres Terminal. Contribute to pgrundev/pgterm development by creating an account on GitHub.
Database Utility
Summary
pgbot is a lightweight, read-only diagnostic tool designed to provide PostgreSQL health reports and structured intelligence for AI agents. It identifies critical database issues and offers both human-readable summaries and machine-readable JSON/MCP outputs for automated workflows.
Highlights
- Single static binary requiring only read-only access and no external services
- Provides graded health reports (CRITICAL, WARNING, GOOD) with baseline comparison
- Supports machine-readable integration via versioned JSON and Model Context Protocol (MCP)
- Optional AI layer for natural-language explanations of database findings
auto-generated
Context
Audience
Database Administrators, DevOps Engineers, and AI Application Developers
DomainDatabase Administration
FormatCommand-line tool
AccessOpen source
Source Overview
pgbot is a single static binary that connects read-only to PostgreSQL 14-18, reads internal statistics views, and prints a graded health report with findings bucketed as CRITICAL, WARNING, or GOOD.
Each run saves a local baseline so later runs report what changed, and a versioned JSON contract plus MCP endpoint expose structured findings to agents and scripts. An optional AI layer adds natural-language explanations; the tool requires only a pg_monitor role and no external service or write privilege.
Topics
Related
PostgreSQLAI AgentsModel Context ProtocolDatabase ObservabilityDevOps
