Pgbot: A 5.9 MB read-only Postgres tool for humans and agents

pgbot is a lightweight, open-source tool that connects to PostgreSQL databases to provide AI-powered insights into database health, performance, and query optimization through a command-line interface. It offers read-only access with features like real-time health monitoring, slow query detection, index analysis, and plain-English explanations powered by AI, and can be integrated as an agent tool via the Model Context Protocol. The tool supports any PostgreSQL deployment—from cloud providers to private networks—while maintaining security through its read-only construction and open-source agent design.