DbSchema is a JDataStore management tool that provides a powerful graphical interface for visually interacting with the database. DbSchema features the design model, which allows schema design in teams and deployment into multiple databases. Users can document the database schema, explore and query the data, generate random data, build reports and more.
Download DbSchema Editions
After connecting to the database, DbSchema will reverse engineer the JDataStore database structure in its model and visualize it graphically. You will interact with the schema using layouts (diagrams). The layouts can handle large databases with more than 10.000 tables. The graphical interaction will help to improve the database design.
The DbSchema model refers to the representation of a database schema within the DbSchema application.
DbSchema model is using its copy of schema structure, independent from the JDataStore database.
This is a separation between schema design and the database, with numerous advantages:
Compare and deploy the database schema on multiple JDataStore databases. Incremental changes can be applied.
Save the design model including the schema structure to model file, as XML text. The model file can be open from any computer, without JDataStore connectivity.
The model file can be stored in GIT and shared in a team. Each team member can modify it and commit model changes in GIT. Database administrators can deploy the schema changes on testing or production databases.
Generate migration scripts from one version of the schema to another by comparing two different model files with two versions of the same schema.
Schema can be designed offline, without database connectivity.
In DbSchema, layouts refer to the visual arrangements and configurations of various components within the application's workspace. Layouts help users organize their work by defining the positioning and visibility of elements such as database diagrams, SQL editors, query results, and other tool windows. DbSchema offers different predefined layouts, such as Design, Query, and Reports, which can be customized and saved based on individual preferences and project requirements. These layouts allow users to switch between different views and focus on specific tasks or aspects of their database work.
Create multiple layouts (diagrams) with the same or different tables. Edit tables and columns directly in the diagram. The layouts will be saved to the model file.
Add comments to each table or column and generate JDataStore interactive HTML5 or PDF documentation as diagram image with comments.
Read More
An amazingly simple JDataStore data editor and editor that offers simultaneous views of data from multiple tables, and features numerous filters, data sorting mechanisms, and much more.
The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables.
If the schema is missing foreign keys you can create virtual foreign keys that will be part of the DbSchema model.
Read more
There is no need to be an JDataStore SQL pro to be able to write database queries.
Create queries is an easy task for the Visual Query Builder. The builder can use different Join types and Group By functions.
Read more
The JDataStore SQL Editor features syntax highlight, text auto-completion, query and script execution, Groovy support, graphical execution plan.
Read more
For development or test purposes you may need to fill the JDataStore database with randomly generated data.
A bunch of predefined reverse regular expressions as well numbers, date, JSON, and groovy script generators will help you.
Read more
DbSchema uses its own images of the schema, distinct from the JDataStore database, which is saved as a model file.
The DbSchema model can be compared with any database.
For each difference, you can decide to merge in the DbSchema model, apply it in the database, or generate the SQL scripts.
Read More
All major DbSchema processes, like schema synchronization and deployment, generate documentation,
reverse engineer schema structure can be automated using Groovy or JS scripts with direct access to DbSchema API.
Read More
Foreign keys are used for data accuracy.
If the database lacks foreign keys, you can create Virtual Foreign Keys that will be created only in the DbSchema model
and will be saved to the model file.
They will help you to gain a better understanding of the database.
Read More
You don't need a separate tool to build database forms or reports.
DbSchema can create responsive web reports which you can deploy on a separate server.
You may also create small applications with input fields, buttons, and charts.
Read More
Import data from various files, including CSV, XLSX, XLS, XML, into the database.
Read More
