Free ER Diagram Generator
Use our free ER diagram generator to create entity-relationship diagrams for database design. Tables and relationships.
- Entity and attribute definition
- Primary and foreign key notation
- Relationship cardinality (1:1, 1:N, M:N)
- Crow's foot and Chen notation styles
- Export as PNG, SVG, or SQL
- Import from existing SQL schemas
Frequently Asked Questions
What's the difference between Chen and crow's foot notation?
Chen notation uses diamonds for relationships and labels cardinality with numbers. Crow's foot notation shows cardinality visually with fork symbols. Both are supported.
Can I generate SQL from my ER diagram?
Yes! Export your diagram as CREATE TABLE statements with proper foreign key constraints. Support for MySQL, PostgreSQL, and SQLite syntax is included.
How do I show optional relationships?
Use the relationship options to mark participation as partial (optional) or total (required). Visual notation shows this with open or closed symbols.