How to install mycli on Windows?

Native Windows installation involves additional steps like installing the 'less' pager and is untested; using WSL is recommended for a smoother experience, as per the README instructions.

mycli vs standard MySQL client: which is better?

mycli excels with auto-completion and syntax highlighting for productivity, while the standard client is more lightweight and universally available. Choose mycli for frequent, complex query writing.

How to save and run favorite queries in mycli?

Use the command \fs to save a query, and execute it with \f . This feature allows quick access to frequent queries, as detailed in the documentation.

Can mycli connect to MySQL with SSL securely?

Yes, mycli supports SSL connections for encrypted database access. Configure it via command-line options or the config file to ensure secure communication.

Does mycli work with PostgreSQL or other databases?

No, mycli is specifically for MySQL. For PostgreSQL, use pgcli, a similar tool from the same project, as mentioned in the README for equivalent functionality.

How to enable fuzzy search in mycli history?

Fuzzy search is integrated with fzf; ensure fzf is installed on your system, and mycli will automatically use it for efficient history search, as described in the features.

mycli

BSD-3-ClausePythonv1.69.0

A command-line MySQL client with auto-completion, syntax highlighting, and smart context-aware suggestions.

Visit Website

What is mycli?

Mycli is a terminal-based MySQL client that enhances the standard MySQL command-line experience with modern features like auto-completion and syntax highlighting. It makes database interaction faster and more intuitive by reducing the cognitive load of writing SQL. The tool is designed for developers and database administrators who work with MySQL databases.

Target Audience

Database administrators and developers who frequently interact with MySQL databases via the command line and seek a more productive, user-friendly interface. It is particularly useful for those writing complex SQL queries or managing multiple databases.

Value Proposition

Developers choose mycli over the standard MySQL client for its intelligent, context-aware auto-completion and syntax highlighting, which streamline query writing and debugging. Its integration with tools like fzf for fuzzy history search and support for features like favorite queries and SSL connections provide a modern, secure, and efficient workflow.

Overview

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

Use Cases

Best For

Database administrators needing efficient, command-line-based MySQL management with auto-completion for tables and columns.

Related Projects

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub

GitHub

11.9k stars689 forks0 contributors

Developers writing complex, multiline SQL queries who benefit from syntax highlighting and smart context-aware suggestions.

Teams requiring secure database connections with SSL support and system keyring integration for password storage.

Users who want to save and quickly execute frequently used queries via favorite queries with aliases.

Professionals seeking a fuzzy search through command history using fzf for faster retrieval of past queries.

Individuals working on macOS or Linux who prefer a Python-based, modern alternative to the standard MySQL CLI with features like timing and pretty-printed tabular data.

Not Ideal For

Users who require graphical database management tools with visual query builders or schema designers.
Windows environments without WSL, as native support is experimental and untested, leading to potential instability.
Teams with strict dependency controls that restrict installing Python packages or external tools like fzf.

Pros & Cons

Pros

Intelligent Auto-Completion

Offers context-aware suggestions for SQL keywords, tables, and columns, speeding up query writing and reducing errors, as demonstrated in the smart-completion features.

Syntax Highlighting

Uses Pygments to colorize SQL syntax, improving readability and making complex queries easier to debug, a core feature highlighted in the documentation.

Fuzzy History Search

Integrates with fzf for efficient searching through command history, allowing quick retrieval of past queries, which is emphasized in the features list.

Secure and Convenient

Supports SSL connections for encrypted access and system keyring integration for password storage, enhancing security without sacrificing usability.

Cons

Untested Windows Support

Native Windows installation is not tested and requires extra setup like installing a pager, making it unreliable for users without WSL, as admitted in the README.

Python Dependency

Requires Python 3.10 or better, which can be a barrier in environments with older Python versions or where package management is restricted.

Limited Database Support

Focused only on MySQL; for other databases like PostgreSQL, users must switch to separate tools like pgcli, fragmenting the workflow for multi-database environments.

Frequently Asked Questions

Home

Command-Line Apps

yt-dlp

A feature-rich command-line audio/video downloader

Stars158,187

Forks13,071

Last commit5 days ago

fuck

Magnificent app which corrects your previous console command.

Stars96,666

Forks3,931

Last commit1 year ago

httpie

🥧 HTTPie CLI — modern, user-friendly command-line HTTP client for the API era. JSON support, colors, sessions, downloads, plugins & more.

Stars37,980

Forks3,921

Last commit1 year ago

cookiecutter

A cross-platform command-line utility that creates projects from cookiecutters (project templates), e.g. Python package projects, C projects.

Stars24,828

Forks2,224

Last commit23 days ago

#database-administration

Command-Line Apps19.2k

Database Tools5.1k

MySQL2.6k