Starting as a feature developed by our interns to help our customers visualize their database schemas at — Business Intelligence Platform, we found out the opportunity to release as a standalone tool to contribute to data community. holistics.io dbdiagram.io That’s how 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. dbdiagram.io Making Our Tiny Feature Free Led to 20,000 Users and 2,500 Leads Within 2 Months How was dbdiagram.io built! How dbdiagram.io makes your life better 😌 0. It’s free — Free to design, Free to share 1. Smooth experience — Designed with Data Analysts and Developers in mind 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, brings you an experience where typing is just enough. Let’s see how it works: dbdiagram.io Just simply open dbdiagram.io and start designing your diagram The UI/UX: — to manage your diagrams, import, export, login and share with others The Toolbar — where you add tables, fields and relationships, simple rule, you type the diagram appears ✨ Code Editor — to zoom in/out, move your diagram Diagram To create tables and fields, follow the syntax below and type into your code editor on the left Create Tables and Fields: //Syntax tablename {field1 type field2 type...} Table PK users {id int email varchargender varcharrelationship varchardob datetimecountry int} //Example Table PK countries {code int name varcharcontinent_name varchar} Table PK When you need your mouse, you have your mouse. For the relationships, it’s 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 Create Relationships: //3 Relationship Types//   <   one-to-many//   >   many-to-one//   -   one-to-one _//Long-form syntax_ name-optional { table1.field1 table2.field2 } Ref < name-optional: table1.field table2.field2 //Short-form syntax Ref < _//Example_ users.country countries.code Ref < 2. Import and Export on demand 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! 👐 3. Tips 🖱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. 👉 Sample E-commerce Schema 👉 Sample Airbnb Schema If you love it, please spread your love with the hashtag #dbdiagram.io! Feel free to add your feedback ! here

AirBnB

A Database Diagram Designer Built for Developers and Analysts

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

4 Case Study Questions for Interviewing Data Analyst at a Startup

An Overview of Kazakhstan's Fintech Ecosystem

With 12 Successful Exits and Only 5 Failures Out of 52 Startups, Here's My Guide to Smart Investing

Legacy Systems and CVEs: The Unseen Threat to Ghana's Digital Landscape

104 Stories To Learn About Go

4 Case Study Questions for Interviewing Data Analyst at a Startup

An Overview of Kazakhstan's Fintech Ecosystem

With 12 Successful Exits and Only 5 Failures Out of 52 Startups, Here's My Guide to Smart Investing

Legacy Systems and CVEs: The Unseen Threat to Ghana's Digital Landscape

104 Stories To Learn About Go

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps