otty / apps
All apps/WhoDB CLI

WhoDB CLI

whodb-cli

Database management CLI with TUI interface, MCP server support, AI, and more

Runs as whodb, whodb-cli|macOS, Linux, Windows|github.com
Open form in Otty otty.toml

Command form

ai-draft · 3 tasks · 13 fields

Run a SQL query or export table data with whodb. Connection management, TUI and MCP modes are not covered.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui whodb-cli

whodb query

Run a SQL query

Execute one SQL statement against a saved connection.

Run a SQL queryExample values, fixed in this page — nothing here reaches a terminal
Basic
SQL*
string
Connection name
string
Output format
6 choicesenum
TasksEach one presets the form for one job
Run query
sqlconnectionformat
ParametersOnly these flags are editable in the form
SQL
string · positional 0
Connection name
string
--connection-c
Output format
enum
--format-fautotableplainjsonndjsoncsv
Stream rows
boolean
--stream
Quiet
boolean
--quiet-q

whodb export

Export data

Export a table or query result to a CSV or Excel file.

Export dataExample values, fixed in this page — nothing here reaches a terminal
Basic
Connection name
string
Table*
string
Schema
string
Export format
2 choicesenum
Output file*
file
TasksEach one presets the form for one job
Export a table
connectiontableschemaformatoutput
Export query results
connectionqueryformatoutput
ParametersOnly these flags are editable in the form
Connection name
string
--connection-c
Table
string
--table-t
SQL query (instead of table)
string
--query-Q
Schema
string
--schema-s
Export format
enum
--format-fcsvexcel
Output file
path
--output-o
CSV delimiter
string
--delimiter-d
Stream CSV
boolean
--stream
SourcesEvery flag above is checked against these
readme
whodb query "SQL" [flags] - `--connection, -c`: Connection name to use (optional; if omitted, the first available connection is used) - `--format, -f`: Output format: `auto`, `table`, `plain`, `json`, `ndjson`, `csv` - `--stream`: Stream result rows incrementally (supported for `plain`, `json`, `ndjson`, and `csv`) - `--quiet, -q`: Suppress informational mes…
help2026-10-27

github.com

readme
whodb export --connection my-postgres --table users --format csv --output users.csv - `--connection, -c`: Connection name (optional; if omitted, the first available connection is used) - `--table, -t`: Table name (required unless using `--query`) - `--query, -Q`: SQL query to export results from (use instead of `--table`) - `--schema, -s`: Schema name - `--f…
help2026-10-27

github.com

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