ER diagram maker
Design a database: define tables and typed columns, mark primary and foreign keys, link tables with crow’s-foot relationships, and drag the boxes to lay it out. Export the diagram as SVG or PNG, or generate ready-to-run CREATE TABLE SQL. Entirely in your browser.
Open ER diagram maker →What is the ER diagram maker?
A free, private entity-relationship diagram tool for designing a database in your browser. You define tables with typed columns, mark primary and foreign keys, link tables with crow's-foot relationships and drag the boxes to lay them out. Export the diagram as SVG or PNG, or generate ready-to-run CREATE TABLE SQL — all entirely on your device.
How to use ER diagram maker
- Add your tables — Click Add table and name it, then add columns with their data types. The diagram on the canvas updates as you go.
- Mark keys — Use the PK, FK and NN tags on each column to flag primary keys, foreign keys and not-null constraints.
- Link tables — Add a relationship and choose the two tables and the cardinality (1-1, 1-n or n-n) to draw crow's-foot connectors between them.
- Arrange the layout — Drag any table box on the canvas to reposition it until the diagram reads clearly.
- Export or generate SQL — Download the diagram as an SVG vector or PNG image, or open the SQL panel to copy or download ready-to-run CREATE TABLE statements.
Frequently asked questions
Is my schema sent to a server?
No. The whole diagram is built and rendered as inline SVG in your browser, so your table and column names stay on your device.
What relationship types can I draw?
You can connect tables as one-to-one (1-1), one-to-many (1-n) or many-to-many (n-n), shown with crow's-foot end markers.
What does the generated SQL look like?
It produces standard CREATE TABLE statements built from your tables, columns, data types and key flags, which you can copy or download as a .sql file.
Should I export SVG or PNG?
Choose SVG for a crisp vector that scales to any size and stays sharp in documents or print. Choose PNG for a fixed-resolution image that's easy to drop into slides or chats.
Can I start from an example?
Yes, the tool opens with a sample schema (users, orders, products, order_items) so you can see how tables, keys and relationships fit together before building your own.
Tips
- Mark primary keys first — they're underlined in the diagram, which makes each table easier to read.
- Drag tables apart so relationship lines don't cross; a clean layout exports better.
- Export SVG when the diagram will go into documentation that may be zoomed or printed.