Mycli

Dev tools

database cli

SHOW HN2015

Mycli

A CLI for MySQL with auto-completion and syntax highlighting

mycli.net

#mysql client#mysql cli#syntax highlighting#auto-completion#mariadb

106points
29comments
#234of 2,565 in 2015
Top 10%of 2015 by points

How HN took it

MixedNo clear lean

6 positive, 6 neutral or asking, 1 mixed, 4 critical, out of 17 comments about the project. Thread score +0.24.

Execution: 2 for, 2 againstDesign: 0 for, 2 againstIdea: 1 for, 0 againstDocs: 1 for, 0 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful and looks great, with auto-completion and fuzzy search

    From 3 comments
    • Looks really great! I think you should highlight better that it support fuzzy search, as I had to dig deep into Docs->Auto completion to find it (was about to suggest it to you).…
      jafingi on HN
    • I gave it a spin. Seems pretty useful. Is there a way to view the last result again without re-running the query? Also the keybindings are missing from the docs. For example on…
      Grue3 on HN
    • Looks great, thank you!
      talleyrand on HN
  • Works on Windows 10

    From 1 comment

Objections

  • Fails to install via pip on CentOS 6.6 with a pkg_resources error about six

    From 2 comments
    • I tried installing it via pip on CentOS 6.6, and I get: Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point…
      trashcan on HN
    • Yep, getting the same issue: [foo@chef-solo ~]$ mycli Traceback (most recent call last): File "/usr/bin/mycli", line 5, in <module> from pkg_resources import load_entry_point…
      autotune on HN
  • Output disappears from terminal after leaving pager, with no way to review it

    From 2 comments
    • If the resulting table is large and opens up a less-like mode where I can scroll and pan around, but if I quit this mode, the terminal is cleared and there seems to be no way to…
      Grue3 on HN
    • I am on Linux too and it doesn't. Not just this tool: in general.
      chx on HN

Requests

  • Bundle as a single file to deploy without dependencies

    From 1 comment
    • Is there a way to have it bundled into a single file which I can scp to remote systems and need not worry about dependencies?
      cauterize on HN
  • Support for MySQL over SSH

    From 1 comment

Questions

  • Does it work with MemSQL

    From 1 comment
    • Did you try it with memsql? Just curious... I don't see any reason why it shouldn't work.
      ecesena on HN
  • Does it guard against dangerous commands like DROP TABLE

    From 1 comment
    • Does is protect against auto-completing dangerous commands like 'DROP TABLE;'?
      jgalt212 on HN

Alternatives named

  • pgcli, the PostgreSQL counterpart by the same author

    From 1 comment
    • I'm the author of this project. I'll be happy to answer any questions. Brief Intro: This is a command line tool that is intended as a replacement for MySQL client. It works with…
      amjith on HN
  • altsql-shell

    From 1 comment
    • Looks nice. Will give it a proper test drive soon. Am currently using: http://ewaters.github.io/altsql-shell/ Software that few people know about.Worth others trying out too. The…
      jupiter909 on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/9975022)