Open Source · GPL-3.0 · Single Binary

Inspect PostgreSQL
from your terminal.

A fast, lightweight database browser that runs in your terminal. Browse tables with pagination, run SQL with autocomplete, export data as CSV/JSON/SQL — all from a single compiled binary. Perfect for remote support, quick data checks, and engineering workflows. Built with Rust for speed.

Buy Binary — $4.99 Build from source See features

~5 MB

Binary Size

TUI + Web

Two Interfaces

3 Formats

CSV · JSON · SQL

3 Platforms

macOS · Linux · Windows

01 — The Problem

You're opening pgAdmin just to check a few rows.

pgAdmin takes 15 seconds to open. TablePlus costs $89. DBeaver eats 1GB of RAM. DataGrip requires a JetBrains subscription. When you're SSH'd into a server or doing remote support, you just need to peek at a table — fast.

GUI Bloat

TablePlus, DBeaver, DataGrip — they load driver plugins, render UI frameworks, and cache schemas. Opening them feels slower than the query itself.

Remote Support Pain

When troubleshooting a customer's database over SSH, you can't run a GUI. You're stuck with psql and manual SELECT * queries.

Large Table Lag

psql prints 100k rows and your terminal scrolls forever. GUI tools page correctly but need installation and X11 forwarding on remote servers.

Export Hassle

Need a quick CSV of a query result? With psql it's \copy with delimiter config. With GUIs it's wizard dialogs. Both are slow when you just want the data.

02 — Features

Everything a database engineer needs. Nothing more.

A zero-dependency TUI that starts in milliseconds. Browse tables, run SQL, export data — all without leaving your terminal. Built-in Web UI for when you want a graphical view.

Table & View Browser

Sidebar navigation with row counts. Switch between Tables and Views. Filter by name with instant search. Vim-style keyboard shortcuts throughout.

Paginated Data View

Large tables? No problem. Built-in pagination loads 500 rows at a time with Prev/Next navigation. Real-time scrollbar shows your position. Copy TSV or JSON to clipboard.

SQL Query Editor

Interactive SQL editor with autocomplete for keywords, table names, and column names. Ctrl+S to run. Syntax highlighting for readability. Error messages shown inline.

Schema Inspector

View table schemas with column names, types, and row counts. Built-in SQL syntax highlighting for DDL statements.

Multi-Format Export

Download table or query results as CSV (Excel-ready), JSON (API-ready), or SQL INSERT statements. Full table or first 500 rows — you choose.

Horizontal Scroll

Wide tables with 30+ columns? Scroll horizontally with j/k keys in TUI mode or native scroll in Web mode. No truncated data.

Web UI Included

Launch with --ui flag for a full dark-theme web interface. Same features as the TUI. Use it for demos, screen sharing, or when you prefer a browser.

03 — Two Modes

Terminal or Browser. Same binary.

TUI MODE

Terminal Interface

Vim-style keybindings (i/k/j/l for navigation). Paginated table view with row counts. SQL editor with autocomplete and syntax highlighting. Copy menus with TSV/JSON options. Perfect for SSH sessions and daily engineering work.

WEB UI

Dark-Theme Web Interface

Launch with --ui. Full sidebar navigation, paginated data, SQL editor with autocomplete and syntax highlighting. Export with one click. Copy TSV/JSON to clipboard. Ideal for demos and team sharing.

04 — Quick Start

Three commands. That's it.

# Install in one command

sudo curl -L -o /usr/local/bin/postgrestui https://dl-postgrestui.voltrus.id/latest && sudo chmod +x /usr/local/bin/postgrestui

# Launch TUI mode (terminal interface)

postgrestui -s localhost -p 5432 -d mydb -u postgres

# Launch Web UI mode (browser on port 5000)

postgrestui -s localhost -d mydb -u postgres --ui

Pre-built binary $4.99 one-time · Build from source free on GitHub · macOS aarch64, Linux x86_64, Windows x86_64.

05 — Use Cases

Built for database engineers who live in the terminal.

REMOTE

Remote Support & Troubleshooting

SSH into a server, launch postgrestui, browse data in seconds. No X11 forwarding, no GUI required. Perfect for on-call engineers debugging production issues.

DEV

Development & Testing

Quickly inspect data during development. Run ad-hoc queries, check schema, verify test data. Starts faster than any GUI tool.

AUDIT

Data Audits & Compliance

Export full table data as CSV for auditors. Query and download specific date ranges. All from the command line — scriptable and repeatable.

DEMO

Client Demos & Screen Sharing

Launch the Web UI for client-facing demos. Beautiful dark theme. Browse data, run queries, export results — all in a browser tab.

06 — FAQ

Common questions

Both. PostgresTUI is open source (GPL-3.0) — you can build it from source for free with cargo build --release. If you prefer a ready-to-use binary without compiling, it's $4.99 one-time from Polar. No subscriptions, no feature gates — just a convenience fee for the pre-built download.

Yes. PostgresTUI is a terminal app — it works perfectly over SSH. Upload the binary (or build it on the target machine) and you can browse PostgreSQL databases on remote servers without X11 forwarding.

Yes. Connect to any PostgreSQL endpoint — localhost, Docker, AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL, Supabase, Neon, or any managed service. Just provide the host, port, database, user, and password.

PostgresTUI is a browser, not a backup tool. For backups use pg_dump. But you can export individual tables as SQL INSERT statements, CSV, or JSON for data migration and analysis.

The binary includes an embedded web server (Rust + axum) and a React frontend. When you launch with --ui, it starts a local HTTP server on port 5000. Open your browser and you have a full database browser. The web assets are compiled into the binary — no separate files needed.

Yes. Launch as many instances as you need. Each one connects independently. Use different --listen ports for multiple Web UIs.

Open Source · GPL-3.0