ERD Diagram Maker
Entity names, fields and relationships stay in this browser. In the funnel, this tab keeps the project in session storage for up to 30 minutes. It never enters Livewire or the URL.
This private schema is unavailable or has expired. Return to the first step and create it again.
Define entities and fields
Start from a template or build a compact model. Entity and field names use letters, numbers and underscores so the generated Mermaid stays portable.
Map a small data model without sending the project anywhere. This browser-local ERD editor lets you add up to 12 entities, with up to 20 named and typed fields in each one. Mark fields as primary or foreign keys, connect entities with a relationship and cardinality, then generate a Mermaid erDiagram and a rendered SVG or PNG. Start from the store, blog or empty template, copy the Mermaid output, or export and import a local JSON project. It does not create DBML or SQL, drag or reorder diagram nodes, synchronize projects, upload files or use a server. In funnel mode, the project stays only in private sessionStorage for the current tab for up to 30 minutes and never enters a URL or Livewire request.
How to build an ER diagram
-
1
Choose a starting point
Open the store template, blog template or an empty project. Templates are editable starting points, not imported database schemas.
-
2
Define entities and fields
Add up to 12 entities. Give each entity up to 20 fields, each with a name, type and optional PK or FK role.
-
3
Connect the model
Add a relationship between two entities and choose its cardinality. The editor generates the corresponding Mermaid erDiagram relationship.
-
4
Generate and keep your work
Copy the Mermaid text, download SVG or PNG, or export a JSON project for local import later. Nothing is synchronized or uploaded.
What this ERD editor generates
The editor uses structured inputs rather than a raw text language. Its generated Mermaid describes the entity names, field types, PK and FK markers, and the relationships you selected. For example, a small order model can produce:
erDiagram
CUSTOMER ||--o{ ORDER : places
ORDER ||--|{ ORDER_ITEM : contains
CUSTOMER {
int customer_id PK
string email
}
ORDER {
int order_id PK
int customer_id FK
}
ORDER_ITEM {
int order_id FK
int quantity
}
Roles and cardinalities
| Item | What you set in the editor | Meaning in the diagram |
|---|---|---|
| PK | Mark a field as a primary key | The field identifies a record in that entity. |
| FK | Mark a field as a foreign key | The field references a record represented by another entity. |
| One to many | For example, `CUSTOMER | |
| One to one | For example, `USER | |
| Many to many | Model it with a linking entity, such as ORDER_ITEM |
The editor can show the two relationships to the linking entity. |
Mermaid uses crow’s-foot markers for these cardinalities. The tool generates that syntax from the relationship choices, so you can copy the Mermaid text without hand-writing it.
Limits, exports and privacy
- An ERD can contain up to 12 entities and up to 20 fields in each entity.
- SVG is useful for documentation that must remain sharp when scaled. PNG is a bitmap export for places that need an image file.
- Mermaid text can be copied for a Mermaid-compatible document or renderer. JSON export and import are local project files.
- The editor does not generate DBML or SQL. It also has no server project store, uploads, synchronization, node dragging or manual node reordering.
- In funnel mode, project data is kept only in private tab sessionStorage for up to 30 minutes. It is not placed in the URL or sent through Livewire.
Frequently Asked Questions
No. This editor starts from the store template, blog template or an empty project. It does not parse database schemas, DBML or SQL.
Yes. The tool generates Mermaid erDiagram text from the structured entities, fields, roles, relationships and cardinalities. You can copy that text, and you can also download the rendered diagram as SVG or PNG.
No. It is a diagram editor, not a schema compiler. It does not generate SQL, migration files or DBML.
No. The tool does not offer node dragging, manual node reordering, online synchronization or server-side project storage. Export JSON locally if you want a project file to import later.
No. The editor runs locally in the browser. In funnel mode, the project is held only in private sessionStorage for the current tab for up to 30 minutes. It is never placed in the URL or sent through Livewire.
You can use up to 12 entities, with up to 20 fields in each entity. Each field can have a name, type and PK or FK role, and relationships include a chosen cardinality.
Related Tools
HEX Color Picker
Pick or enter a HEX colour and get RGB, HSL, approximate CMYK, relative luminance and contrast ratios against white and black.
Color Palette Generator
Generate monochromatic, analogous, complementary, triadic or tetradic color palettes from a base HEX color and export copy-ready CSS variables.
FPS Counter
Measure browser FPS with requestAnimationFrame, smoothing, min/max frame rate, warnings and an optional graph. Runs locally with no upload or API.
Phone Validator
Validate phone numbers by country, detect the region and type, and normalize valid numbers to E.164, international, national and RFC 3966 formats.
BBCode to HTML Converter
Convert BBCode (bulletin-board markup) to clean HTML. Handles formatting tags, lists, quotes, code, images, links and tables.
Random Color Palette Generator
Generate random color palettes from 2 to 15 swatches, choose a vibrant, pastel, muted or dark style, then copy HEX codes or CSS variables.