TiloBox
Back to directory
mycli project preview
Developer ToolsAlternative to MySQL WorkbenchAlternative to NavicatAlternative to DataGrip

mycli

A modern Terminal client for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.

View on GitHub Visit website
LicenseBSD-3-Clause
GitHub stars11.5k
Last commit1 weeks ago
Tags5 topics
Sql AutocompleteMycli ToolMysql Cli ClientDeveloper ToolsMariadb Terminal
Overview

Why consider mycli?

mycli is an open-source terminal client for MySQL, MariaDB, and Percona databases written in Python by Thomas Roten and Amjith Ramanujam. mycli brings intelligent schema-aware autocompletions, query pagination, audit logging, and color syntax themes to MySQL shell interactions.

Guided learning

Learn mycli by building

Practical setup notes, real use cases, and copy-ready examples in one focused guide.

1 min read 2 sections
In this guide2 sections

Overview of mycli

mycli accelerates MySQL database operations with instant column and table autocompletions.

Quickstart

bash
1pip install mycli
2mycli -u root -h localhost company_db

mycli is licensed under the BSD 3-Clause License.

Related tools

More options with a similar category or technology profile.

diskus logo

diskus

Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.

peco logo

peco

Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.

Dapr CLI logo

Dapr CLI

Command-line tool for managing Dapr distributed application runtime environments and sidecars.

Freeze logo

Freeze

Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.

mycli FAQs

mycli is listed as a Developer Tools tool on TiloBox. Review the overview, features, and official documentation on this page to decide whether it solves your specific workflow.

Start with the project's GitHub repository and official website for supported installation and deployment instructions. Test the setup with representative data or a small project before rolling it out more widely.

mycli is listed under the BSD-3-Clause license. Read the complete license text and the project's notices before using, modifying, or distributing the software.

Production readiness depends on your requirements. Review maintenance activity, security practices, documentation, backup and upgrade procedures, and compatibility with your stack; then validate it in a non-production environment.

mycli is listed as an alternative to MySQL Workbench. Compare the core workflow, deployment model, integrations, and licensing against your must-have requirements before switching.