ER Designer
ER Designer is a browser-based platform for creating entity-relationship diagrams, restructuring database schemas, and generating logical schemas.
What ER Designer is
ER Designer is a browser-based platform for creating 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 proposes guided solutions. From a restructured diagram, the service can generate tables, primary keys, foreign keys, and crow’s foot notation. Diagrams import or export as JSON and export as PDF or PNG. Teachers can create classes, attach exercises, monitor submissions, and review student projects read-only; students join with a code or invitation and submit work. Anonymous whiteboards are available, but saving projects requires sign-in. Email/password, Google, and GitHub login are supported. Student and Teacher plans cost nothing; Institute / Department pricing is on request. Teacher access requires administrator-reviewed profile activation.
Good
- Free Student and Teacher plans
- Guided schema restructuring wizard
- JSON, PDF, and PNG diagram formats
- Class and exercise management
- Google and GitHub sign-in
Watch out
- Saving requires signing in
- Teacher access needs administrator review
- Institute pricing is on request
- No SQL export
Who it suits
ER Designer suits teachers, students, independent users, and business database design teams. It is useful for diagramming, guided schema restructuring, and classroom assignments in a web browser.
Verdict
ER Designer combines ER diagram editing, schema restructuring guidance, logical-schema generation, and classroom workflows in a browser. Its free Student and Teacher plans support learning and design work, while sign-in and teacher activation requirements affect setup.
Plans and prices
From ER Designer's own pricing page, checked 10 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Student | Free | Access teacher's classes · Full editor · Exercise submission |
| Teacher | Free | Create and manage classes · Assign work with attachments · Monitor submissions and progress |
| Institute / Department | Priced on request | Multiple teachers · Centralized user management · Dedicated onboarding · Price on request |
The facts
Each one read from ER Designer's own pages, with the date it was checked.
What it does
- Anonymous use
- The site says users can open an anonymous whiteboard, but signing in is required to save projects on the server.checked 10 Oct 2026
- Diagram elements
- The editor supports entities, attributes, keys, composite and multivalued attributes, relationships and generalizations.checked 10 Oct 2026
- Diagram styles
- It offers Classic, Oval and Tabular diagram styles.checked 10 Oct 2026
- Guided restructuring
- A wizard highlights issues such as missing keys, multivalued attributes and ISA structures, then proposes step-by-step solutions.checked 10 Oct 2026
- Import and export
- Users can import and export diagrams as JSON and export diagrams as PDF or PNG.checked 10 Oct 2026
- Integrations and login
- Users can sign in with email and password or through Google or GitHub OAuth.checked 10 Oct 2026
- Intended users
- The site describes the tool for teachers, students, independent users and business database design teams.checked 10 Oct 2026
- Logical schema
- It can generate tables, primary keys, foreign keys and crow's foot notation from a restructured diagram.checked 10 Oct 2026
- Purpose
- ER Designer is a browser-based platform for creating ER diagrams, restructuring database schemas and generating logical schemas.checked 10 Oct 2026
- Role activation
- Teacher access requires a profile request in account settings that is reviewed by an administrator.checked 10 Oct 2026
- Student workflow
- Students can join classes with a code or invitation, access assigned work and submit exercises.checked 10 Oct 2026
- Support
- The help page invites bug reports and improvement suggestions through a feedback form.checked 10 Oct 2026
- Teaching tools
- Teachers can create classes, assign exercises with attachments, monitor submissions and review student projects read-only.checked 10 Oct 2026
The company
- Maker
- The site identifies Di Menna Riccardo as the software's creator.checked 10 Oct 2026
Alternatives to ER Designer
- 1
MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 2
Hackolade Studio
Free planWebAPILinuxmacOS7.8Free plan - 3
Schemity
Free planWebAPILinuxmacOS7.7Free plan - 4
Database Workbench
Free planLinuxmacOSWindows7.5€199 one-time - 5
DbSchema
Free planLinuxmacOSWindows7.0From $29.40 a month - 6
pgModeler
Free planLinuxmacOSWindows6.9From $59.90 a month