ER Designer
ermap.io
- Free plan
- Web
What ER Designer is
ER Designer is a browser-based platform for drawing entity-relationship diagrams, restructuring database schemas, and generating logical schemas. Its editor supports entities, attributes, keys, composite and multivalued attributes, relationships, and generalizations in Classic, Oval, or Tabular styles. A restructuring wizard identifies issues such as missing keys, multivalued attributes, and ISA structures, then presents step-by-step remedies. From the revised diagram, it can generate tables, primary keys, foreign keys, and crow’s foot notation. Diagrams can be imported or exported as JSON and exported as PDF or PNG. Teachers can create classes, attach exercises, monitor submissions, and review student projects in read-only mode. Students join by code or invitation and submit work. Anonymous whiteboards are available, but saving projects on the server requires sign-in. Student and Teacher plans cost nothing; an Institute / Department plan is priced on request. Teacher access requires administrator review.
Who it suits
ER Designer fits database design teams, independent users, teachers, and students working with ER diagrams and schema restructuring. Its class tools support assigned exercises and read-only project review.
Good to know, and what to watch
- Browser-based diagram editor
- Wizard guides schema restructuring
- Generates tables and key relationships
- JSON, PDF, and PNG export
- Free Student and Teacher plans
- Server saving requires sign-in
- Teacher access needs administrator review
- Institute pricing is on request
- No SQL export
Plans
Every plan and priceInstitute / Department
Student
Teacher
Free plan
The verdict
ER Designer combines diagram editing, guided restructuring, logical-schema generation, and classroom workflows in a web tool. Its free Student and Teacher plans suit learning and individual work, while larger institutes need a quoted plan.
What the maker publishes
- Anonymous use
- The site says users can open an anonymous whiteboard, but signing in is required to save projects on the server. source
- Diagram elements
- The editor supports entities, attributes, keys, composite and multivalued attributes, relationships and generalizations. source
- Diagram styles
- It offers Classic, Oval and Tabular diagram styles. source
- Guided restructuring
- A wizard highlights issues such as missing keys, multivalued attributes and ISA structures, then proposes step-by-step solutions. source
- Import and export
- Users can import and export diagrams as JSON and export diagrams as PDF or PNG. source
- Integrations and login
- Users can sign in with email and password or through Google or GitHub OAuth. source
- Intended users
- The site describes the tool for teachers, students, independent users and business database design teams. source
- Logical schema
- It can generate tables, primary keys, foreign keys and crow's foot notation from a restructured diagram. source
- Maker
- The site identifies Di Menna Riccardo as the software's creator. source
- Purpose
- ER Designer is a browser-based platform for creating ER diagrams, restructuring database schemas and generating logical schemas. source
- Role activation
- Teacher access requires a profile request in account settings that is reviewed by an administrator. source
- Student workflow
- Students can join classes with a code or invitation, access assigned work and submit exercises. source
- Support
- The help page invites bug reports and improvement suggestions through a feedback form. source
- Teaching tools
- Teachers can create classes, assign exercises with attachments, monitor submissions and review student projects read-only. source
Checked against the maker's pages on 10 Oct 2026.