DbSchema is a universal database designer for out-of-the-box schema management and documentation, sharing the schema in the team, and deploying on different databases. Visual tools can help developers, database administrators, and decision-makers to query, explore and manage the data.
DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google, and more.
Manage Databases Visually
Using DbSchema, you will interact with the database using the mouse. Even if you are not an SQL expert, you will be able to create new tables, columns, or foreign keys, explore the data from multiple tables, create reports or generate test data.
HTML5 Documentation
Complex databases need good documentation. Using DbSchema, you can organize the tables in multiple layouts, add comments, and generate HTML5 or PDF documentation. The documentation is using an interactive diagram image, where you can read the comments as mouse-over tooltips. The image below is such an example.
Key Features
Conceptual & Logical Design
The conceptual and logical designs are database-independent and can use many-to-many, one-to-one relationships. The design can be converted to a physical design by applying data type and naming conversions.
Relational Data Explorer
Explore and edit the data from multiple tables based on foreign keys or virtual foreign keys. Exploring data in one table will show the matching records in the cascading tables.
Visual Query Builder
If you have less experience with SQL, you may use the Visual Query Builder to compose queries with different joins, filters, grouping, and ordering.
Data Generator
Testing software or queries may require a large volume of test data. The random data generator can generate test data using predefined patterns and reverse regular expressions.
SQL Editor
The SQL Editor features syntax highlighting and text auto-completion, query & script execution, graphical explain plan. The editor can automate different DbSchema processes using Java Groovy scripts, with access to DbSchema API.
Database Reports & Charts
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.
Schema Synchronization
The DbSchema model holds its image of the schema, separate from the database. Compare the schema model with any database, merge the differences in the model or commit them in the database, or generate SQL diff scripts.
Automate Database Tasks
DbSchema includes a Java Groovy script engine, which can execute Java scripts with access to DbSchema API. The engine allows to automate all kinds of processes, like schema reverse-engineer or schema deployment, generate HTML5 documentation, execute database queries, etc.
Virtual Foreign Keys
If the database lacks foreign keys, you can create virtual foreign keys. They are used for the design and by the Data Explorer or Query Builder. The virtual foreign keys are saved to the model file and not implemented in the database.
MongoDB Schema Validation & Diagrams
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.
Data Loader
DbSchema can import the data into the database from various formats, like CSV, XLSX, XLS, and XML files.
CSV Editor for Large Files
Using DbSchema you can open and edit Gbyte large CSV files. The editor can filter and sort the column values.
