Design the Schema in a Team & Deploy on Multiple Databases

DbSchema utilizes a design model, which is an independent internal copy of the database schema.
This design model can be saved to a file and shared with team members via GIT, allowing to deploy schema changes
in different environments: development, testing and production.

1
Design Offline
Design the schema without database connectivity.
2
Deploy on Different Databases
Connect to any other database, compare and deploy the model.

3
SQL Diff Scripts
Connect to any other database, compare the actual model with the database and generate the SQL differences script.
4
Migration Scripts
Compare two different versions of the same model and generate migration scripts between versions.

Document the Database using Interactive HTML5 Schema Diagrams

DbSchema can document the tables, columns and foreign keys, and generate HTML5 documentation with the vector image of the schema, where the table and column comments can be read as mouse-over tooltips.

DbSchema includes support for database synchronization and version control, making it a useful tool for teams working on database development projects.

Our Customers Love DbSchema

Many compliments! It is one of the best software I've ever seen.

Gianluca Fioletty

"The project team I am reporting to really likes the HTML5 documentation I send them.
Thank you again for this brilliant software. I am recommending it to all my colleagues."

Ben Burke, Software Developer, Sydney, Australia

"Using Relational Data Editor I can see table data from multiple tables without writing SQL queries, it's like a child's play."

Ariovaldo Chrysostomo, Database Developer Ricoh Europe

"I've had some time to play with and get acquainted with DbSchema. I am impressed.
It never crashed once, it's very intuitive, and the compare/sync wizard is all I expected."

Bert Scalzo

"DbSchema is to databases what an artist's brush is to the canvas by putting the art back into the schema management by making it painless and visually appealing.
Easily communicating complicated schemas to non-technical people has brought them into the process without the SQL and geeky diagrams.
Should be in every developer's toolbox."

Alan Williamson, Java Champion and CTO of MacLaurin Group

VIDEO PRESENTATIONS

OUR HIGHLIGHTS

Begin with the Logical Design

Design a high-level representation of your schema that is closer to the business model and independent to any particular database management system. The logical design can be mapped into multiple physical models.
Discover Your Data Relationally

Use the Relational Data Editor to visually navigate data across multiple tables linked by foreign keys or virtual foreign keys. Selecting a record in one table instantly reveals corresponding entries in the child tables. This intuitive interface serves as a powerful visual alternative to traditional SQL editing, making data exploration smooth and efficient.
Create SQL Queries with Ease

The Visual Query Builder simplifies the process of creating SQL queries through intuitive filters, ordering, and grouping options. Effortlessly generate complex SQL queries without needing in-depth knowledge of SQL syntax, making it accessible for everyone.
Easily Generate Test Data

Create test data effortlessly using a user-friendly graphical interface, perfect for testing your applications or database queries. Select from predefined generator patterns or utilize reverse regular expressions to produce random text tailored to your needs.
Edit and Execute SQL Queries Effortlessly

Use the SQL Editor to create, edit, and run SQL scripts easy. With features like syntax highlighting, auto-completion, and error checking, it enhances the scripting experience. Execute SQL scripts or Java automation scripts, all while enjoying direct access to the DbSchema API for maximum flexibility and efficiency.
Easily Deploy Your Schema Across Multiple Databases

With the Schema Synchronization feature, you can effortlessly compare and deploy your design model to any database or generate SQL scripts. This tool maintains an internal copy of your schema structure, keeping it distinct from the database itself. Additionally, you can save your design model to a file and share it with your team via GIT, ensuring seamless collaboration and version control.
Streamline Your Database Tasks with Automation

DbSchema features a powerful Java Groovy script engine that enables the execution of Java scripts with direct access to the DbSchema API. This functionality allows you to automate a wide range of processes, including schema reverse-engineering, deployment, generating HTML5 documentation, and executing database queries, all designed to enhance efficiency and save time.
Design with Virtual Foreign Keys

Virtual Foreign Keys enable you to establish relationships between tables without the need for actual foreign key constraints in the database. This feature is particularly beneficial when working with databases that have poorly defined or absent foreign keys. Virtual Foreign Keys can be utilized in the data editor, query builder, and schema design, enhancing your ability to create meaningful connections within your data structure.
Visualize Your MongoDB Design

DbSchema allows you to visualize MongoDB databases through intuitive diagrams, making it easy to implement validation rules, write native MongoDB queries, and explore your data. With built-in validation rules, users can ensure that all data inserted into the database adheres to specific criteria. These rules are defined using JSON schemas, clearly outlining the structure and properties of your documents for greater accuracy and consistency.
Import Data into the Database

The Data Loader simplifies the process of importing data into your database tables from a variety of file formats, including CSV, Excel, XML, and JSON. Featuring a user-friendly graphical interface, it enables users to easily map columns from their source files to the corresponding columns in their database tables. Plus, you can preview your data before importing, ensuring accuracy and efficiency throughout the process
Effortlessly Open and Edit Large CSV Files

With the CSV Editor, you can easily handle and edit large CSV files, even those in gigabyte sizes. This powerful tool allows you to filter and sort column values, making data management simple and efficient.
Experience the Dark Theme and Cutting-Edge Technology

DbSchema features a sleek dark theme for a comfortable user experience. Built on JavaFX and OpenJDK, DbSchema adheres to the highest data security standards, proudly holding ISO-27001 certification. Enjoy a modern design combined with robust security features for peace of mind.