Database design tool

Lucidchart is an intelligent diagramming application that makes creating database diagrams easy. Customize shapes, import data, and so much more.

By registering, you agree to our Terms of Service and you acknowledge that you have read and understand our Privacy Policy.

Lucidchart is your collaborative database diagram tool

Get started in minutes with intuitive, dynamic features.

Import your structure

Import your database structure directly from your database management system into Lucidchart to better visualize your database as an entity relationship diagram (ERD). Our database designer tool supports DBMS platforms such as MySQL, Oracle, PostgreSQL, and Microsoft SQL Server.

Import your Salesforce schema

Our intuitive database diagram tool offers a Salesforce schema import feature to help Salesforce admins quickly visualize and make improvements to their Salesforce instance.

Lucid AI for database design

Create an AI database diagram by entering a prompt into Lucid AI. This will automatically generate a diagram that you can edit, collaborate on, and share with others.

Diagram with Lucid AI

Work from anywhere

With cloud-based diagramming, it’s easy to start a database design online from anywhere, no matter the device, browser, or operating system.

Export to your DBMS

With a few clicks, you can export your revised database diagram to SQL to easily transition from your Lucidchart canvas to your DBMS.

Third-party reviews

Lucidchart is trusted by millions of users and has thousands of five-star reviews on third-party apps like Capterra, G2, and TrustRadius.

Easy and customizable

Easily customize objects and relationships within your diagram, then collaborate freely with your team to confirm your proposed changes in Salesforce.

Lucidchart feature highlights

Streamline work by enabling multiple collaborators to create and edit the same diagram at once.

Database diagram templates

Get started building out your own database diagram online with these templates from our gallery.

Logical data model example template

Go to Logical data model example template template

NoSQL database design example template

Go to NoSQL database design example template template

Data flow diagram level 0

Go to Data flow diagram level 0 template

Getting started in Lucidchart

Follow along with this video tutorial and learn how to make any type of diagram in Lucidchart.

Make a diagram

Why teams choose Lucidchart

As an intelligent diagramming application, Lucidchart provides simple yet powerful capabilities for visualizing information.

Collaboration. Bring teams together side by side on a shared canvas from anywhere in the world.

Alignment. Build transparency and shared understanding of how a team or company works.

Large-scale change. Increase visibility, standardization, and knowledge sharing across your entire org.

End-to-end workflows. Upgrade to the Lucid Suite for a complete, connected visual collaboration solution.

What is a database diagram?

A database diagram shows the logical structure of a database, including the relationships and constraints that determine how data can be stored and accessed. Individual database models are designed based on the rules and concepts of whichever broader data model the designers adopt. Most data models can be represented by an accompanying database diagram.

How to use our database schema design tool

Select the ERD shape library and import

Use the ERD shape library to create your database structure. Start from scratch or streamline the process by importing your schema from Salesforce or your DMBS of choice.

Determine the entities from your database

List out every step in your process from start to finish, arranging them in sequential order. Be sure to include inputs, outputs, individual roles needed, time durations, etc.

Identify relationships between entities and add necessary attributes

Draw outlines and cardinalities between entities to indicate their relationships, then add necessary attributes associated with your entities.

Arrange, format, and collaborate

Once you've mapped your database, share it with others to get feedback on proposed changes and to ensure it's correct. Rearrange and format shapes and lines as you see fit.

Export your database design back to your DBMS

Export your database back to your DBMS using our export feature. Publish your diagram for others to reference using popular apps such as Confluence, Jira, Google Workspace, Microsoft Office, and more.

Additional Lucidchart resources

Lucid Training Labs

Learn visual collaboration skills in free, self-serve courses and live training workshops.

Explore courses

Lucid Community

Connect with other users to share tips and insights. Provide feedback to Lucid’s product team.

Join now

Help center

Find detailed articles with step-by-step instructions for using specific Lucid features.

Search resources

Lucidchart tutorials

Go to the Lucidchart tutorials playlist on YouTube for video training on various topics.

Explore playlist

Collaborate with AI

Get an overview of Lucid’s AI functionality and find additional resources.

See what’s possible

Lucid blog

Explore tips for optimizing collaboration, aligning teams, and driving initiatives in Lucidspark.

Read now

Lucidchart pricing

Create a free account and compare options for paid Individual, Team, or Enterprise plans.

Compare plans

Frequently asked questions about our database designer tool

Can I import my schema from Salesforce so I can help out the architecture of my Salesforce instances?

Yes! Use the ERD shape library to build your database on your canvas or use the Salesforce import feature to import your schema and save time from manually entering your info.

What’s the best way to start mapping my existing database structure in Lucidchart without having to start from scratch?

Use the ERD import feature from the ERD shape library. If you're not importing from Salesforce, use the regular import feature to select the DBMS you want to import from.

What database management systems (DBMS) can I import my database from?

Lucidchart lets you import your schema from several database management systems including MySQL, Oracle, PostgreSQL, and Microsoft SQL Server.

I redesigned my database design in an ER diagram in Lucidchart. How can I export it back into my DBMS?

Use the export feature in the ERD shape library, select the DBMS you are using, and copy and paste your newly generated commands into your DBMS of choice.

How do I determine the kind of database model I should diagram in Lucidchart?

It depends on the rules and concepts you want to showcase. Use our guide detailing commonly used database models and see which one best suits your needs.

Database models

Everything you need to make a diagram

In addition to our database design tool, Lucidchart offers support and training resources to help you branch out to any type of diagram.

View training labs