Design your database
visually
Create ER diagrams, generate migrations, collaborate in real-time. The modern database design tool for developers.
Trusted by developers at
Everything you need to design databases
From visual diagramming to code generation, ER Flow has you covered.
Real-time Collaboration
Work together with your team on the same diagram. See cursors, changes, and comments in real-time.
Checkpoints & Versioning
Create checkpoints of your schema. Roll back anytime. Track changes to procedures and triggers.
Migration Generation
Generate SQL migrations automatically. Support for PostgreSQL, MySQL, and more.
MCP Server (AI Integration)
Connect to Cursor or other AI tools. Let AI create and update your schema as it writes code.
Triggers & Procedures
Create, edit, and version your database triggers and stored procedures visually.
Table Groups
Organize tables into logical groups. Color-code and collapse sections of your diagram.
Notes & Comments
Add notes to tables, columns, or anywhere on the canvas. Document your schema decisions.
SQL Import
Import existing schemas from SQL files. Paste CREATE TABLE statements and go.
View Mode & Sharing
Share diagrams with view-only access. Perfect for documentation and onboarding.
Let AI design your database
Connect ER Flow to your AI coding assistant via MCP Server. As you describe features in natural language, your schema updates automatically.
- Works with Cursor, Windsurf, and other MCP-compatible tools
- Automatically generates migrations as schema changes
- AI understands relationships and suggests foreign keys
- Real-time sync between your IDE and diagram
and author_id linking to users"
Simple, transparent pricing
Start free, upgrade when you need more power.
Free
For learning & experimentation
Pro
For teams & professionals
Frequently Asked Questions
What is ER Flow?
ER Flow is a free online ER diagram editor and database design tool. It lets you create entity-relationship diagrams visually, generate SQL migrations for Laravel and Phinx, collaborate in real-time with your team, and integrate with AI coding assistants like Cursor and Windsurf via MCP Server. It supports PostgreSQL, MySQL, Oracle, SQL Server, and SQLite.
Is ER Flow free?
Yes. ER Flow has a free plan that includes 1 project, 3 public diagrams, and 20 tables per diagram. The Pro plan costs $7.97/user/month (billed annually) and includes unlimited projects, private diagrams, real-time collaboration, MCP Server for AI integration, migration generation, and more.
What databases does ER Flow support?
ER Flow supports PostgreSQL, MySQL, Oracle, SQL Server, and SQLite. Each database engine has its own column types, index types, and constraint options. You can also import existing schemas via SQL files or by connecting directly to a database.
Does ER Flow work with AI coding assistants?
Yes. ER Flow provides an MCP Server (Model Context Protocol) that connects to AI coding assistants like Cursor, Windsurf, Claude Code, and other MCP-compatible tools. Your AI assistant can read, create, and modify your database schema directly through natural language commands, and changes appear in the visual diagram in real-time.
Can I generate migrations from my ER diagram?
Yes. ER Flow generates migration files for Laravel and Phinx frameworks. It uses a checkpoint-based diffing system that detects table creates, drops, renames, column additions, modifications, removals, index changes, and foreign key changes. It generates both up() and down() methods.
How does real-time collaboration work?
ER Flow uses CRDTs (Conflict-free Replicated Data Types) powered by Yjs for real-time collaboration. Multiple team members can edit the same diagram simultaneously, see each other's cursors, and all changes sync instantly via WebSocket. You can invite teammates with Editor or Viewer permissions.