Intuitive, easy-to-use, DbSchema can help to design and manage databases in team, generate HTML5 schema documentation, build SQL queries using the mouse, generate random data, explore data from multiple tables, edit and execute database queries.
DbSchema has a Free Community and a PRO Edition, available under the same installation kit. The PRO edition can be evaluated 15 days for free.
DIRECT DOWNLOAD EDITIONS
DBSchema can work with all SQL and NoSQL databases, reverse engineer the schema from the database and generate visual diagrams.
DbSchema uses the design model, an internal copy independent of the database, to store the schema.
The design model can be saved to a file and shared with a team using GIT, the best solution with respect to data privacy and security.
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.
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 testing the application or database queries. Choose between predefined generator patterns and reverse regular expressions for generating random text.
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.
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.
DbSchema offers both Pro and Community (free) editions, using the same software kit for both. Upon download, the Pro edition is automatically activated for two weeks without any registration. After this period, you can either extend the evaluation key, purchase a Pro license, or continue with the Community edition.
