PostgreSQL monitoring + a local SQL copilot.
Nothing leaves your network. Self-hosted, no cloud, no agents phoning home. Connect to any Postgres instance — RDS, Aurora, self-hosted — and get always-on health checks, slow-query analysis, bloat estimates, and replication lag. Plus an AI that writes SQL from English, running entirely on your hardware. No API key, no subscription, no account required.
macOS: unsigned app — right-click → Open to bypass Gatekeeper on first launch.
Free — the Postgres health-check checklist
The 12 checks pginsights runs on every tick — table bloat and dead
tuples, transaction-ID wraparound risk, autovacuum lag, cache hit ratio,
connection saturation, inactive replication slots, replica replay lag, and
more — each with the exact query to run it by hand.
[Read it now →](/postgres-health-checklist.html)
Or leave your email and we’ll send it over, plus release announcements.
See it in action
Dashboard
Why pginsights
Bridges raw system metrics and AI-driven database intelligence. Health checks, query analysis, and SQL generation in one self-hosted tool.
Total data residency for security-conscious and air-gapped environments. No telemetry, no cloud backend, no account required.
No third-party SaaS agents or external data hosting. The monitoring collector, the dashboard, and the local AI model all run on hardware you control.
Zero external connectivity required for operation. Every Postgres connection runs read-only. Credentials never leave instances.json on your filesystem.
Monitoring
pginsights connects only to `pg_stat_*` catalog views — read-only,
no schema changes, no extensions beyond `pg_stat_statements`.
Health checks fire on every collector tick and surface findings on the
Alerts tab, with webhook, Slack, and email delivery built in.
max_connections
Privacy & control
pginsights has no cloud backend, no telemetry, and no account system. Run it on your laptop, a bastion host, or behind an air gap. Everything is stored in a local SQLite file you own outright.
Connection strings live in instances.json. Metric history lives in timeseries.db. Nothing is uploaded anywhere.
Every Postgres connection runs with SET default_transaction_read_only = on. pginsights cannot write to your database.
The SQL Author runs a quantized model on your hardware. Your English prompts and schema never leave your machine.
Any Postgres-compatible instance — cloud or on-prem. Bundles ship with a complete Node runtime. No internet required to run.
Pricing
Pricing may change before general availability — early access signups get it locked in.
Download
x86-64 · Ubuntu 22+, Debian 11+, RHEL 9+