# Pginsights – self-hosted Postgres monitoring that never leaves your network

> Source: <https://pginsights.dev>
> Published: 2026-09-07 14:28:13+00:00

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+