HeadlinesBriefing favicon HeadlinesBriefing.com

Pgbot: 5.9 MB Read-Only Postgres Tool for Humans and Agents

Hacker News •
×

Nobody reads database metrics. pgbot does. Connect your Postgres. Get answers, not dashboards: what's healthy, what's broken, and what to fix first. It works with any cloud, connecting directly over the wire or via an agent next to a database that never leaves your network.

Features include real-time database health monitoring (connections, locks, transactions, cache hit ratio, replication, WAL), query performance tracking (slow queries, regressions, throughput, latency, expensive SQL), and table/index analysis (growth, usage, unused or missing indexes, vacuum activity, storage patterns). AI-powered insights let you ask questions in plain English and get summaries, explanations, and recommendations based on real signals.

pgbot mcp speaks the Model Context Protocol on stdio, so an AI agent can call it as a read-only tool. It exposes deterministic tools only — inspect and unused_indexes — and lets the connected model do the explaining. No Gemini key involved. Add it to any MCP client like Claude Desktop or Cursor.

Read-only by construction: pgbot never writes, so there's nothing an agent can break. It also offers a diagnose prompt for prioritized diagnosis and a baselines resource for local history. Use it with Supabase, Neon, RDS, Docker, Kubernetes, and private servers. Not just observability — an AI DBA.