dblab

The database client every command-line junkie deserves.

Runs as dblab|macOS, Linux, Windows|github.com

Command form

ai-draft · 2 tasks · 12 fields

Open the dblab TUI against a database by host and credentials or by URL. SSH tunnel, SSL and config-file options are left out; the password is typed into the command, so prefer a URL or config file for real secrets.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui dblab

Connect to a databaseExample values, fixed in this page — nothing here reaches a terminal

Basic

Connection URL*

string

Read-only connection

--readonly

TasksEach one presets the form for one job

Connect with URL

urlreadonly

Connect by host

driverhostportuserdbreadonly

ParametersOnly these flags are editable in the form

Driver

string

--driverpostgresmysqlsqlite

Host

string

--host

Port

string

--port

User

string

--user

Password

Visible in shell history and process list.
string

--pass

Database name

string

--db

Schema

Optional, postgres and oracle only.
string

--schema

Connection URL

string

--url-u

Unix socket

path

--socket

Read-only connection

boolean

--readonly

Row limit

Rows fetched for table content; default 100.
integer

--limit

Use config file

boolean

--config

SourcesEvery flag above is checked against these

help

--db string Database name --driver string Database driver --host string Server host name or IP --limit uint Size of the result set for the table content query (should be greater than zero, otherwise the app will error out) (default 100) --pa…

helpmaster 2026-10-27

github.com

Before it fills your prompt, Otty checks the installed dblab against its version. A form that does not match your version is not offered.