otty / apps
All apps/MySQL

MySQL

mysql

mysql is a simple SQL shell with input line editing capabilities.

Runs as mysql|macOS, Linux, Windows|dev.mysql.com
Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 14 fields

Open the mysql client or run one statement. Passwords are left out; use -p at the prompt, a login path or an option file. SSL and compression tuning are left out.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui mysql
Connect to a serverExample values, fixed in this page — nothing here reaches a terminal
Basic
Host
string
Port
integer
User
string
Database
string
TasksEach one presets the form for one job
Connect
hostportuserdatabase
Run one statement
hostuserdatabaseexecutetable
ParametersOnly these flags are editable in the form
Host
string
--host-h
Port
integer
--port-P
User
string
--user-u
Database
string
--database-D
Execute statement and quit
string
--execute-e
Login path
string
--login-path
Protocol
string
--protocolTCPSOCKETPIPEMEMORY
Tabular output
boolean
--table-t
Vertical output
boolean
--vertical-E
Batch mode
boolean
--batch-B
Skip column names
boolean
--skip-column-names-N
Continue after SQL errors
boolean
--force-f
Safe updates
boolean
--safe-updates-U
Default character set
string
--default-character-set
SourcesEvery flag above is checked against these
fig
completion

github.com

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