Powerful, yet easy-to-use, DbSchema helps you graphically design, document, share the schema in a team and deploy it on multiple databases.
Free Download Purchase DbSchema
Designing your database has never been easier! You will manage the schema visually, over diagrams.
You can document the database schema and generate interactive HTML5 or PDF documentation as diagram image with comments.
DbSchema is using its own image of the schema, separate from the database. Advantages:
Use the Relational Data Browse to simultaneously view data from multiple tables
bind by foreign keys or virtual foreign keys.
Once opened, you can easily edit data right in the table.
Build complex queries without writing any line of code. Use the powerful Visual Query Builder to create Joins and Group By functions.
Auto-complete enabled editor for editing and executing SQL queries.
Fill tables with random data matching preconfigured patterns or given reverse regular expressions.
DbSchema can compare schemas between different databases or different project files, show them and generate migration scripts.
You can open the project file without being connected to the database (offline) and synchronize later.
Streamline your work! Use Groovy scripts to automate schema deployment & migration, HTML5 documentation export, the reverse engineering of the schema, and many more.
If the database lacks foreign keys, you can create Virtual Foreign Keys that will be saved only in DbSchema.
They will help you gain a better understanding of the database.
These foreign keys are marked with green.
Build master-details responsive HTML reports or small applications with input fields and buttons to access and edit data from the database.
DbSchema can load data in the database from various formats, such as: CSV, XML, TXT, etc.
For schemaless databases like MongoDb DbSchema deduces a virtual schema by introspecting the data and represents it as diagrams. This will help you to organize and document MongoDb databases. Details here