DbSchema is for visual designing the schema in a team, deploy and document the schema.
Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema
an every-day tool for everybody who interacts with databases.
DbSchema supports all relational and No-SQL databases,
including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more.
DbSchema Free is one of the most powerful tools in its market area.
DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools.
Create state-of-the-art database documentation as
HTML5 or PDF where the comments can be read as mouse-over tooltips.
Read More
DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.
Build queries just using the mouse, with different Join types, and Group By and Order clause.
Read more
Visualize the data from multiple tables simultaneously,
by using foreign keys or virtual foreign keys.
Read more
Create master-detail reports with tables, charts and buttons.
Read More
The editor features syntax highlighting and text auto-completion, query and script execution, Java Groovy scripts, and graphical query execution plan.
Read more
All major processes, including schema reverse-engineer or schema deployment, can be automated using Java scripts with access to DbSchema API.
Read More
The DbSchema model is using its own image of the schema, distinct from the database.
The design model can be compared with any database, changes can be applied in the database and SQL scripts can be generated.
Read More
Software developers and DB admins may need sample data for testing queries or the application.
The data generator is mastering reverse regular expressions and predefined patterns.
Read more
The foreign keys are used to ensure data consistency.
If the database lacks foreign keys, you can create virtual foreign keys.
They help to understand the schema structure and can be used in the Relational Data Explorer and Query Builder.
Read More
MongoDB uses validation rules to validate collections data. DbSchema can graphically edit the validation schema and save it into the database.
DbSchema can also execute native MongoDB queries, visualize data using Relational Data Explorer, and generate test data.
Read more
DbSchema makes it easy to import data into the database from various data sources, including CSV, XLSX, XLS, and XML files.
Read More