SQL Edge - the best SQL query tool to visualize data relationship

For product details, please visit http://www.baybreezesoft.com

If you're developing an object-oriented application that accesses relational databases, SQL Edge is the best SQL query tool for you. To support OO application, the relational schema is often derived from the object model which is pretty deep and tedious to navigate with normal DB tools. SQL Edge is the perfect query tool to navigate the data relationships.

SQL Edge is built upon open source Eclipse Rich client platform. Besides its ease of use, cross platform support and state of the art UI interface, it also enables us to aggressively price the product at $19.99 per copy.

SQL Edge allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships.

With SQL Edge, users can use only one query to retrieve data in a master table, and then browse data in all related detail tables. Users can also insert, edit, and delete table records in the data grids.

SQL Edge has five perspectives. The "Query Perspective" allows users run any SQL queries, while the "Schema Perspective" displays table schema information.

There are two relationship perspectives. The "Relationship Table View" displays data in the master-detail style. The "Relationship Tree View" displays master table records as top-level tree nodes. The nodes can be expanded to reveal any level of related detail records. In addition, clicking any node will display the corresponding data in a detail grid.

The "Model Perspective" displays tables and their relationships in ER diagrams. The tables can be from different databases. Users can define master-detail relationships among these tables, and print or save the diagram for future reference.


The major features are:


(1) Support any JDBC compatible databases.

(2) Allow users to specify JDBC drivers at run-time, and provide wizards to help setup JDBC connections. Easy to install, and easy to setup.

(3) SQL editor with syntax highlighting based on currently connected databases.

(4) SQL edtior allows users to execute SQL queries asynchronously. Users can cancel the execution by click the "Cancel" button or just close the SQL Editor.

(5) Schema perspective displays the table schema information, including column definitions, primary key, indexes, and foreign keys.

(6) Relationship table view displays the related data in the master-detail style, with master table data shown in the top grid, and all related detail table data in a list of bottom grids.

(7) Relationship tree view displays the master table records as top-level tree nodes, and the related detail records as child nodes. Click any of these tree nodes will display the corresponding record data in a detail grid.

(8) Allow users to insert, edit, and delete records in the master and detail grids of the relationship table view and relationship tree view.

(9) Allow users to define master-detail relationships even between tables in different databases. This enables the relationship table view and relationship tree view to display data relationships between tables in different databases or without pre-defined foreign keys.

(10) Model perspective to display tables and their relationships in ER diagrams. The tables can be from different databases. Users can define master-detail relationships among these tables, and print or save the diagram for future reference.