DbVisualizer: essential tool. I practically live in it. I have it open all day every day. I use it for ad-hoc reporting, quick updates, and to build up, debug and validate the queries I put into my software. It will connect to anything that has a JDBC driver.
One of the features I’ve used is the charting of foreign-key relationships to build a cube-wall sized poster of the data model for a product we installed. I pasted together 9 letter-sized sheets (the product knows how to print the huge image in segments). Life saver.
I use the free version, and I’ve even tried out the “personal” (i.e. for-pay) version on a trial license for a while and the graphing capability was pretty fun too, but I have other ways to do that and so didn’t go for it.
powered by performancing firefox