Skip to content
dbterm
Install
v0.6.4 · Bhagirathi

Open-source terminal database workbench

Connect once.
See every database.

Choose a database, query and inspect its data, operate local services, and protect local or cloud sources—without leaving the keyboard.

Try the real workflow GitHub
  • Server-first logins
  • Five engines
  • Native backup agent

Browser demo

Try dbterm.

Real read-only SQLite. The same workspace and core keys as dbterm.

Press Ctrl+P anywhere on this page, or click inside for contextual keys.
sample SQLite session · data stays in this browser
Query(Alt+Q)
Results
SQLite is standing by

Opening the users table…

◆ SQLitestarting🔌 local-demo4 tables— rows— mssort: noneTables focused · Space pin/unpin · type to find

Try Space to pin a table, Ctrl P, table type-ahead, /, C, V, F, and Backspace.All shortcuts →

Matches

Selected Item

Type Search │ ↑/↓ Navigate │ Enter Open │ Esc Close

📊 Filters

Active filters: none
Enter Apply │ Tab / Shift+Tab Move │ Esc Cancel

❓ Help & Cheatsheets

TabCycle Tables → Query → Results
Alt+T/Q/RFocus a panel
EnterRun SQL / open row details
Shift+EnterNew query line
Ctrl+PCommand & object palette
Space (Tables)Pin / unpin highlighted table
/Filter selected column
C / VCopy cell / filter by clipboard
F / BackspaceFollow foreign key / return
SSort selected column
Alt+EExport visible rows to CSV
Alt+FFullscreen Results
EscClear search or filters
Esc / Alt+H Close

📄 Row Details

↑/↓ Scroll │ Esc / Enter Close

The whole system

Four jobs. One binary.

dbterm is no longer only a query client. Connections, data work, local operations, and recovery share the same saved context and keyboard model.

01

Server-first connections

Save one PostgreSQL or MySQL login without a database name. Browse everything that account can access, choose a default, or open another database with the same credentials.

  • Optional database
  • All accessible DBs
  • Stable per-user profile
02

Complete data workspace

Discover schema objects, run cancellable SQL, inspect typed results, build AND filters, follow foreign keys, pin tables, and stream exactly the rows you want to CSV.

  • Object palette
  • Typed filters
  • Import + export
03

Local database operations

Inspect, start, and stop MySQL or PostgreSQL services, then connect with a saved database login and browse the server without confusing sudo credentials with database credentials.

  • Service status
  • Start / stop
  • Saved-login connect
04

Backup and recovery

Route local or remote sources to local, mounted, or rclone storage. Verify, compress, encrypt, retain, inspect, notify, and restore through a native OS-managed agent.

  • All 4 local/remote routes
  • Native agents
  • Guarded restore
See the complete feature map

Backup Center · Alt K

Set the job. Close the terminal.

Schedule a local or remote database to a folder you control. dbterm stages, verifies, compresses, encrypts, records, and retains it.

PostgreSQLMySQLSQLiteTursoD1
Explore Backup Center
prod-postgres · enablednext 02:00 IST
  1. 01 · SOURCE

    Remote PostgreSQL

    official pg_dump
  2. 02 · PIPELINE

    zstd level 3 + age

    one worker · X25519
  3. 03 · RESULT

    Verified artifact

    SHA-256 · count / age / size
Native agent● running · 12 MiB · notifications ready
dbterm backup service install
dbterm backup inspect --identity ./age-identity.txt prod_20260805.dump.zst.age
dbterm backup restore --connection prod --identity ./age-identity.txt --yes prod_20260805.dump.zst.age

The focused loop

From table to answer.

01Ctrl P

Find anything

Search commands, tables, objects, and recent SQL.

02F / Backspace

Follow relationships

Jump through foreign keys, then return to the same row.

03/ · C · V

Work from a cell

Copy it, filter its column, or search with the clipboard.

04Alt E

Export the right rows

Export selected rows, a page, or every filtered match.

05Space

Keep tables close

Pin frequently used tables at the top of each database.

06Alt K

Schedule protection

Run compressed, encrypted backups through your OS—even after dbterm closes.

Deliberate scope

Five databases. One workflow.

PGPostgreSQLMYMySQLSQSQLiteTUTursoD1Cloudflare D1

Choose honestly

Focused—not universal.

Choose dbterm for a keyboard-first data loop. Choose a desktop workbench for diagrams, broad drivers, and GUI administration.

Compare dbterm, DBeaver, and terminal clients

Ready?

Install dbterm. Open—and protect—a database.

Copy the install command Read the guide

Quick answers

Before you connect.

Is the browser demo real?

Yes. It loads SQLite compiled to WebAssembly and runs read-only SQL against an in-memory sample database. The sample data stays in your browser and is discarded when you leave.

Does dbterm need Go, Node, Python, or Java installed?

No. dbterm is distributed as a single release binary for Linux, macOS, and Windows. Those frontend tools build this website only; they are not runtime requirements for dbterm.

Why another terminal SQL client?

dbterm covers a deliberate end-to-end loop: server-first connection, database discovery, schema, query, relationship navigation, typed filtering, import/export, local services, and durable backup/recovery in one keyboard model.

Can dbterm back up a remote or cloud database?

Yes. A reachable PostgreSQL, MySQL, Turso, or D1 connection can back up to a local/mounted folder or a configured rclone remote. Local and remote sources can use either destination type; dbterm adds scheduling, safe publication, history, compression, age encryption, and retention.