🗄️ Rowdy

Terminal UI database client — vim-style navigation
v0.9.1  ·  MIT / Apache-2.0
crates.io/crates/rowdy-db
github.com/TSODev/rowdy
Global
Ctrl+CQuit from anywhere
Ctrl+TOpen new connection tab
[ ]Previous / next tab
Ctrl+WClose current tab
qClose tab (quit if last)
🔌 Connection Screen
j kNavigate saved profiles
EnterConnect to selected profile
nType a new connection URL
eEdit selected profile
TabCycle fields: Type → URL → Pre → Post
Change DB type (when Type focused)
Ctrl+SSave profile (prompts for name)
DDelete selected profile
qQuit
📋 Table List
j kNavigate tables
EnterOpen table in Data Grid
eOpen SQL Editor
rOpen ERD graph (selected table)
/Filter tables by name
qDisconnect
🕸 ERD Graph View
j k or TabCycle between table boxes
EnterRe-center on selected box
q EscBack to table list
📊 Data Grid
j kNext / previous row
h lPrevious / next column
g GFirst / last row
PgDn PgUp±10 rows
sSort column: ASC → DESC → off
ALoad all rows (replaces pages)
fFilter selected column
dRemove filter on selected column
FClear all filters
- =Shrink / grow column width (step 5)
SpaceCollapse / expand selected column
EnterEdit record — or drill into FK / nested
aInsert document (MongoDB)
DDelete document (MongoDB)
EExport prompt
cCSV
jJSON simple
JJSON + recursive FK resolution
EscCancel export
q EscBack to table list
✏️ SQL Editor
F5 or Ctrl+EnterExecute query
F4Open SELECT result in Data Grid
TabAutocomplete popup (tables, columns, keywords)
TabNavigate suggestions
EnterInsert suggestion
EscClose popup
Alt+↑Previous query from history
Alt+↓Next query from history
TabSwitch focus editor ↔ results
Ctrl+QBack to table list
📝 Edit Record
j kNext / previous field
EnterEdit field — or drill into [obj] / [arr]
iEdit [obj] as raw JSON string
SpaceToggle boolean field
Move cursor within field
Home EndJump to start / end of field
Backspace DelDelete character
Ctrl+SSave — confirmation modal before UPDATE
Esc qCancel — or confirm nested edit & go up
🗂 Array Editor (MongoDB arr fields)
aAdd item at end (enters edit mode)
DDelete selected item
EnterEdit item — or drill into nested
EscConfirm array & go back to parent
💡 Tips
Read-only modeAppend ?readonly=true to URL
CredentialsStored in OS keychain — __keyring__ in config
Pre/post hooksShell scripts per profile (SSH tunnels, VPN…)
Config file~/.config/rowdy/config.toml
History~/.config/rowdy/history.toml (200 entries)
Search all rowsPress A (load all) before Ctrl+F