Svenv.nl

Home dbeaver_small

5 cross-platform alternatives to HeidiSQL

When it comes to database administration, HeidiSQL seems to be the best (gui) tool available. Unfortunately, it's only available for Windows and it doesn't look like a cross-platform is coming anytime soon. Fortunately, there are some really good cross-platform alternatives and in this post I will have a quick look at five of them:

MySQL Workbench

MySQL Workbench is a MySQL client maintained by Oracle (which also maintains MySQL server these days). It is the most advanced client I've tested and packs some really nice features like server load statistics. On the downside: it seems to be a bit unstable and occasionally crashed on my system.

website

Toad

Toad is a nice client developed and maintained by Dell that supports multiple database platforms. The interface is is clear and it seems to be quite stable. It doesn't have some of the advanced features of other clients but for typical usage this shouldn't be a problem.

website

DBeaver (editors choice)

DBeaver is my personal favorite. It is developed and maintained by a company named JKISS. It is well packed with features, supports multiple database platforms and seems to be stable. The interface is based on Eclipse and is easy to understand. The only problem I encountered with this program is when I tried to make a database dump when DBeaver required me to point to manual installed 'mysqldump' instance.

website

SQuireLSQL

SQuireLSQL is a community developed, Java written client. My experiences with it weren't any good. It may require manual installation of JDBC drivers and it feels a bit unstable. I personally can only recommend picking any of the other clients available.

website

Emma

Emma is a nice tiny and fast database client written in Python, it's extremely lightweight and the feature set is just enough for basic CRUD operations. Emma's interface shines in simplicity. It's quite stable (though occasional crashes may appear). It's perfect for simple databases.

Ubuntu Apps Directory

Conclusion

When you don't want to fall back to a command line, many graphical database clients are available and they all differ in terms of stability and features. The most advanced client is MySQL Workbench, but occasional crashes (on my system) made me look for an alternative. I was really impressed with the feature set and stability of DBeaver and this will be my goto client. If you're however, looking for a lightweight alternative I would suggest Emma. But off course, the choice is yours.

Thanks for reading!

Published on June 16, 2015, 10:39 a.m.