Manage Databases Visually
Using DbSchema, you will interact with the database using the mouse. Even if you are not an SQL expert, you will be able to create new tables, columns, or foreign keys, explore the data from multiple tables, create reports or generate test data.
HTML5 Documentation
Complex databases need good documentation. Using DbSchema, you can organize the tables in multiple layouts, add comments, and generate HTML5 or PDF documentation. The documentation is using an interactive diagram image, where you can read the comments as mouse-over tooltips. The image below is such an example.
Read More
Video Presentation
Key Features
-
Conceptual & Logical Design
The conceptual and logical designs are database-independent and can use many-to-many, one-to-one relationships. The design can be converted to a physical design by applying data type and naming conversions.
Read more
-
-
Relational Data Explorer
Explore and edit the data from multiple tables based on foreign keys or virtual foreign keys. Exploring data in one table will show the matching records in the cascading tables.
Read more
-
-
Visual Query Builder
If you have less experience with SQL, you may use the Visual Query Builder to compose queries with different joins, filters, grouping, and ordering.
Read more
-
-
Data Generator
Testing software or queries may require a large volume of test data. The random data generator can generate test data using predefined patterns and reverse regular expressions.
Read more
-
-
SQL Editor
The SQL Editor features syntax highlighting and text auto-completion, query & script execution, graphical explain plan. The editor can automate different DbSchema processes using Java Groovy scripts, with access to DbSchema API.
Read more
-
-
Database Reports & Charts
DbSchema includes a flexible reports designer for the Web. The designer can create dynamic HTML pages where you can combine charts, master-details tables and input fields. The sheets can be run on a stand-alone server.
Read More
-
-
Schema Synchronization
The DbSchema model holds its image of the schema, separate from the database. Compare the schema model with any database, merge the differences in the model or commit them in the database, or generate SQL diff scripts.
Read More
-
-
Automate Database Tasks
DbSchema includes a Java Groovy script engine, which can execute Java scripts with access to DbSchema API. The engine allows to automate all kinds of processes, like schema reverse-engineer or schema deployment, generate HTML5 documentation, execute database queries, etc.
Read More
-
-
Virtual Foreign Keys
If the database lacks foreign keys, you can create virtual foreign keys. They are used for the design and by the Data Explorer or Query Builder. The virtual foreign keys are saved to the model file and not implemented in the database.
Read More
-
-
MongoDB Schema Validation & Diagrams
DbSchema can visualize the MongoDB databases as diagrams, implement validation rules, write native MongoDB queries, and explore the data. Creating new collections or fields using DbSchema will implement the schema validation rules in the database.
Read more
-
Data Loader
DbSchema can import the data into the database from various formats, like CSV, XLSX, XLS, and XML files.
Read More
-
-
CSV Editor for Large Files
Using DbSchema you can open and edit Gbyte large CSV files. The editor can filter and sort the column values.
Read more
-
DbSchema has a Free Edition
DbSchema has two editions: Free and Modeller Pro. After downloading DbSchema, you can evaluate the Modeller Pro for two weeks. No registration is required. After this time, the free edition will be enabled. If you decide, you can purchase a Pro license.
All Features Included
DbSchema Pro includes all features, like schema documentation, schema synchronization, data explorer, and more.
All Databases Included
With a license you can design all SQL, NoSQL, and Cloud databases
Money-Back Guarantee
Not happy with DbSchema? 30 days after your purchase you can claim your money back.
What Customers Says
Many compliments! It is one of the best software I've ever seen.
"The project team I am reporting to really likes the HTML5 documentation I send them. Thank you again for this brilliant software. I am recommending it to all my colleagues."
"Using Relational Data Editor I can see table data from multiple tables without writing SQL queries, it's like a child's play."
"I've had some time to play with and get acquainted with DbSchema. I am impressed. It never crashed once, it's very intuitive, and the compare/sync wizard is all I expected."
"DbSchema is to databases what an artist's brush is to the canvas by putting the art back into the schema management by making it painless and visually appealing. Easily communicating complicated schemas to non-technical people has brought them into the process without the SQL and geeky diagrams. Should be in every developer's toolbox."
Source: https://dbschema.com/
Posted by: cletusroldane0192941.blogspot.com
