Terminal Database Browsers — Why CLI Tools Beat pgAdmin and SSMS for Daily Work

The problem with GUI database tools

Every database engineer knows the routine. You need to check a few rows in a table. So you:

1. Click pgAdmin or SSMS — wait 15 seconds for it to launch
2. Navigate to the server — expand the tree — find your database — expand another tree — find your table
3. Right-click → Select Top 1000 Rows
4. Wait for the query to run (another 3-5 seconds for the result grid to render)

That's 20+ seconds just to look at a few rows. Multiply that by 30 checks per day, and you're wasting 10 minutes daily waiting for your tools to boot up. For remote support calls where you're SSH'd into a customer's server, you can't even use a GUI without X11 forwarding (which is slow, insecure, and often blocked by IT policies).

This is where terminal database browsers change the game.

What is a terminal database browser?

A terminal database browser is a TUI (Text User Interface) application that gives you a full-featured database browsing experience inside your terminal. Think of it as pgAdmin, but rendered entirely in text — with keyboard shortcuts, pagination, search, export, and copy-to-clipboard. No GUI, no Electron, no web browser.

And here's the best part: a single binary (~5-7 MB) replaces a 500+ MB GUI installation. Copy it to a server, run it, and you're browsing data in sub-second time.

The three tools

Voltrus maintains three free, open-source terminal database browsers covering the most common database engines:

Sqltui — for SQLite

Sqltui opens .db, .sqlite3, and .db3 files instantly. No --file flag needed — it scans your current directory and shows a file picker. Perfect for mobile app debugging (CoreData, Room), edge device data inspection (Raspberry Pi databases), and quick checks on Django/Rails/Laravel development databases.

<code># Open file picker
sqltui

# Open a specific file
sqltui -f myapp.db

# Launch Web UI
sqltui -f myapp.db --ui</code>

PostgresTUI — for PostgreSQL

PostgresTUI connects to any PostgreSQL endpoint — localhost, AWS RDS, Google Cloud SQL, Supabase, Neon. Vim-style keybindings, SQL autocomplete for PostgreSQL keywords and functions, paginated data view with 500 rows per page. The built-in Web UI gives you a full dark-theme interface for demos and team screen sharing.

<code>postgrestui -s localhost -p 5432 -d mydb -u postgres
postgrestui -s db.abc123.us-east-1.rds.amazonaws.com -d production -u admin --ui</code>

MSSQLTui — for SQL Server

MSSQLTui connects to SQL Server instances with resilient auto-reconnect. Supports both SQL Server Authentication and Windows Authentication. T-SQL autocomplete with SQL Server-specific keywords (TOP, NOLOCK, EXEC, CATCH, THROW). Works with on-premises SQL Server, Azure SQL Database, AWS RDS for SQL Server, and Docker containers.

<code>mssqltui -s localhost -d MyDatabase -u sa -P MyPass123
mssqltui -s localhost -d master -u sa -P 'YourPass!' --no-encrypt</code>

Why psql / sqlcmd / sqlite3 CLI aren't enough

You might be thinking: "I already use psql. Why do I need another tool?" Here's what terminal database browsers give you that the built-in CLIs don't:

• Sidebar navigation — See all tables and views at a glance with row counts. No \dt then SELECT COUNT(*) for every table.
• Paginated data — Browse 500 rows at a time with Prev/Next navigation. No SELECT * FROM orders that scrolls 100,000 rows past your screen.
• Copy to clipboard — Yank a cell value, a row, or an entire result set to clipboard as TSV or JSON. No \copy commands with delimiter configuration.
• Instant schema view — Press H to see the CREATE TABLE statement. No SHOW CREATE TABLE or \d+ for every table.
• Multiple export formats — CSV, JSON, SQL INSERT statements. Download with one click from the Web UI. No wizard dialogs or export configuration.
• Horizontal scroll — Wide tables with 30+ columns scroll horizontally. No truncated output.

Real-world use cases

1. Remote support and on-call debugging

"Can you check why customer X's orders aren't showing up?"

SSH into the server, run postgrestui -d production_db, and you're browsing the orders table in seconds. No VPN setup, no X11 forwarding, no installing pgAdmin on a server that doesn't have a display.

2. Database audits and compliance

Need to export audit logs for a specific date range? Query the table, hit Export → CSV, and you have a file ready for the auditor. Scriptable and repeatable from the command line.

3. Mobile app debugging (SQLite)

Your iOS app stores data in a CoreData SQLite store. Pull the .db file, open it with sqltui, and browse the schema instantly. No Android Studio, no Xcode SQLite viewer.

4. Docker / Kubernetes database inspection

Copy the 5MB binary into a container image. When your app misbehaves, exec into the container and browse the database directly. No port forwarding to connect an external GUI tool.

5. Teaching and onboarding

New team members can learn the database schema by browsing tables visually in the terminal or Web UI. The sidebar gives an immediate overview of all tables and their sizes. Faster than reading schema docs.

Technical architecture

All three tools share the same architecture:

• Rust — zero-cost abstractions, no garbage collector, compiled to native code
• ratatui — terminal UI framework for the TUI mode
• axum + React — embedded web server with a compiled-in React frontend for Web UI mode
• Single binary — the entire web UI (HTML, CSS, JS) is compiled into the binary via rust-embed. No separate assets folder, no npm on the target machine

The result is a 5-7 MB binary that starts in under 100ms — faster than any GUI database tool and more capable than the built-in CLIs.

Performance comparison

<code>Tool              | Startup | Binary Size | Memory (idle)
-------------------|---------|-------------|---------------
PostgresTUI        |  <100ms |       ~5 MB |       ~10 MB
Sqltui             |  <100ms |       ~6 MB |       ~12 MB
MSSQLTui           |  <100ms |       ~7 MB |       ~15 MB
pgAdmin 4          | ~15 sec |    ~500 MB  |     ~400 MB
SSMS               | ~20 sec |   ~1500 MB  |     ~600 MB
DBeaver            | ~10 sec |    ~400 MB  |     ~800 MB
TablePlus          |  ~3 sec |     ~30 MB  |     ~150 MB</code>

The single-binary advantage

Single binaries change how you think about deploying tools. No pip install. No npm install. No system dependencies. Just scp the binary to the server and run it. This is especially critical for:

• Air-gapped environments — no internet, no package managers
• Docker containers — add 5MB to your image, not 500MB
• Remote servers — one file to transfer, zero dependencies to install
• CI/CD pipelines — drop the binary in your pipeline for database health checks

Free and open source — why?

These tools are free and open source (GPL-3.0) because they're lead magnets for Voltrus SCADA, an industrial monitoring platform. Engineers who use our free database tools are the same engineers who build factories, power plants, and water treatment systems — the exact audience for industrial SCADA software.

No license keys. No subscriptions. No feature gates. The full source code is on GitHub. Use it, modify it, share it. If you find it useful, check out Voltrus for your industrial monitoring needs.

<code># PostgreSQL
curl -L -o /usr/local/bin/postgrestui https://dl-postgrestui.voltrus.id/latest && chmod +x /usr/local/bin/postgrestui

# SQLite
curl -L -o /usr/local/bin/sqltui https://dl-sqltui.voltrus.id/latest && chmod +x /usr/local/bin/sqltui

# SQL Server
curl -L -o /usr/local/bin/mssqltui https://dl-mssqltui.voltrus.id/latest && chmod +x /usr/local/bin/mssqltui</code>