Package Details: mycli 1.24.1-1

Git Clone URL: (read-only, click to copy)
Package Base: mycli
Description: A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting
Upstream URL:
Keywords: cli mariadb mysql
Licenses: BSD
Submitter: aabmass
Maintainer: loonies
Last Packager: loonies
Votes: 30
Popularity: 0.30
First Submitted: 2015-08-05 15:33
Last Updated: 2021-03-24 18:45

Pinned Comments

loonies commented on 2019-12-06 11:43

Prior to flagging the package out-of-date or reporting build errors please:

  • Make sure that your system is up-to-date (pacman -Syu)
  • Rebuild and reinstall dependencies (especially ones from AUR)
  • Rebuild and reinstall the package

Do not expect AUR packages to trigger rebuild or suggest bumping "pkgrel" number. This is expected behaviour and the way Arch packing is designed to work.

For more information read the official documentation and man pages.

Latest Comments

1 2 3 4 5 Next › Last »

SZanko commented on 2021-02-04 18:58

cli helpers package was updated 4 days ago

loonies commented on 2021-01-24 17:37

Waiting for (dependency) update.

SZanko commented on 2021-01-14 20:45

diff --git a/PKGBUILD b/PKGBUILD
index bcace65..6a01533 100644
@@ -1,10 +1,11 @@
 # Maintainer: Miodrag Tokić
 # Contributor: Yuanji <>
 # Contributor: Aaron Abbott <aabmass at gmail dot com>
+# Contributor: Stefan Zanko szanko at protonmail dot com

 pkgdesc='A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting'
@@ -19,6 +20,7 @@ depends=(
+       'python-pyperclip'
 optdepends=('python-paramiko: SSH support')
@@ -26,16 +28,16 @@ options=(!emptydirs)

-    ""
+    #""
-    '4427442cf3e66ebbbb480bc5112bdf7e0432c70645f320313e2e0dbf0ae147fb'
-    '33f3e60abfe68bc7375dacead9676b3cc4920e1d16c7b57dcf5f474c0c3e6aad'
+    '8c2efa716f994ac0ffb9e21da59c4696754b201d823b61cd63f2948c1bbd702c'
+    #'33f3e60abfe68bc7375dacead9676b3cc4920e1d16c7b57dcf5f474c0c3e6aad'

 prepare() {
     cd "$srcdir/$pkgname-$pkgver"
-    patch -N -p1 -i "$srcdir/"
+    #patch -N -p1 -i "$srcdir/"

 build() {

loonies commented on 2020-10-24 21:16

sqlparse 4.0 compatibility fixed. Thanks @mtorromeo

cmonkey commented on 2020-10-10 02:10

mycli -P 3306 -u root -h
Traceback (most recent call last):
File "/bin/mycli", line 33, in <module>
sys.exit(load_entry_point('mycli==1.22.1', 'console_scripts', 'mycli')())
File "/bin/mycli", line 25, in importlib_load_entry_point
return next(matches).load()
File "/usr/lib/python3.8/importlib/", line 77, in load
module = import_module('module'))
File "/usr/lib/python3.8/importlib/", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
File "<frozen importlib._bootstrap>", line 991, in _find_and_load
File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 783, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/usr/lib/python3.8/site-packages/mycli/", line 39, in <module>
from .sqlcompleter import SQLCompleter
File "/usr/lib/python3.8/site-packages/mycli/", line 7, in <module>
from .packages.completion_engine import suggest_type
File "/usr/lib/python3.8/site-packages/mycli/packages/", line 5, in <module>
from sqlparse.compat import text_type ModuleNotFoundError: No module named 'sqlparse.compat'

mycli 1.22.1-1

mtorromeo commented on 2020-10-08 08:09

I've opened a pull request upstream to fix the incompatibility with sqlparse 0.4, you might want to backport the patch:

tyjak commented on 2020-09-17 11:02

I had to rm -rf /usr/lib/python3.8/site-packages/test due to a conflict with mycli package that installed also a test folder in site-packages...

mgrimes commented on 2020-07-22 16:02

It seems mycli isn't compatible with pymysql v0.10.0. Needs the following patch:

diff -aur a/ b/
--- a/     2020-07-22 12:01:23.355002581 -0400
+++ b/     2020-07-22 11:59:50.394800925 -0400
@@ -3,7 +3,7 @@
 import sqlparse
 from .packages import special
 from pymysql.constants import FIELD_TYPE
-from pymysql.converters import (convert_mysql_datetime, convert_datetime,
+from pymysql.converters import (convert_datetime,
                                 convert_timedelta, convert_date, conversions,
@@ -99,7 +99,7 @@
         conv = conversions.copy()
-            FIELD_TYPE.TIMESTAMP: lambda obj: (convert_mysql_datetime(obj) or obj),
+            FIELD_TYPE.TIMESTAMP: lambda obj: (convert_datetime(obj) or obj),
             FIELD_TYPE.DATETIME: lambda obj: (convert_datetime(obj) or obj),
             FIELD_TYPE.TIME: lambda obj: (convert_timedelta(obj) or obj),
             FIELD_TYPE.DATE: lambda obj: (convert_date(obj) or obj),

mercutio commented on 2020-04-29 10:52

I patched the to allow for prompt_toolkit 3, the library seems to be compatible with that version without an issue:

Chacal_E commented on 2020-04-29 01:19

for those with difficulties, you can download python-prompt_toolkit-2.0.9-1-any.pkg.tar.xz from and then use the command pacman -U python-prompt_toolkit-2.0.9-1-any.pkg.tar.xz as root.

note: when upgrading programs, if you update python-prompt_toolkit, you have to downgrade again.