A Database Diagram Designer Built for Developers and Analysts

Anthony Thong Do
Oct 7, 2018 · 4 min read

Starting as a feature developed by our interns to help our customers visualize their database schemas at holistics.io — Business Intelligence Platform, we found out the opportunity to release dbdiagram.io as a standalone tool to contribute to data community.

That’s how dbdiagram.io built, a quick and simple database designer which is optimized for data analysts and developers to help them design database diagrams by just using their keyboard.

How dbdiagram.io makes your life better 😌

As Data Analysts and Developers, we all know the truth that sometimes mouse just doesn’t work. Understanding that, while other tools focus on the experience that you need to x2-click to create a table, x2-click to create a field, x2-click to change the value, dbdiagram.io brings you an experience where typing is just enough. Let’s see how it works:

The UI/UX: Just simply open dbdiagram.io and start designing your diagram

  • The Toolbar — to manage your diagrams, import, export, login and share with others
  • Code Editor — where you add tables, fields and relationships, simple rule, you type the diagram appears ✨
  • Diagram — to zoom in/out, move your diagram

Create Tables and Fields: To create tables and fields, follow the syntax below and type into your code editor on the left

//Syntax
Table tablename {
field1 type PK
field2 type
...
}
//Example
Table
users {
id int PK
email varchar
gender varchar
relationship varchar
dob datetime
country int
}
Table countries {
code int PK
name varchar
continent_name varchar
}

Create Relationships: When you need your mouse, you have your mouse. For the relationships, it would be more intuitive to interact on the diagram, so we support creating relationships both by typing the code and by dragging from field to field

//3 Relationship Types
// < one-to-many
// > many-to-one
// - one-to-one
//Long-form syntax
Ref name-optional { table1.field1 < table2.field2 }
//Short-form syntax
Ref name-optional: table1.field < table2.field2
//Example
Ref users.country < countries.code
  • Visualize your database within seconds by importing from your existing PostgreSQL or MySQL scripts
  • Export to PDF/PNG/SQL Scripts or Share easily with others
  • Since we are using DSL (Domain-specific Language) we can easily add Import/Export for other databases later, please feel free to let us know! 👐
  • 🖱Double-clicking on any table label will navigate you to the definition of your table code
  • 💾 Ctrl/Cmd + S to save your project
  • 🤔 The code editor is too small, drag the edge to make it bigger

Sample Database Diagrams

With the mission to contribute more to the community, we also hope that the community also uses dbdiagram as a tool to share their project with others. Here are some sample database schemas that we have designed.

If you love it, please spread your love with the hashtag #dbdiagram.io! Feel free to add your feedback here!

HackerNoon.com

#BlackLivesMatter

HackerNoon.com

Elijah McClain, George Floyd, Eric Garner, Breonna Taylor, Ahmaud Arbery, Michael Brown, Oscar Grant, Atatiana Jefferson, Tamir Rice, Bettie Jones, Botham Jean

Anthony Thong Do

Written by

Entrepreneurship, Product, Data, Design | holistics.io, dbidagram.io | anthonytd.com | 200% on Products

HackerNoon.com

Elijah McClain, George Floyd, Eric Garner, Breonna Taylor, Ahmaud Arbery, Michael Brown, Oscar Grant, Atatiana Jefferson, Tamir Rice, Bettie Jones, Botham Jean

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store