I have periodically looked around for a good database front-end to design, explore and support database development that is independent of the back-end. I stumbled onto Minq Software’s DbVisualizer a few years ago and with its incredibly reasonable pricing I just upgrade periodically. The latest version (4.2) just stunned me (I haven’t upgraded for over a year) with its great UI and deep feature set.

It has too many great capabilities to list, but I will mention the visual representations of reverse-engineered relationships between tables, SQL bookmarking, simple driver management and auto-completion in the SQL editor.
It’s Java-based, and JDBC is the way it talks to engines. $99. Not too memory hungry (by today’s standards, anyway).
Rating: Strong Buy.
Related posts: