I don't fully understand your question. If you're asking whether this client will work with memsql, then the answer is No. Unless, memsql uses mysql protocol to talk to clients.

Mycli uses MySQL adapter called PyMySQL to connect to MySQL instances. I don't think it'll work with memsql.

If you're talking about writing a similar client for memsql, then yes it is possible to do that as long as there is a Python adapter for it.