mycli is an interactive command-line client for MySQL, MariaDB and Percona Server. It enhances the conventional database shell with context-aware completion, syntax highlighting and tools for exploring query results.
The application suggests SQL keywords, table names, column names and other database objects while users type. Its completion system considers the context of the query, reducing repetitive typing and helping users construct statements more efficiently. Syntax highlighting is provided through Pygments, with configurable colour schemes.
mycli supports saved queries, searchable command history and several output formats. Queries can be redirected to files or external commands, while optional integrations allow tabular results to be processed using Polars dataframes and exported to formats such as Parquet. Users can also inspect query output through external interactive tools.
The application offers configurable keyboard bindings, secure credential storage and integration with SSH and other connection mechanisms. It is designed for database administrators and developers who prefer terminal-based workflows without sacrificing convenience.
This is free and open source software.
Key Features
- Interactive SQL client for MySQL, MariaDB and Percona Server.
- Context-sensitive completion of SQL keywords, tables, columns and other database objects.
- Configurable SQL syntax highlighting using Pygments.
- Execute multiline SQL statements.
- Save frequently used queries with positional or named parameters.
- Search command history using optional fuzzy-search integration.
- Display query results using several tabular output formats.
- Redirect query output to files and external commands.
- Process results using optional Polars dataframe integrations.
- Save dataframe results in formats such as Parquet.
- Store credentials using the system keyring.
- Support encrypted database connections and configurable connection settings.
- Choose Emacs or Vim-style keyboard bindings.
- Cross-platform support – runs on Linux and macOS; Windows support is partial.
Website: www.mycli.net
Support:
Developer: Amjith Ramanujam and contributors
License: BSD 3-Clause License
mycli is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| MySQLTuner | Analyse MySQL performance and suggest configuration changes |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| MyDumper | Parallel utilities for fast MySQL database backups and restores |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| Skeema | Manage MySQL and MariaDB schema changes |
| vi-sql | Terminal SQL client for browsing, querying and editing databases |
| MySQL Shell | Advanced MySQL console for scripting and database administration |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.