Database Schema Design Tool Mysql

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.

Read more
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.

Read more
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.

Read more
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.

Read more
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.

Read more
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.

Read More
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.

Read More
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.

Read More
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.

Read More
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.

Read more
Data Loader

DbSchema can import the data into the database from various formats, like CSV, XLSX, XLS, and XML files.

Read More
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.

Read more

DbSchema has a Free Edition

DbSchema has two editions: Free and Modeller Pro. After downloading DbSchema, you can evaluate the Modeller Pro for two weeks. No registration is required. After this time, the free edition will be enabled. If you decide, you can purchase a Pro license.

All Features Included

DbSchema Pro includes all features, like schema documentation, schema synchronization, data explorer, and more.

All Databases Included

With a license you can design all SQL, NoSQL, and Cloud databases

Money-Back Guarantee

Not happy with DbSchema? 30 days after your purchase you can claim your money back.

What Customers Says

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

"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."

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

"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."

"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."