DbSchema is a universal database designer for out-of-the-box schema management, schema documentation, design in a team, and deployment on multiple databases.
DbSchema features tools for writing and executing queries, exploring the data, generating data, and building reports.
DbSchema supports all SQL and No-SQL databases,
including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google, and others.
No SQL knowledge is required to create new tables or query the data. DbSchema is a 100% visual.
Complex databases need good documentation.
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.
Read More
The DbSchema model holds its 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.
The conceptual and logical designs are abstract and database-independent. They can be converted into a physical design.
Read more
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.
Read more
Build queries with different join types, filters, grouping, and ordering.
Read more
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.
Read more
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.
Read more
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.
Read More
The DbSchema model holds its internal copy of the schema structure, separate from the database.
Comparing the model with any database, you can commit the differences in the database, generate SQL scripts or merge them in the model.
Read More
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.
Read More
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.
Read More
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.
Read more
DbSchema can import the data into the database from various formats, like CSV, XLSX, XLS, and XML files.
Read More
Use the CSV Editor to edit Gbyte large CSV files. The editor can filter and sort the column values.
Read more