mycli

Free#16 of 31 in SQL Query ToolsDatabase Client Software

Open-source terminal client for MySQL-compatible databases.

—Not yet scored

Visit mycli

mycli— Visit mycli

At a glance

Editor score
Not yet scored
Pricing
Free plan
Best for
Terminal users querying MySQL-family databases
Free plan
Yes
Paid from
None
Facts checked
21 Sep 2026

Where it wins
- Strong context-sensitive completion and SQL syntax highlighting
- Fuzzy history search, saved queries, logging, and flexible output formats
- Schema-aware LLM assistance with SSH and infrastructure integrations
Where it doesn't
- Terminal-only experience with no visual query builder
- Windows and WSL support are documented as partial
- Database support is limited to listed MySQL-family systems

Our verdict on mycli

mycli is an open-source command-line database client for users who work directly in a terminal and query MySQL-compatible servers. It runs on Windows, macOS, and Linux, with partial support documented for Windows and WSL. The supported database systems are MySQL, MariaDB, Percona, TiDB, and Apache Doris. As a desktop tool that runs locally through Python package managers, it suits developers, database administrators, and infrastructure-oriented teams who prefer keyboard-driven workflows over graphical interfaces.

Its strongest area is query authoring and recall. Context-sensitive completion covers SQL keywords, tables, views, columns, and enums, while syntax highlighting and multiline editing support longer statements. Fuzzy query-history search helps retrieve previous work, and favorite queries can be saved with parameters. Query and result logging adds an audit-friendly record of terminal activity, while CSV, TSV, table, and default output formats make results easier to redirect or share. System keyring password storage also keeps credential handling within the local environment.

mycli extends beyond basic terminal editing with optional LLM-assisted querying that uses schema context. SSH tunneling is supported, and integrations with Kubernetes, Vault, and Boundary fit infrastructure workflows. These capabilities make it a practical choice for users who want database access alongside operational tooling, rather than a separate graphical workspace. It is less suitable for teams that need visual query construction, broad database coverage beyond the listed MySQL-family systems, or a fully supported Windows and WSL experience. Choose mycli for a free, open-source terminal workflow; choose an alternative when visual design or wider platform coverage matters more.

mycli pricing

Plans Free planFree Free to use — no paid tier required for the core job.

See plans on mycli.net

mycli fact sheet

Free plan	Yes
Paid from	None
Query history retention	Not verified
Scheduled queries	Not verified
Team query sharing	Not verified
SQL notebooks	Not verified
AI query assistance	Not verified
Deployment options	Not verified
Deployment	Desktop
Platforms	Windows, macOS, Linux
Support	Docs, Community
Built for	Solo, Small business, Mid-market (editorial estimate)
Integrations	4 integrations: SSH, Kubernetes, Vault, Boundary
Pricing	Free plan
Website	mycli.net
Facts checked	21 Sep 2026

mycli integrations

mycli lists 4 integrations on its own site.

SSH
Kubernetes
Vault
Boundary

Alternatives to mycli

See all mycli alternatives →

Also listed in

Database Client Software

Used mycli? Be the first to review it

The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used mycli for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.

Write a reviewTwo minutes · verified accounts only · read by an editor before it appears

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Title

Your review

0 characters · at least 80, up to 3,000

Pros (optional · one per line)

Cons (optional · one per line)

Your name (shown with your review)

Role (optional)

Company (optional)

How long have you used it?

I've used mycli myself and this is my honest opinion — nobody paid or asked me to write it.

Posted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

mycli is listed in our SQL Query Tools directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/mycli/"><img src="https://www.itechguides.com/best/badge/mycli.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Sep 2026

Advertiser disclosure: iTechGuides is reader-supported. We may earn a commission when you click some links. It never changes a score or a verdict. How we rank.