QuickDBD is an online service that lets you Define your schema in one pane and then generates a diagram accordingly. You can then save your diagram in a variety of formats as well as collaborate with others online, but you'll need to create an account in order to do that. The free level gives you 1 public diagram and 10 tables. Paid plans are $7 for a week, $14/month, and $95/year for unlimited tables and private diagrams.
Right now they are currently offering free plans in exchange for publicity. Just write a review on your blog or other website and get 1 year for FREE.
Database Diagram Tool: SQLDBM
SqlDBM is another online service that offers you an easy and convenient way to design your database on any browser, working away without need for any extra database engine or database modelling tools or apps. SqlDBM can incorporate any needed database rules and objects such as database keys, schemas, indexes, column constraints and relationships. It also supports reverse engineering. You just have to import an existing database into SqlDBM and run the reverse engineer process. No database credentials are required for this.
It only supports MySQL and MS SQL at this time. There are three pricing packages ranging from free to $51 per Month for unlimited everything.
Database Diagram Tool: Navicat Premium
It should be noted that some professional database clients have design capabilities built-in. These are often superior to free specialized tools. Navicat Premium is a shining example of a product that offers superlative database modeling as part of a larger product. Its sophisticated database design and modeling tool lets you visualize and edit your databases using an editor which is as visually as stunning as it is easy to use.
Although it's not free, many DBAs and database designers swear by Navicat.
Database Diagram Tool: Lucidchart
Lucidchart is cloud-based and collaborative diagram software that is geared towards development teams. In that capacity, it helps you and your team create database diagram, as well as flowcharts, process maps, UML models, org charts (etc) on any device and platform. Lucidchart is integrated with tools such as G Suite and Microsoft Office and is well suited to designers who want a drag-and-drop interface.
They offer a Free plan that comes with a limit of 3 diagrams and 60 objects per diagram. Paid plans range from $4.95 to $20 per month.
Database Diagram Tool: MySQL Workbench
Good ole MySQL Workbench provides DBAs and developers an integrated tools environment for a variety of tasks including:
Database Design & Modeling
The free Community (OSS) Edition also provides extensive capabilities for creating and manipulating database models, such as the ability to:
Create and manipulate a model graphically.
Reverse engineer a live database to a model.
Forward engineer a model to a script or live database.
Create and edit tables and insert data.
Database Diagram Tool: Draw.io
Draw.io is a free online diagram application for making flowcharts, process diagrams, etc. It allows several different types of charts such as flowcharts, org charts, UML, ER and network diagrams. You can save your diagrams to cloud storage services like GDrive, Dropbox and OneDrive, or to your own computer. Some users have stated that Draw.io's visual interface is not as nice as similar products such as lucidchart, but don't let that stop you from trying it out for yourself.
Database Diagram Tool: dbForge Studio for MySQL
dbForge Studio for MySQL is a universal GUI client for MySQL and MariaDB database development, management, and administration. As such, the IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, and analyze table data via, among other things. Think of it as a commercial alternative to MySQL Workbench.
The Database Designer can create, analyze, reverse-engineer, print and customize your MySQL databases
dbForge Studio comes in three editions: Standard Edition ($149.95), Professional Edition ($299.95), and Enterprise Edition ($399.95).
Database Diagram Tool: SQLGate
SQLGate is an integrated database management and development solution that simplifies the construction and operation of databases. It provides quick data analysis functions like filter, sort and group on grid, as well as copy, paste, sum and statistics functions like excel.
There is a free version that is limited to 10 tables in the ERD designer. The $40/month SQLGate Suite includes SQLGate for Oracle, SQLServer, PostgreSQL, Tibero, MariaDB, and MySQL databases. You can also purchase one DB type for $15 - $25 per month, depending on the DB type.
Database Diagram Tool: Data Xtractor
Data Xtractor is a Free visual data modeling inspection tool for most popular relational databases. Its graphical interface supports auto-generated detailed, structural, relationships, simple, graph or topological models. Shapes can be expanded, collapsed, minified or made transparent. You can also chain relationships, custom joins and aliases, to enhance your model without altering the database itself.
You can virtually enhance your local data model with custom joins, chain relationships and name aliases, without actually changing anything on the database server. It also supports conceptual many-to-many relationships, the bypassing of hidden intersection tables, auto-generated relationship items, as well as the detection and expansion of relationships into connectors via simple drag and drop.
Database Diagram Tool: DbSchema
DbSchema is a diagram-oriented database tool compatible with all relational and many NoSQL databases, including MySQL, Cassandra, PostgreSql, MongoDb, Redshift, SqlServer, Azure, Oracle, Teradata and more.
Using DbSchema, you can design the schema with or without a database, save the design as project file, deploy schema on multiple databases and share the design in a team. Build-in tools allows to visually explore the database data, build and execute queries, generate random data, build forms applications or reports and more.
DbSchema can be evaluated for 15 days for free, with no registration required. It's available in 3 flavors: Academic (for educational purposes) at $63, Personal (for individual developers, administrators) at $127, and Commercial (for companies) at $197.
Your database schema acts as the blueprints for your database; its job is to represent the database structure, data types, and table constraints. Designing the database schema is one of the very first and most important steps in building a new database. Although not obligatory, employing specialized software does make the process much easier to accomplish. With that being said, here is a list of 10 free and commercial tools that you can use to design your MySQL databases, in no particular order.
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.