Being frustrated with MySQL Workbench, I'm looking for other interfaces/environments which are more convenient and closer to my current workflow using Jupyter. Here I have summarized the current working possibilities using Pandas or Jupyter magics to get nice HTML results. However, I was thinking if I could go one step further to have a native MySQL kernel for Jupyter, and it turns out that there is actually one. So I followed the instructions by installing:

pip3 install git+https://github.com/shemic/jupyter-mysql-kernel

and creating the folders and file ~/.local/config/mysql_config.json on my mac with the blow content:

{ "user" : "root", "port" : "3306", "host" : "127.0.0.1", "charset" : "utf8", "password" : "<password>" }

But now when running a new NoteBook with the MySQL kernel it just returns yes for all results:

which is kind of comforting, but obviously not functional! So I have created a ticket on their GitHub repo, however, given there are open tickets from a couple of years ago I'm not gonna hope my issue will be considered, at least any time soon. Now my questions are:

Are there any functional Jupyter or Jupyter Lab kernels for MySQL? Please consider that I have already figured the Jupyter magics out and that's not what I'm looking for.

Are you able to run the above kernel on other OSes or even macs? My environment is:

jupyter core : 4.6.3 jupyter-notebook : 6.0.3 qtconsole : 4.7.1 ipython : 7.13.0 ipykernel : 5.1.4 jupyter client : 6.0.0 jupyter lab : 2.0.0 nbconvert : 5.6.1 ipywidgets : 7.5.1 nbformat : 5.0.4 traitlets : 4.3.3 macOS Mojave version 10.14.6 Python 3.7.7

maybe I'm making any mistakes? for example, the path to mysql_config.json should be different on mac or the content? or if there are any workarounds to get the kernel working?

I would appreciate it if you could help me with these questions. Thanks for your support in advance.

P.S. I'm also aware of the jupyterlab-sql Jupyter Lab Extension. But firstly it is rather a GUI for tabular editing of the databases, than a real kernel where you can have cell-wise computations. And secondly, it seems to be outdated for the new Jupyter Lab versions. Installing it messed my Jupyter Lab extension manger as I have reported here.