mycli

Rich MySQL terminal client with auto-completion, syntax highlighting, and dataframes.

Runs as mycli|macOS, Linux, Windows|www.mycli.net

Command form

ai-draft · 2 tasks · 7 fields

Open the mycli prompt on a MySQL server, or run one statement and quit. The password is left out so it is not typed into the command line; mycli prompts or reads it from its config.

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

Run in Otty

otty gui mycli

Connect to MySQLExample 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 to a server

hostportuserdatabase

Connect by DSN alias

dsndatabase

ParametersOnly these flags are editable in the form

Host

string

--hostname-h

Port

integer

-P

User

string

--user--username-u

Unix socket

path

-S

Database

string

--database-D

DSN alias

string

-d

Run statement and quit

string

-e

SourcesEvery flag above is checked against these

src

'-h', '--hostname', help='Host address of the MySQL server.' '-P', help='Port number on the MySQL server.' '-u', '--user', '--username', help='User name to connect to the MySQL server.' '-S', metavar='PATH', help='Socket path to connect to the MySQL server.' '-D', '--database', help='Database or DSN to use for the connection.' '-d', help='DSN alias configure…

helpmain (2026-10-27)

github.com

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