Mycli – A CLI for MySQL with auto-completion and syntax highlighting

In plain words

Mycli is a command-line interface for MySQL that provides auto-completion and syntax highlighting. It works with MySQL, MariaDB, Percona, TiDB, and Apache Doris databases. The tool is designed for developers and database administrators who prefer working from the terminal. It includes features like fuzzy history search (with fzf), persistent configuration through a configuration file, and built-in help documentation.

written from the facts on this page · September 2026

From the sources

It is compatible with MySQL, MariaDB, Percona, TiDB, and Apache Doris. https://github.com/dbcli/mycli/blob/v2.0.0/changelog.md#breaking-changes . though installing fzf via your package manager is also recommended for fuzzy history search. You might need sudo on Linux. Mycli also needs the less executable, which is usually installed by default on Mac and Linux systems. See also the /help guide at the mycli prompt, and the ~/.myclirc file for configuration which persists across sessions. The configuration document commentary is a good reference for many of mycli'sfrom mycli.net

• 
  MyCLI2015 · mycli.net · ▲4

  A MySQL Client with Auto-Completion and Syntax Highlighting

• PA
  Pgcli – A CLI for Postgres with auto-completion and syntax highlighting2015 · pgcli.com · ▲227
• 
  CLI for MySQL / MariaDB2015 · kickstarter.com · ▲4

  CLI with auto-completion for MySQL. By pgcli author.

• 
  FluentDBJul 2026 · fluentdb.ai · ▲275

  The AI database client for Mac

• 
  Xmysql – One command to serve REST APIs for any MySql database2017 · github.com · ▲72

  xmysql is now https://github.com/nocodb/nocodb. Contribute to o1lab/xmysql development by creating an account on GitHub.

• 
  IRedis: CLI for Redis with AutoCompletion and Syntax Highlighting2020 · github.com · ▲97

  Interactive Redis: A Terminal Client for Redis with AutoCompletion and Syntax Highlighting. - laixintao/iredis

Questions this answers

• ecclo

• 
  /dev/null▲472

  a social network for devs

  Dev tools · 2d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 25d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 22d ago · openbot.run

• 
  Talanoa▲340

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 27d ago · corespeed.io

• 
  Hotjar▲1,312

  See how visitors are using your site and get visual feedback

  Growth · 2015 · contentsquare.com

• 
  Spot the Drowning Child▲1,215

  Can you spot the drowning child in this crowded wave pool? To the untrained eye, drowning looks like swimming. The Instinctive Drowning Response is frequently missed, even by people nearby.

  Life & fun · 2015 · spotthedrowningchild.com

• 
  Marketing Stack▲1,208

  A curated directory of marketing resources & tools

  Growth · 2015

• 
  Bocker – Docker implemented in 100 lines of bash▲662

  Docker implemented in around 100 lines of bash. Contribute to p8952/bocker development by creating an account on GitHub.

  Dev tools · 2015 · github.com

• 
  The Pitch▲561

  The podcast where early stage startups pitch investors

  Commerce · 2015 · thepitch.show

• 
  “Who is hiring?” Map▲546

  Guida completa ai siti scommesse americani 2026: scopri i migliori bookmaker USA, licenze, bonus, sport americani, metodi pagamento e consigli utili.

  AI · 2015 · whoishiring.it