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 a Free Community Edition.
No SQL knowledge is required to create new tables or query the data. DbSchema is a 100% visual.
Using DbSchema, you can organize the tables in multiple layouts, add comments and generate HTML5 or PDF documentation including the diagram vector image. The image is interactive - hover table or columns to read the schema comments.
The design model is a copy of the schema structure, independent of the database. The model is saved to a file and can be shared with a team using GIT.
An abstract design, which can be converted to physical design and deployed into the database. It uses entities, different relations: identifying, many-to-many, one-to-many, etc.
Explore and edit the data from multiple tables bound by foreign keys or virtual foreign keys. Selecting a record in one table will refresh the children's tables with the matching records.
Build queries with different join types, filters, grouping, and ordering.
For testing queries or applications, you may require randomly generated data. The data generator can fill the tables with data based on configurable patterns and reverse regular expressions.
The SQL Editor features syntax highlighting and text auto-completion, query & script execution, and a graphical execution plan. The editor can automate different DbSchema processes using Java Groovy scripts, with access to DbSchema API.
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.
The design model contains an internal copy of the schema structure, separate from the database. Connecting to another database you can compare the design model with the database, commit the differences in the database, merge in the design model or generate SQL scripts.
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.
If the database lacks foreign keys, you can create virtual foreign keys. They are helping for doing a better design and are also used by the Relational Data Editor or Query Builder. The virtual foreign keys are saved to the model file and not implemented in the database.
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.
DbSchema can import the data into the database from various formats, like CSV, XLSX, XLS, and XML files.
Use the CSV Editor to edit Gbyte large CSV files. The editor can filter and sort the column values.