Salesforce ER Diagram Studio Open source Tool

Salesforce ER Modeller Studio: Open Source Salesforce Data Modelling Tool

I have been working on a small side project called Salesforce ER Modeller Studio.

The idea is fairly simple: I wanted a better way to visually model Salesforce objects and relationships without having to rely entirely on Salesforce Schema Builder.

Schema Builder is useful, but I wanted something that gave me more flexibility around diagramming, exporting, modelling metadata, and working with the model as text.

So I started building my own tool.

What is Salesforce ER Modeller Studio?

Salesforce ER Modeller Studio is an open source tool for creating and exploring Salesforce entity relationship diagrams.

It allows you to visually model Salesforce objects and relationships and is designed specifically around the Salesforce data model.

The tool currently supports features such as:

  • Drag and drop Salesforce objects onto the canvas
  • Master Detail and Lookup relationships
  • Polymorphic relationships
  • Crow's foot relationship notation
  • Object and relationship visualisation
  • Importing Salesforce objects
  • PNG export
  • Mermaid export
  • Draw.io export
  • A simple DSL for defining models using text
  • DSL autocomplete and IntelliSense
  • Saving and reloading models
  • Data Dictionary information
  • Object and field metadata
  • Object and field usage information
  • Schema drift concepts
  • Heat map style views for used and unused objects

The project is still evolving, so some of these areas are continuing to be developed and improved.

Why did I build it?

One of the main reasons was simply that I wanted something I could use myself.

When working with a Salesforce org, understanding the data model can become difficult quite quickly. Large orgs can contain hundreds or even thousands of objects, relationships and fields.

A visual model can make those relationships much easier to understand.

I also wanted the model to exist as something more than a picture.

That is where the DSL came from.

Instead of only drawing objects on a canvas, I wanted to be able to describe a model using text and then generate the diagram from that definition.

It is not intended to be a complicated programming language. It is a deliberately simple modelling language for describing Salesforce data structures.

This is an open source project

The project is available on GitHub.

Github link -   https://github.com/vikascohen/Salesforce-ER-Modeller-Studio


Video demonstration





Comments

Post a Comment

Popular posts from this blog

How Easy It Is for a Salesforce Architect to Transition into ServiceNow

Image
 People often believe that learning a new platform means starting from zero. But if you are a Salesforce Architect, moving into ServiceNow is not starting over at all. It is one of the easiest transitions you can ever make in your professional journey. The reason is simple. Salesforce and ServiceNow are built on the same logic. They both exist to automate business processes, manage data efficiently, and create meaningful digital experiences. Once you understand this, the path between them becomes very smooth. You are not learning something completely different. You are learning the same philosophy in a new environment. The Platform Philosophy Salesforce and ServiceNow are both platform ecosystems. They are not single products. They both promote configuration before code and provide tools to automate and manage large-scale enterprise systems. Salesforce focuses on customer relationship management. ServiceNow focuses on enterprise service management. Both platforms rely on stru...
Read more

Must-Know Insights for Salesforce Developers: A Q&A Guide

Image
  Basic level Q: What is Apex? A: Apex is a proprietary programming language provided by Salesforce for developers to execute flow and transaction control statements on Salesforce servers in conjunction with API calls. Q: What are before and after triggers in Apex? A: Before triggers are used to update or validate record values before they are saved to the database. After triggers are used to access field values that are set by the system, such as a record’s ID, and to affect changes in other records. Q: What are governor limits? A: Governor limits are runtime limits enforced by Salesforce to ensure efficient processing and resource use. They include limits on the number of SOQL queries, DML statements, CPU time, heap size, and others. Q: How can you prevent SOQL injection? A: Prevent SOQL injection by using bind variables in your queries and the escapeSingleQuotes method to sanitize user inputs. Q: Explain the difference between a Map and a Set in Apex. A: A Map is a coll...
Read more