{"library":"mycli","title":"MyCLI - CLI for MySQL Database","description":"mycli is an interactive command-line client for MySQL, MariaDB, and Percona databases, featuring auto-completion, syntax highlighting, and smart suggestions. It's built on prompt_toolkit and pygments, providing a user-friendly and efficient interface for database administration and querying. The current version is 1.68.1, with a release cadence of minor versions every few weeks to months.","language":"python","status":"active","last_verified":"Fri Apr 17","install":{"commands":["pip install mycli"],"cli":{"name":"mycli","version":"mycli, version 1.72.1"}},"imports":["mycli"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"# To connect to a local MySQL instance as root:\nmycli -u root\n\n# To connect to a specific database (e.g., 'testdb') on a remote host (e.g., '192.168.1.100'):\nmycli -h 192.168.1.100 -u myuser -D testdb -p\n\n# To exit the mycli prompt:\n# \\q\n# (or Ctrl+D)","lang":"bash","description":"Start MyCLI from your terminal. You can specify connection parameters like host, user, database, and password directly via command-line flags. If a password is required, you'll be prompted for it interactively.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}