DbSchema: Database Diagram Designer

Collaborative Database Design and Management For all SQL and NoSQL databases

25% Off

$147 $196.00

Get This Deal

DbSchema isn't for everyone, but if you work with or want to learn to work with SQL or NoSQL, today's deal is especially for you!

If you are programmer, system architect or database administrator, DbSchema is one of the tools which may help you during your daily work. DbSchema may help you to design schema in team, deploy the schema on multiple databases, document the schema and generate HTML5 documentation, generate schema migration scripts, visually explore the data and write SQL queries, generate random data, and create HTML reports.

Team Design and Schema Deployment DbSchema reverse engineers the schema from the database in its own design model, that will be saved to the file. The design model is database-independent and can be deployed into any database. The design model file can be shared in a team using GIT. Comparing different versions of the same schema model you can generate SQL migration scripts.

Manage the Schema on Multiple Databases DbSchema can connect to different databases without affecting the schema model. This schema can be compared and deployed on any database, migration scripts can be generated.

Graphical Interaction with the Schema DbSchema use layouts (diagrams) to represent the database schema. To get a better representation of the schema you can create multiple layouts with the same or different tables. Tables, columns and foreign keys can be edited directly in the layout. Layouts will be saved to model file and can be later reopen. If the schema is missing foreign keys, you can create virtual foreign keys.

Visually Explore the Data Relational Data Browse is a module for simultaneous exploring data from multiple tables, based on foreign keys or virtual foreign keys. Exploring the data in one table will refresh the children tables with the matching records. The editor can insert new records or edit the exiting data.

Interactive HTML5 or PDF Documentation A good design required a good documentation. Using DbSchema you can document each table and column, and generate HTML5 or PDF documentation with the vector image of the schema, where the table and column comments can be read as mouse-over tooltips. Vector images have a small size and are interactive.

Random Data Generator The generator can fill tables with random data, which may be usefull in testing the SQL queries or the software application. The generator can use patterns or reverse regular expressions.

Query Editors For editing SQL queries you can use the Visual Query Builder or the SQL Editor. The graphical query builder features filters, JOINS, GROUP BY and ORDER BY. The SQL Editor features text autocompletion and explain plan.

Open the Design Model Without Connectivity to the Database Schema can be designed even without any database. The design will be saved to model file and later can be created on any database or converted between different databases.

DbShell A free universal SQL command-line client, featuring simultaneous connection and query execution on multiple databases, data transfer between databases, execution of complex database scripts with Java scripts, schedule database scripts with cronscript and more.