/
pgterm
pgbot features GitHub

Modern Postgres Terminal

A fast, open-source Postgres terminal written in Rust. 🦀🐘
Connect and monitor all your databases from one place
with pgbot built in for deeper diagnostics.

$ curl -fsSL https://pgterm.dev/install.sh | sh {{ copyLabel }}
Native Rust · Open Source · PgBot built in
PGTerm screenshot
Features

Connect any PostgreSQL database and get visibility into performance, schema, and health — with PgBot built in.

01
All databases. One workspace.

Connect your Postgres databases once and switch between local, staging, production and cloud databases instantly.

02
Native by default.

Built in Rust. No Electron. Fast, lightweight desktop experience.

03
Postgres intelligence built in.

PgBot helps diagnose queries, indexes, locks, vacuum, replication and configuration directly inside PGTerm.

PgBot

Ask your database what's wrong.

> What's slowing this database down?
> Which indexes should I investigate?
> Why did performance change?

# Deterministic diagnostics first. AI explanation second.

Workspace

SQL, data, diagnostics. One place.

$ run sql
$ browse tables and data
$ switch between databases
$ inspect schemas
$ diagnose postgres with pgbot
How it works
01
Install pgterm

Run one command and open it in your terminal.

02
Add your databases

Connect local, staging, or production Postgres.

03
Monitor & inspect

See activity, queries, indexes, and open pgbot for deeper diagnostics.

FAQ
Is pgterm free?

Yes. Free and open source.

Does it work with any Postgres?

Yes. If you have a Postgres connection URL, you can add it.

Does it read table data?

No. pgterm is built around Postgres monitoring and stats.

Prefer the terminal?

The original PGTerm TUI remains available.

$ curl -fsSL https://pgterm.dev/install.sh | sh {{ copyLabel }}

Your Postgres. One terminal.

Download PGTerm
macOS · Linux · Open Source