* No SQL knowledge are required - everything can be done using the mouse
* Amazing simple Relational Data Browse
* Design schema, browse the data, build and run queries using a single tool
* Compatible with most of the relational databases
* Design the schema with no need to stay connected to the database
Key features:
Relational Data Browse Browse Database data using the mouse
An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.
Multiple graphical layouts
Build separate layouts ( diagrams ) for each module of your database schema. Like this you can focus better on each layout, add comments, have a nice graphical representation, do browse, sql, etc.
Visual Query Builder Build queries using the mouse
Graphically compose complex queries with INNER, OUTER, EXISTS joins, filters and group by clauses. This in a visual way, using diagrams, for a better understanding of the relations between tables.
Highlight-enabled SQL editor
Using the higlight-enabled SQL editor you can edit and execute the SQL phrases. Execute simple queries or scripts, with output on screen or in disk files.
Database schema synchronization and team work
With DbSchema you can work offline, as it stores schema in its own project which can be saved on disk ( XML ). Then you can synchronize your project with different databases, either refresh or commit the schema changes from the database
Schema documentation
DbSchema supports documentation from the ground up, allowing every table, column, index, etc. to have an associated comment or description. DbSchema can generate documentation in several formats (HTML, SVG, etc ...) or can generate comments SQL scripts.