Yes, the software is free. I've downloaded the installation package and installed it on my PC. I've also launched it and connected to a MySQL server and it worked normally. While I was using the application, there were no nag screens or pop ups related to registration or something about it.
You can download the software from the following page: http://www.mysqlfront.de/