Entity Relationship Diagraming with ERDLab
Written by Nikos Vaggalis   
Monday, 06 March 2023

ERDLab is a free and intuitive SQL Visualization Tool which helps in capturing your database design thoughts. Let's look into it.

To be exact, ERDLab falls into the SQL schema visualization tools category. It allows you not only to draw your database design visually but also in code. And it's not just drawing per se; you can interact with your schema and explore its relationships end to end and also collaborate on it in a team.

Reverse engineering wise, you can import your DDL and let ERDLab create the schema for you or the other way around, lets you export your DDL from your schema in order to create your database. It supports many SQL dialects such as Postgres, Mysql, Oracle and SQLite, with that list of supported dbms's
expanding looking to even do Amazon Redshift .

We've covered Team Collaboration, Reverse and Forward Engineering but there's more:

  • Multiple Tabs
  • Image/PDF Export
  • Documentation
  • DB Conversion
  • Templates
  • Version Controls
  • One Click Sharing
  • Notes
  • Comments
  • Advanced View Modes
  • Zoom in/out
  • Mini-Map
  • Table & Line Colors
  • Schema Search
  • Autolayout
  • Object Color Coding

Privacy wise, your data stays in your browser for the session duration but also gets encrypted and saved to the server. The makers are open to changing this but based on their research and current feedback, users value sharing features too much to give up on this.

Business model wise, how are the makers looking to monetize the experience? The answer was :

We started this without any intention to monetize but we have been working on real-time collaboration and we want to see if there is enough demand from teams and enterprises to cover our costs in the long run. For individuals, we will keep it free.

Free users will always have access to current sharing features.

1) Live link open for everyone
2) Invite team members with read and read+write permissions
3) Embedding (coming soon).

Still a side project and may always stay that way if not enough demand from enterprise teams,

As a fresh project it is constantly evolving and asking for feedback from the community to incorporate changes and additions in later versions. For instance, they've accepted my request to add Optionality to the FKs.

There's an open access playground where you can start drawing your schema without having to create an account, but in order to activate the collaboration and sharing functionalities you have to create an account, free of course too.

Surely a valuable addition to my SQL toolset.


More Information


Designer playground


Related Articles

SQL Snippets - Crowdsourcing SQL Queries

BlocklySQL - Visual SQL Programming



To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.


Learn About RISC-V From Linux Foundation on edX

The Linux Foundation has a new free course on the edX platform for those who would like to learn about, and experiment with, RISC-V. A verified track, to earn a certificate of completion, is also [ ... ]

Access LLMs From Java code With Semantic Kernel

You can now do this thanks to Microsoft's Semantic Kernel SDK which integrates Large Language Models (LLMs)
with conventional programming languages like C# and Python. The Java binding has recently bee [ ... ]

More News

Summer SALE Kindle 9.99 Paperback $10 off!!




or email your comment to: comments@i-programmer.info