DrawDB
Draw ER diagrams, generate SQL DDL for multiple databases, reverse engineer existing schemas, export diagrams, generate migrations, detect issues, collaborate in real-time.
A free, open-source visual database schema design tool that lets users draw ER diagrams and generate SQL DDL for multiple database dialects. It solves the problem of manually writing and maintaining database schemas by providing a visual canvas with export capabilities. The tool targets developers and data professionals across companies of all sizes, from freelancers to enterprises, who need to design, document, and migrate database structures. It is positioned as a free, self-hostable alternative to proprietary database design tools, with real-time collaboration and AI assistance available in a paid Pro tier.
Key features
- Draw ER diagrams
- Generate SQL DDL
- Real-time collaboration
- AI schema assistant
- Cloud storage
- Teams and access control
- Reverse engineer schema
- Export to JSON or image
- Generate migrations
- Issue detection
- Customizable workspace
- Keyboard shortcuts
- Pre-built templates
- Custom templates
- Robust editor
- Support for relational databases
- Custom types for object-relational
- Presentation mode
- Self-hosted via Docker
- No social media activity within the last 30 days
- Community
- API
- Docs
- Software developers
- Data analytics teams
- Engineering teams