What is mycli?
mycli is a robust command line interface designed for direct interaction with MySQL, MariaDB, and Percona databases. It streamlines workflow by providing sophisticated features like intelligent auto-completion and syntax highlighting, allowing users to run queries more efficiently and with greater accuracy in terminal environments.
Supporting various connection options and security protocols, mycli can be quickly set up through Python pip or Homebrew on macOS. It is well-suited for professionals who require a feature-rich terminal experience to manage databases, execute complex SQL commands, and maintain secure database connections.
Features
- Intelligent Auto-Completion: Suggests SQL keywords, table names, and columns as you type.
- Syntax Highlighting: Visually distinguishes SQL syntax for improved readability.
- Multiple Database Support: Compatible with MySQL, MariaDB, and Percona databases.
- Flexible Connection Options: Allows connections via host, port, SSH tunneling, and SSL.
- Customizable Prompts: Lets users set personalized terminal prompts.
- Batch Output Options: Supports table and CSV formats for query results.
- Logging Capability: Records all queries and their results to a file.
- Configurable Settings: Options to specify configuration and credential files.
Use Cases
- Managing and querying databases from the command line.
- Improving database productivity for developers and DBAs.
- Running and testing SQL scripts in a local or remote environment.
- Securely connecting to databases using SSH or SSL.
- Automating data export in table or CSV format.
FAQs
-
What databases are supported by mycli?
mycli supports MySQL, MariaDB, and Percona databases. -
How can I install mycli?
mycli can be installed using Python's pip or via Homebrew on macOS. -
Does mycli support secure connections?
Yes, mycli supports secure connections using SSH tunneling and SSL certificates. -
Can I log my queries using mycli?
Yes, mycli allows logging of queries and their results to a designated file.
