Visual, easy-to-use, DbSchema can help to design SQL and NoSQL databases using interactive diagrams, share the schema design in team, generate HTML5 schema documentation, visually build SQL queries, generate random data, explore data from multiple tables, edit and execute database queries.
DbSchema has a Free Community & Pro Edition, available under the same installation kit.
DIRECT DOWNLOAD EDITIONS
DBSchema has the ability to reverse engineer an existing database schema from the database and generate SQL scripts for creating or modifying the database schema.
DbSchema can document the tables, columns and foreign keys, and generate HTML5 documentation with the vector image of the schema, where the table and column comments can be read as mouse-over tooltips.
DbSchema includes support for database synchronization and version control, making it a useful tool for teams working on database development projects.
DbSchema uses the design model, an internal copy of the schema structure, independent of the database, to design the schema. The design model can be saved to a file and shared with a team using GIT.
Create a high-level representation of the schema that is independent of any specific database management system and it provides a clear understanding of design and how it relates to the organization or system being modeled. The logical design can be mapped into a specific physical database management system.
The Relational Data Explorer can visually explore the data from multiple tables, bind by foreign keys or virtual foreign keys. Selecting a record in one table will show the matching records in the children tables. The Data Explorer is a visual alternative to the SQL queries.
The Visual Query Builder can help writing SQL queries, using filters, ordering and grouping. Users can create complex SQL queries without having extensive knowledge of SQL syntax.
Create test data using a graphical interface for defining data sets and generating large amounts of realistic data. The tool can perform a variety of tasks, including: defining data sets, generating, customizing and exporting the data, exporting data sets.
The SQL Editor can create, edit, and execute SQL scripts within the DBSchema application. The editor features syntax highlighting, auto-completion, error checking, executing SQL scripts or Java automation scripts with access to DbSchema API.
The Report Designer is a tool that allows to create and customize reports based on their database schema. With this tool, users can design and generate a wide range of reports, including tabular reports, summary reports, charts, and more.
Schema Synchronization is a feature that allows comparison and deploys the design model into any database or generates the SQL scripts. The design model uses its internal copy of the schema structure, separate from the database. The design model can be saved to a file and shared with the team using GIT.
DbSchema includes a Java Groovy script engine, which can execute Java scripts with access to DbSchema API. The engine allows automating all kinds of processes, like schema reverse-engineer or schema deployment, generating HTML5 documentation, executing database queries, etc.
Virtual Foreign Keys allow defining relationships between tables without creating actual foreign key constraints in the database. This feature is useful when you work with databases with poorly defined or no foreign keys. The Virtual Foreign Keys are used by the data explorer, query builder, and to design the schema.
DbSchema can visualize the MongoDB databases as diagrams, implement validation rules, write native MongoDB queries, and explore the data. MongoDB provides validation rules that allow users to ensure that the data inserted into the database meets certain criteria. The validation rules are defined using JSON schemas that describe the structure and properties of the documents.
The Data Loader allows importing data into database tables from various file formats, such as CSV, Excel, XML, and JSON. It provides a graphical user interface that allows users to map the columns in their source files to the columns in their database tables and also allows users to preview the data before importing it.
Use the CSV Editor to edit Gbyte large CSV files. The editor can filter and sort the column values.
DbSchema supports the dark theme.
DbSchema is being developed using JavaFX and OpenJDK.
We meet the highest standards for data security, and we are ISO-27001 certified.
