bigER - VS Code Extension

Open-source ER Modeling Tool for Visual Studio Code supporting hybrid textual- and graphical editing, multiple notations, and SQL code generation.

Features

• 📝 Textual Language for the specification of ER models in the textual editor. Assistive validation and rich-text editing support, enabled with the Language Server Protocol, allows to quickly get familiar with the available language constructs.
• 📊 Diagram View that is fully synchronized with the textual model and automatically updates on changes. Also offers an interactive toolbar with graphical editing actions, layout mechanisms, and multi-notation support.
• 🖨️ Code Generation to generate SQL tables out of the specified ER models and integrate with existing databases.

Getting Started

Requirements

• VS Code 1.46.0 or above
• Java 11 or above

New ER Model

After installation, ER models can be created in .erd files. Use the New Sample ER Model command in the Command Palette or refer to the example below to get started with a basic model.

erdiagram Model

notation=default

entity A {
   id key
}
entity B {
   id key
}
relationship Rel {
   A -> B
}

Open the Diagram

The corresponding ER Diagram can be opened by using the button in the editor toolbar, the context menu when right-clicking the file, or by pressing Ctrl/⌘ + O.

Learn More

For more information on how to use the tool, see the bigER Wiki.

Also check out the GitHub repository and available examples.

If you like our work, please feel free to buy us a coffee ☕️

Other Tools

Check out our other modeling tools!