dbcli/mycli ? reverse-engineered prompt

Reverse engineered prompt

Build me a slick terminal app for working with MySQL databases.

I want it to feel much nicer than the basic mysql shell, with smart autocomplete for SQL keywords, tables, views, and columns, plus syntax highlighting and multiline query support. It should show query results in clean table output, let me switch between a few useful display formats, and keep a searchable command history so I can quickly find old queries. I also want a way to save favorite queries with variables, then run them again with different values. If possible, include support for fuzzy search and a nice output viewer when tools like fzf are available.

It should connect to MySQL and compatible databases like MariaDB and Percona, save settings in a config file, and support modern defaults like UTF 8 and SSL. If you need to look up current docs or examples for any of the libraries, go ahead and do that.

Are you gonna build this?

make sure you review the code using coderabbit

Try freeSponsored — opens CodeRabbit in a new tab