DbSchema is a universal database design tool for out-of-the-box schema management, schema documentation, design in a team, and deployment on multiple databases.
DbSchema has Free Community & Pro Editions, both available under the same installation kits.
DBSchema features include the ability to reverse engineer an existing database schema, support for multiple database management systems (including MySQL, PostgreSQL, Oracle, SQL Server, and more), and the ability to generate SQL scripts for creating or modifying the database schema.
DbSchema can be used to document the database schema. The documentation includes the vector image of the schema, where the table and column comments are readable as mouse-over tooltips. The schema documentation can help understand the structure of the database, track changes, and communicate the schema to other team members.
In addition to database design and management, DBSchema also includes features for data exploration and manipulation, including the ability to browse and edit data in tables, views, and queries. The tool also 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.
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 tool allows to interact with and explore relational databases visually. It provides a graphical interface for navigating through multiple table simultaneously. Selecting a record in one table will refresh the children tables, showing the matching records based on foreign keys or virtual foreign keys.
Build queries visually, without having to write complex SQL code. The editor can build and execute queries, filter and sort the data, join tables, aggregate and preview the data.
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.
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. DbSchema can visualize the MongoDB databases as diagrams, implement validation rules, write native MongoDB queries, and explore the data.
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.
