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

Aug 26, 2026 01:30 AM - 1 hour ago 1

Open root · Go · FREE

Nobody sounds database metrics. pgbot does.

Connect your Postgres. Get answers, not dashboards: what's healthy, what's broken, and what to hole first.

$ curl -fsSL https://pgbot.dev/install | sh

pgbot

Works pinch immoderate cloud:

pgrun

How it connects

Two paths to the aforesaid place: link straight complete the wire, aliases tally the supplier adjacent to a database that ne'er leaves your network.

pgbot.dev │ ┌───────────────────┴───────────────────┐ │ │ Direct PostgreSQL access pgBot agent │ │ Supabase · Neon · RDS Docker · Kubernetes PlanetScale · nationalist DBs Private servers · VPC │ │ └───────────────────┬───────────────────┘ ▼ PostgreSQL

Features

Connect immoderate PostgreSQL database and get visibility into performance, queries, health, schema, and changes — pinch AI-powered explanations.

See database wellness successful existent time

Monitor connections, locks, transactions, cache deed ratio, replication, WAL, and wide database health.

Understand query performance

Track slow queries, regressions, throughput, query latency, and costly SQL utilizing PostgreSQL statistics.

Inspect tables and indexes

Analyze array growth, scale usage, unused indexes, missing indexes, vacuum activity, and retention patterns.

Get AI-powered insights

Ask pgBot questions successful plain English and get summaries, explanations, and recommendations based connected existent database signals.

Works pinch immoderate PostgreSQL

Connect straight to nationalist databases aliases usage the pgBot Agent for backstage environments for illustration Docker, Kubernetes, and soul servers.

Built for unafraid accumulation use

Read-only access, open-source agent, and support for backstage deployments without exposing your database publicly.

MCP — usage pgbot arsenic an supplier tool

pgbot mcp speaks the Model Context Protocol connected stdio, truthful an AI supplier tin telephone pgbot arsenic a read-only tool. It exposes deterministic devices only — inspect (full findings arsenic JSON) and unused_indexes — and lets the connected exemplary do the explaining. No Gemini cardinal involved: the supplier reasons complete the aforesaid findings the CLI computes.

Add it to immoderate MCP customer (Claude Desktop/Code, Cursor, …)

{ "mcpServers": { "pgbot": { "command": "pgbot", "args": ["mcp"], "env": { "DATABASE_URL": "postgres://pgbot_ro@host:5432/db" } } } }

Read-only by construction

With DATABASE_URL set, the supplier calls inspect pinch nary arguments; aliases it tin walk connection_string per telephone to scope respective databases. pgbot ne'er writes, truthful there's thing an supplier tin break done it.

Tools, prompts, and resources

It besides exposes a diagnose punctual — a one-click "inspect and springiness maine a prioritized diagnosis" workflow — and a pgbot://baselines assets listing the databases pgbot has section history for.