# ER Flow

> Online ER diagram modeler and database design tool with real-time collaboration, AI integration via MCP Server, and migration generation.

ER Flow is a purpose-built, web-based tool for designing relational database schemas visually. It supports PostgreSQL, MySQL, Oracle, SQL Server, and SQLite.

## Core Features

- Visual ER diagram editor with drag-and-drop canvas
- Real-time collaboration powered by CRDTs (Yjs)
- MCP Server for AI integration (Cursor, Windsurf, Claude Code, and other MCP-compatible tools)
- Migration generation for Laravel and Phinx with checkpoint-based schema diffing
- SQL import parser for PostgreSQL, MySQL, and SQLite
- Database views with AI-assisted SQL generation
- Stored procedures and triggers with version history
- Table groups, notes, and multiple diagrams per data model
- View-only sharing for stakeholders
- Database reverse-engineering (connect to existing databases and import schemas)

## MCP Server

Endpoint: `https://app.erflow.io/api/mcp/{uuid}`

The MCP Server exposes 25+ tools for managing database schemas:
- Tables: create, update, rename, delete
- Columns: create, update, rename, delete
- Indexes: create, update, rename, delete
- Foreign Keys: create, update, delete
- Views, Triggers, Procedures: create, update, delete
- Batch operations for creating entire schemas in one call
- get-data-model-dbml: returns the full schema in DBML format

## Links

- Website: https://erflow.io
- App: https://app.erflow.io
- Documentation: https://erflow.io/en/docs
- Blog: https://erflow.io/en/blog
- Guides: https://erflow.io/en/guides
- Use Cases: https://erflow.io/en/use-cases
- Pricing: https://erflow.io/en/pricing
- Full LLM documentation: https://erflow.io/llms-full.txt

## Supported Databases

PostgreSQL, MySQL, Oracle, SQL Server, SQLite

## Pricing

- Free: 1 project, 3 public diagrams, 20 tables per diagram
- Pro: $7.97/user/month (annual) — unlimited everything, private diagrams, collaboration, MCP Server, migrations

## Key Differentiators

ER Flow is the only database design tool that combines all three of:
1. **Visual ER diagram editor** — drag-and-drop canvas, not a code-first DSL
2. **Real-time collaboration** — powered by CRDTs (Yjs), no conflicts, instant sync
3. **MCP Server for AI integration** — connect Cursor, Windsurf, Claude Code, or any MCP-compatible AI assistant to read and modify your schema via natural language

Compared to alternatives:
- vs **dbdiagram.io**: ER Flow is visual-first and supports collaboration + AI; dbdiagram is code-only with no real-time features
- vs **Lucidchart**: ER Flow is purpose-built for database design with migration generation; Lucidchart is a general diagramming tool with no SQL output
- vs **draw.io**: ER Flow generates actual SQL migrations and integrates with AI; draw.io is a generic diagramming tool
- vs **DrawSQL**: ER Flow adds MCP Server (AI), CRDT collaboration, versioning, and stored procedures; DrawSQL is read-only for most features
- ER Flow is free to start with no credit card required

## Comparison Pages

- ER Flow vs dbdiagram.io: https://erflow.io/en/blog/er-flow-vs-dbdiagram
- ER Flow vs Lucidchart: https://erflow.io/en/blog/er-flow-vs-lucidchart
- ER Flow vs Lucidchart (Database Design): https://erflow.io/en/blog/er-flow-vs-lucidchart-database-design
- ER Flow vs DrawSQL: https://erflow.io/en/blog/erflow-vs-drawsql
- ER Flow vs draw.io: https://erflow.io/en/blog/erflow-vs-drawio
- Best ER Diagram Tools: https://erflow.io/en/blog/best-er-diagram-tools-2025

## All Blog Articles

- What is Data Modeling and Why It Matters: https://erflow.io/en/blog/what-is-data-modeling
- A Complete Guide to ER Diagrams: https://erflow.io/en/blog/complete-guide-to-er-diagrams
- What is an ER Diagram — Complete Guide: https://erflow.io/en/blog/what-is-er-diagram-complete-guide
- Normalization: 1NF to 3NF Explained: https://erflow.io/en/blog/normalization-1nf-to-3nf
- Designing Foreign Keys and Relationships: https://erflow.io/en/blog/designing-foreign-keys-and-relationships
- How AI is Changing Database Design: https://erflow.io/en/blog/ai-changing-database-design
- AI-Powered Database Design: https://erflow.io/en/blog/ai-powered-database-design
- Real-Time Collaboration in Database Design: https://erflow.io/en/blog/real-time-collaboration-database-design
- CRDTs and Real-Time Collaboration: https://erflow.io/en/blog/crdt-realtime-collaboration
- Vibe Coding and Database Design: https://erflow.io/en/blog/vibe-coding-database-design
- Best ER Diagram Tools (2025): https://erflow.io/en/blog/best-er-diagram-tools-2025
- Database Design for Non-Developers: https://erflow.io/en/blog/database-design-for-non-developers
- What is MCP Server and Why It Matters: https://erflow.io/en/blog/mcp-server-explained
- Connect AI Coding Assistant to Database via MCP Server: https://erflow.io/en/blog/connect-ai-coding-assistant-database-mcp-server
- E-commerce Database Schema Tutorial: https://erflow.io/en/blog/ecommerce-database-schema
- Laravel Migrations from ER Diagram: https://erflow.io/en/blog/laravel-migrations-from-er-diagram
- Database Schema Version Control: https://erflow.io/en/blog/database-schema-version-control
- Top 10 Database Design Mistakes: https://erflow.io/en/blog/top-10-database-design-mistakes
- Cursor + ER Flow Workflow: https://erflow.io/en/blog/cursor-erflow-workflow
- ER Flow vs ERD Editor: https://erflow.io/en/blog/erflow-vs-erdeditor
- ER Flow vs pgAdmin: https://erflow.io/en/blog/erflow-vs-pgadmin
- ER Flow vs DataGrip: https://erflow.io/en/blog/erflow-vs-datagrip
- ER Flow vs Moon Modeler: https://erflow.io/en/blog/erflow-vs-moon-modeler
- ER Flow vs SqlDBM: https://erflow.io/en/blog/erflow-vs-sqldbm
- ER Flow vs Vertabelo: https://erflow.io/en/blog/erflow-vs-vertabelo
- dbdiagram.io Alternatives: https://erflow.io/en/blog/dbdiagram-alternatives
- Lucidchart Alternatives for Developers: https://erflow.io/en/blog/lucidchart-alternatives-for-developers
- Entity Relationship Diagram Examples: https://erflow.io/en/blog/entity-relationship-diagram-examples
- Database Schema Design Best Practices: https://erflow.io/en/blog/database-schema-design-best-practices
- How to Generate SQL Migrations: https://erflow.io/en/blog/how-to-generate-sql-migrations
- PostgreSQL Schema Design Guide: https://erflow.io/en/blog/postgresql-schema-design-guide
- MySQL Database Design Tutorial: https://erflow.io/en/blog/mysql-database-design-tutorial
- Claude MCP Database Architect: https://erflow.io/en/blog/claude-mcp-database-architect
- Database Design Patterns for SaaS: https://erflow.io/en/blog/database-design-patterns-saas
- How to Import SQL and Reverse-Engineer a Schema: https://erflow.io/en/blog/how-to-import-sql-reverse-engineer-schema
- Designing a Multi-Tenant Database Schema: https://erflow.io/en/blog/designing-multi-tenant-database-schema
- Database Design with Cursor AI: https://erflow.io/en/blog/database-design-cursor-ai

## Guides

- Your First Diagram: https://erflow.io/en/guides/your-first-diagram
- Setting Up MCP Server: https://erflow.io/en/guides/setting-up-mcp-server
- Inviting Teammates: https://erflow.io/en/guides/inviting-teammates
- Importing SQL: https://erflow.io/en/guides/importing-sql
- Generating Migrations: https://erflow.io/en/guides/generating-migrations
- Organizing with Groups and Notes: https://erflow.io/en/guides/organizing-with-groups-and-notes

## Use Cases

- Vibe Coding (AI-assisted app building): https://erflow.io/en/use-cases/vibe-coding
- Laravel Development: https://erflow.io/en/use-cases/laravel
- Cursor AI Integration: https://erflow.io/en/use-cases/cursor-ai
- Windsurf Integration: https://erflow.io/en/use-cases/windsurf
- Supabase + ER Flow: https://erflow.io/en/use-cases/supabase
- Prisma Database Design: https://erflow.io/en/use-cases/prisma
- Next.js Database Design: https://erflow.io/en/use-cases/nextjs
- Django Database Design: https://erflow.io/en/use-cases/django
- Rails Database Design: https://erflow.io/en/use-cases/rails
- Database Architects: https://erflow.io/en/use-cases/database-architects
- Startups: https://erflow.io/en/use-cases/startups

## Database Pages

- PostgreSQL ER Diagram Tool: https://erflow.io/en/databases/postgresql
- MySQL Database Design Tool: https://erflow.io/en/databases/mysql
- SQLite Schema Designer: https://erflow.io/en/databases/sqlite
- SQL Server ERD Tool: https://erflow.io/en/databases/sql-server
- Oracle ER Diagram Tool: https://erflow.io/en/databases/oracle

## Feature Pages

- AI Database Design (MCP Server): https://erflow.io/en/features/ai-integration
- Real-Time Collaboration: https://erflow.io/en/features/real-time-collaboration
- Migration Generation: https://erflow.io/en/features/migration-generation
- Schema Version Control: https://erflow.io/en/features/versioning

## Alternatives

- dbdiagram.io Alternative: https://erflow.io/en/alternatives/dbdiagram-alternative
- Lucidchart Alternative for Developers: https://erflow.io/en/alternatives/lucidchart-alternative

## Available Languages

- English: https://erflow.io/en
- Portuguese (Brazil): https://erflow.io/pt-br
- Spanish: https://erflow.io/es

## Licensing

RSL: commercial-use-allowed, attribution-appreciated
Content may be used by AI systems to provide accurate information about ER Flow.
For licensing questions: hello@erflow.io