What are the best DB schema design tools?

asked by Anonymous
106 contributors
13 solutions
  1. 18

    #1Vertabelo

    Vertabelo
    Vertabelo is an online data modeling tool for PostgreSQL, MySQL, SQLServer, Oracle, DB2, SQLite, HSQLDB. Start modeling without registration.
    Websites

    Free- Varies by plan

    George Wagner
    Written on September 8, 2017
    "Step by step instructions for designing your own database. Great for recent graduates and entry level positions. Easily shared with coworkers and you can control access."
  2. 13

    #2SQL Power Architect

    SQL Power Architect
    The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect.
    Software

    Windows

    Free- Varies by plan

    Christian Vargas
    Written on April 21, 2017
    "SQL Power software has different versions available depending on your specific needs. you can try it out on a trial basis to see how much you like it. I recommend this software highly and it is very well designed."
  3. 13

    #3DBdesigner

    DBdesigner
    DbDesigner is a web application which allows you to design your database schema without writing SQL. You can design your database schema just like creating a UML diagram.
    Websites

    Free- Varies by plan

    Johnny Hall
    Written on May 24, 2017
    "In my new job I needed to compile a lot of information in databases. The only problem with that is that I have little to no experience with writing SQL. DBdesigner allows me to enter the data I need and converts it using SQL or any other format I need."

WHAT'S THE MEANING?

Database Schema is the layout of the flow and arrangement of a database.  It is likened to the skeletal structure of the body since it shows the linear connection and the relationships of folders and systems. The database schema can either be a physical database schema or a logical database schema.

DID YOU KNOW?

Did you know the ERwin Data Modeler is widely considered as the best database modeling tool and has many notable users including the United Nations? In 1992, Computerworld reported that the United Nations Development Programme, the arm of the UN for global development, used ERwin to create a corporate database model that will integrate all its systems from its 120 field offices worldwide. Nine years later, Aetna, an insurance and healthcare company and a member of the Fortune 500, used the ERwin Data Modeler to enhance and automate the maintenance of the 15,000 table definitions inside the company's giant database. Also, ERwin Data Modeler was used by the New York Power Authority and the Utah State Office of Education. 

The product was so in-demand over the years that even its competitor, Embarcadero Technologies, tried to acquire the software in 2014, but the transaction was given the thumbs down by the Department of Justice because of anti-competitive concerns. 



  1. 12

    #4ErWin

    ErWin
    ErWin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment.
    Software

    Windows

    Free

    Joseph Pearson
    Written on January 8, 2017
    "I was interested in upgrading my data management system, so I decided to look into ErWin. I like that you can receive a complimentary trial to explore the system before purchasing. I plan to dig a little deeper and see how user friendly it would be for my company."
  2. 10

    #5Embarcadero ER/Studio

    Embarcadero ER/Studio
    With ER/Studio Data Architect's extensive data modeling and metadata capabilities, you can document critical data elements, business data objects, and regulatory data elements and show their sources, interactions, and dependencies, in logical and physical data models.
    Software

    Windows

    Price upon request

    Devansh Chauhan
    Written on March 24, 2017
    "Your designing needs can be met through this site. The first thing is they are generous, giving away many free tools, but they advertise a variety of products for all of your solution based needs. Database Management, and development, along with IT management. They offer Demonstrations, Webcasts, and Live Demos. You will be designing the set up that is right for you in no time. "
  3. 8

    #6QuickDBD

    QuickDBD
    QuickDatabaseDiagrams.com is the fastest, slickest way to design a database - just type! And it's free.
    Websites

    Free- Varies by plan

    Ryan Tran
    Written on March 11, 2017
    "I have used QuickDBD and it is a great tool and makes things simple. It looks professional and there are no GUI tools to interrupt your work and I can share your diagram online. Also if needed I can export to SQL, PNG, and SVG for free."
  4. 6

    #7dbForge Studio for MySQL

    dbForge Studio for MySQL

    dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database administration, development, and management. The IDE allows to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. 

    Software

    Windows

    $79.95- Free trial available

    Dennis Walters
    Written on September 7, 2018
    "Looking a tool that uses MySQL and I tried this one. The trial version has a database backup which is very convenient to me. "
  5. 6

    #8Oracle SQL Developer Data Modeler

    Oracle SQL Developer Data Modeler
    Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.
    Software

    Windows

    Free

    Joyce Wang
    Written on September 8, 2017
    "This link provides me to a tool of exactly what I need, an on the left hand side of the link, there are more links to tool that could also be useful to me. This link is right to the download page, which is convenient and makes it easy for me to download this tool. Something like this is exactly what I am looking for."
  6. 5

    #9DBDesigner 4

    DBDesigner 4
    DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment.
    Software

    Windows

    Free

    Eugene Olson
    Written on January 31, 2017
    "I recommend using DBDesigner 4 as an option for schema design tools as it is based on open source code which means that the code is being continually updated by a community of users. With the changes in software today, I would rather use open source code rather than proprietary code that isn't as updated as frequently."
  7. 1

    #10dbForge Studio for Oracle

    dbForge Studio for Oracle

    dbForge Studio for Oracle is a tool developed by Devart that allows you to develop and manage databases. You can manipulate table data, track schema changes, report data, etc. 

    Software

    Web

    Free

    Jordan Sanders
    Written on February 22, 2019
    "One of my favorite tools, data modeling and design features are on the top level"
  8. 1

    #11DbSchema

    DbSchema
    Integrated database tool featuring diagrams, data explorer from multiple tables, schema compare and synchronization, query builder, query editor, HTML5 documentation, random data generator, forms and reports and more.
    Software

    Windows, Mac

    $63- Free trial available

    Hemant Kadam
    Written on September 8, 2017
    "This is probably exactly what they are looking for. It is the exact title of the program that the user is asking about."
  9. 0

    #12Moon Modeler

    Moon Modeler

    Moon Modeler is a design software tool for MongoDB. With the tool, users can manage MongoDB or Mongoose structures in the Projects and visually design them. Moon Modeller has a 14-day free trial available upon installation.

    Software

    Windows

    $99- Free trial available

    Vaclav Frolik
    Written on May 16, 2019
    "It is a DB schema design tool for MongoDB that supports visualization of hierarchical structures. You can draw designs similar to entity-relationship diagrams and generate validation code."
  10. 0

    #13dModelAid

    dModelAid

    dModelAid is an online modeling tool for documenting a complex database design in a simple, interactive diagram with a focus on ease of use and improved productivity.

    Online Tools

    Free- Varies by plan

    There are no comments yet!

    Share your opinion

Summary

Best What are the best DB schema design tools
RankSolutionsTypeVotesPrice
1VertabeloWebsites 18 Free
2SQL Power ArchitectSoftware 13 Free
3DBdesignerWebsites 13 Free
4ErWinSoftware 12 Free
5Embarcadero ER/StudioSoftware 10 Paid
6QuickDBDWebsites 8 Free
7dbForge Studio for MySQLSoftware 6 Paid
8Oracle SQL Developer Data ModelerSoftware 6 Free
9DBDesigner 4Software 5 Free
10dbForge Studio for OracleSoftware 1 Free
Close

This action requires you to be logged in

Quickly sign in with your social media account:

What interests you most? (Select at least 3)

This will help us to keep things fresh and relevant!

Close

Now that you’ve found a solution...

Why not join our community of sharp minds and pro-active posters?

Be part of a rewarding interactive knowledge exchange!
Close

Join These Inquisitive Minds

Engage, learn and share with a friendly community versed in a massive range of trending topics.