The only Mac only tool I know (and I would love to hear of others here) is SQLEditor. Great all-in-one tool for many DBs, including MySQL, Postgres, SQLITE. One of them allows for reverse-engineering and diagramming databases. Performance, and includes Entity-Relationship modeling capabilities. Apr 14, 2019 There often comes the time when you have an existing database and you need to build a nice diagram to analyse it quickly. Here is how to do it using open-source software. We are going to be working on a Mac running macOS 10.14 Mojave, as well as an SQLite database. The tool that we are going to use is Schemacrawler. It can generate very nice.
Database Design is a collection of processes that facilitate the design, development, implementation, and maintenance of database management systems (DBMS). Properly designed databases help you to improve data consistency for disk storage.
There are a wide range of software that helps you to design your database diagrams with ease. These apps can be used to create a physical model or ERD of your database so that you can quickly create tables and relationships.
Following is a handpicked list of Database Diagram Design Tools, with their popular features and website links. The list contains both open source(free) and commercial(paid) software.
1) Dbdiagram.io
Dbdiagram.io is a simple tool to draw ER (Entity Relationship) diagrams by just writing code. It is designed for developers and data analysts.
Features:
- You can directly generate the SQL statements.
- It enables you to share your diagrams with your colleagues.
- Integrate with web frameworks like Django, Rails, etc.
- Generating diagrams from SQL databases is possible.
- Dbdiagram.io diagrams can be exported to image and PDF files.
- It supports both forward engineering and reverse engineering.
Link:https://dbdiagram.io/home
2) SqlDBM
SqlDBM is a tool that provides an easy way to design your database on any browser. You do not require any other database engine or database modeling tools or apps to use this program.
Features:
- It allows you to import an existing database schema.
- You can manage large and small databases and data models easily.
- Zoom in or out diagrams is possible.
- SqlDBM has two themes, dark and light.
- You can customize your project view by using modes like table names only, the description only, keys only.
- It enables you to copy or move columns across tables.
- This program helps you to share company's projects with your colleagues.
- You can create a physical model or ERD of your database.
Link:https://sqldbm.com/Home/
3) Dbdesigner.net
Dbdesigner.net is an online database schema design and modeling tool. This app allows you to create a database without wiring a single SQL code.
Features:
- It has a user-friendly UI for designing database structure.
- The tool offers team collaboration & sharing of projects within your organization.
- It allows you to import an existing database or start from scratch.
- You can collaborate with your team and work on the model together.
- Dbdesigner.net helps you to export your database in PNG and PDF file formats.
Link:https://www.dbdesigner.net/
4) Visual Paradigm
Visual Paradigm is a database design and management tool. This software helps the product development team to build applications faster.
Features:
- It has a Drag-and-drop diagram editor.
- This tool enables you to export the database from ERD (Entity Relationship Diagram).
- It contains REST API for designing a database.
- You can work with your team on the same project simultaneously.
- Visual Paradigm enables you to build your report.
- It provides a wizard to make a database step by step.
- You can use Visual Paradigm on Windows, macOS, and Linux OS.
Link:https://www.visual-paradigm.com/features/database-design-with-erd-tools/
5) Erwin Data Modeler
Erwin is a tool which is used to create logical, physical, and conceptual data models. It provides centralize model management to business and technical users.
Features:
- It allows you to extract data from CRM, ERP, etc. for accurate modeling.
- Erwin Data Modeler has easy to use graphical environment.
- It automatically compares the model and database.
- You can manage structured and unstructured data from any database.
Link:http://erwin.com/products/erwin-data-modeler/
6) Moon Modeler
Moon Modeler is a tool for designing MariaDB and other databases. It enables you to draw diagrams and generate SQL server code.
Features:
- It enables you to design a nested structure for designing a database.
- This tool has predefined settings that help you to draw data models efficiently.
- You can export diagrams to printable PDF format.
- Moon Modeler allows you to connect database schema with JSON (JavaScript Object Notation).
- You can download this app for Windows or Linux.
- It helps you in creating ERD.
Link: https://www.datensen.com/data-modeling/moon-modeler-for-databases.html
7) Lucidchart
Lucidchart is a HTML5 based tool that allows you to create a complex database diagram. You can permanently delete any data or diagrams associated with your enterprise account.
Features:
- This tool allows you to connect live data with your diagrams.
- Lucidchart keeps your diagram secure using encryption.
- It is Integrated seamlessly with MS Office, G Suite, Atlassian (Issue tracking app), etc.
- You can work with your team on any device across various platforms.
- It helps you to easily manage user accounts.
- You can import data to automatically build organization charts.
Link:https://www.lucidchart.com/pages/examples/database-design-tool
8) QuickDBD
QuickDBD is a program that helps you to quickly draw a database diagram. It helps you to make your document looks professional.
Features:
- You can share your diagrams online.
- It enables you to draw schema (database structure) without leaving your keyboard.
- This tool has a user-friendly GUI.
- Diagrams can be dawn by typing.
Link:https://www.quickdatabasediagrams.com/
9) Toad World
Toad World is a database modeling software that helps you to tune application performance using an automated query rewriting facility. This software manages code change and promotes the highest levels of quality.
Features:
Intel, 64-bit processor. It helps Acorn get noticed, which helps everyone in the long run.REQUIREMENTS:. If you like Acorn, we’d love it if you could take a moment and give it a nice review. Fixed:Minor compatibility updates for macOS 10.15 Catalina.a problem where transparent gradients on shape layer shapes weren’t exporting as PDF correctly.a crasher that could occur when trying to create an image from the FaceTime camera.Fixed a problem where certain brushes weren’t drawing in a straight line when you press the shift key while drawing.Minor crop + bounds snapping fixes.a problem where Acorn wasn’t letting you enter math for the image resize fields.problem where Acorn wasn’t loading unsigned plugins. It feels right, and won’t drain your bank account.
- Access key data quickly for analysis.
- It can easily identify differences by comparing and syncing servers, data, and schemas.
- Rollback transactions directly from the transaction log without need to restore from a backup.
- Get powerful query tuning capabilities.
- Execute scripts and T-SQL snippets for numerous instances and servers.
- Automate repetitive processes like data and schema comparisons.
Link:http://www.toadworld.com/products/toad-data-modeler
10) Dataedo
Dataedo is an app that enables you to create data dictionaries, ER diagrams, and document server scripts. It enables you to easily document your relational databases.
Features:
- You can share documentation in interactive HTML.
- It helps you to visualize your data with database diagrams.
- This tool allows you to add meaningful information about your database.
- It enables you to share documents in PDF, Excel, and HTML file formats.
- You can create table relationships (One to one, one to many, and many to many) with ease.
Link:https://dataedo.com/ Epidata for mac pro.
11) Vertabelo
Vertabelo is online visual database design tool. It helps you to design your database at a logical and physical level.
Features:
- You can access database models anytime.
- It enables you to import an existing database.
- Vertabelo allows you to share the model with three access levels, like the owner, editor, or viewer.
- You can generate SQL script to create or remove elements from the database.
- Vertabelo automatically set the diagram layout.
- This app helps you to validate your model and workflow.
- You can provide a public link to your clients or partner so that they can view your design.
Link:https://www.vertabelo.com/
12) Dmodelaid
DModelAid is an online program for documenting database design in an interactive diagram. It helps you to retrieve large amounts of records from the database using SQL queries.
Features:
- You can visualize a table with tables with keys, indexes, and relationships.
- It supports keyboard shortcuts for easy access.
- This tool automatically documents your database project.
- You can create a project with Oracle, SQLite, MySQL, etc.
- DModelAid enables you to export script from the project to create the physical database.
- You can change the database any time you like, and it will map with the data type.
Link:https://www.dmodelaid.com/
13) SchemaSpy
SchemaSpy is a Java-based software that analyzes the metadata of a schema in your database. It helps you to simplify the database designing process.
Features:
- It supports JDBC (Java Database Connectivity) compliant DBMS.
- You can generate ER diagram for foreign keys.
- Schemaspy can produce database to HTML.
Link:http://schemaspy.org/
14) DBSchema
DbSchema is a program that helps you to visually design, document, and manages a relational database. One schema can be used for multiple databases.
Features:
- You can deploy one schema on more than one server.
- The migration of database schema between different versions is possible.
- It helps you to design database structure offline.
- A large database can be split into groups of tables.
- This tool allows you to generate HTML5 documentation.
- You can explore data from tables visually.
- It can accept more than 10000 tables per database.
- You can share the design of the schema in a team via email.
Link:https://dbschema.com/
15) DeZign
DeZign diagramming that tool allows you to visualize your data structures to create a new database. This app also helps you to understand your existing database tables and relationships.
Features:
- It provides easy to use and robust data modeling tool for developers.
- You can use this tool to visually make Entity Relationship Diagram (ERD).
- Navigate large diagram with pan and zoom window.
- It supports a range of data modeling techniques.
- The latest version of this tool helps you to reduce faults in database development.
- DeZign uses ERD to graphically design database.
- Exporting diagrams to bitmap, PNG, JPEG, and GIF is possible.
Link:https://www.datanamic.com/dezign/index.html
16) Database Designer for MySQL
Database Designer for MySQL is a program that helps you to construct build a graphical representation of tables and relationships.
Features:
- You can create and maintain the database effortlessly.
- It can generate reports that describe database objects within a diagram.
- It allows you to edit entity relationship diagram.
- Customization of diagrams and object appearance is possible.
- You can export a diagram to numerous formats, including BMP, JPEG, PNG, and more.
- Database Designer for MySQL helps you to edit and execute SQL scripts.
- Supports views (Virtual table), stored procedures (Set of SQL statements).
- This tool has a built-in database connection manager.
Link:https://www.microolap.com/products/database/mysql-designer/
17) Draw.io
Draw.IO is a free online diagram design tool. It helps you to create and manage the drawing easily. This app is compatible with all browsers like Chrome, Firefox, etc.
Features:
- No limit on the number of sizes.
- It allows you to save the model in your preferred location.
- This app provides a drag and drop feature.
- You can create a wide range of database diagrams, including UML (Unified Modeling Language), ERD, and much more.
- It provides readymade templates to design a database.
- You can work online and offline.
- Draw.io can be accessed from desktop and mobile devices.
Link:https://www.draw.io/
18) DbWrench
DbWrench is cross-platform database software. It enables you to review and compare databases. This tool can create HTML documentation of database designs.
Features:
- You can create and modify a database quickly.
- This tool contains numerous readymade templates.
- Dbwrench can be run on Windows, Mac OS X, and Linux.
- It has a navigator window to work with large diagrams.
- This tool can highlight SQL syntax.
- You can insert and update table rows and columns with automatically generated forms.
- This tool can be used to draw entity relationship diagram.
- It helps you to edit and execute SQL statements.
Link:http://www.dbwrench.com/