DBeauty

Included in the Jailer comprehensive database suite yet also available in the form of a separate package, DBeauty is a complex relational database tool that makes it as simple as possible for you to browse, analyze the contents of virtually any SQL database.

In short, this useful utility allows you to bidirectionally navigate through the contents of your database based on various user-defined or other types of relationships. Also noteworthy is the fact that the app bundles a Query builder (and it can likewise run arbitrary SQL queries), A SQL and DML generator, and that it can detect foreign keys automatically.

Before you get started with this application, please note that it requires the presence of Java on your computer's system in order to be installed. Once installed, you can proceed forward by either creating a new data model or by selecting a demo from the app's Data Browser.

Once you click the Analyze button, you're immediately prompted to provide all the database connection information. Subsequently, you should be able to get a glimpse of the app's main window which sports a fairly typical layout for a database application. The user interface is not much of a looker either, just like most Java apps, for that matter.

You can browse tables, related rows, and generate and edit SQL queries, all from the app's main window. There's also a simple menu bar that allows you to create new Data Browser sessions, to analyze the database, access the data model editor, export data, or import SQL data.

DBeauty is a decent database utility that despite its somewhat outdated looks, does a good job of allowing you to analyze the contents of your SQL databases and freely navigate through their contents. You can download both the installer and portable editions from this page.