A powerful cross-platform ERD tool for MySQL and PostgreSQL. Design schemas visually, generate migrations automatically, and keep your database in sync. Currently in beta - help shape the future by joining our community!
MySQL
PostgreSQL
From visual design to production migrations, dbflow has you covered.
Intuitive drag-and-drop interface for creating entities, fields, and relationships. Auto-resize, snap-to-guide alignment, and smart connection lines.
Compare your ERD design with your database and generate SQL migrations automatically. CREATE, ALTER, and DROP statements handled for you.
Connect to existing databases and auto-generate ERD diagrams. Perfect for documenting legacy systems or understanding new codebases.
Connect to remote databases securely through SSH tunnels. Credentials stored safely in your OS keyring.
Your workspace lives in a folder as JSON files. No cloud dependency, easy version control with git, and complete data ownership.
Unique, not null, default values, check constraints, composite unique, and indexes. Everything you need for production schemas.
Full temporal state management. Make changes confidently knowing you can always step back through your edit history.
Vim-style navigation (hjkl), hot keys for common operations, tab navigation with Cmd+1-9. Built for developers who prefer the keyboard.
Pre-define common field patterns and reuse them across entities. Speed up schema creation with your custom templates.
Every detail is designed to keep you in flow — from rapid schema creation to safe migration workflows.
Spin up entities and define fields in seconds. Go from idea to schema faster than ever.
Build one-to-many and many-to-many relationships with intuitive drag-and-drop — no manual wiring needed.
Freely reposition entities on the canvas while relationship lines adapt and reroute automatically.
Define check constraints that double as living documentation and reference them directly in default values.
Color-code entities and their relationships for instant visual grouping and clearer diagram readability.
Instantly distinguish between single-field unique constraints and composite unique together groups at a glance.
Every schema change requires explicit migration confirmation — protecting your database from accidental alterations.
Work across multiple tabs simultaneously with quick number-key navigation to stay focused and organized.
Support for all database schemas, not just public.
From design to deployment in three simple steps.
Create entities, define fields, and establish relationships using the visual editor. Or import from an existing database.
Compare your design with the database. dbflow generates the exact SQL needed to bring your database in sync.
Execute migrations directly or export SQL files. Your ERD stays in sync as your schema evolves.
Experience seamless performance and native feel across all major operating systems.
Download dbflow beta for free and help us build the best database design tool. Your feedback matters!