ER Flow + Windsurf AI

Let Windsurf design your database schema while you stay in flow

Connect ER Flow to Windsurf via MCP Server and let the AI handle your entire database design. As Cascade reasons through your feature requirements, it reads your current schema, proposes new tables and relationships, and applies them directly to the visual canvas — all without breaking your coding flow.

Benefits

Windsurf's Cascade agent calls ER Flow's MCP tools autonomously, no prompting required per step
get-data-model-dbml gives Cascade full schema context before every change, preventing collisions
Batch operations let Cascade build entire domain schemas — users, billing, permissions — in one shot
Visual canvas updates in real-time so you can review AI changes at a glance without leaving Windsurf
All 25+ MCP tools available: tables, columns, indexes, foreign keys, views, triggers, procedures
Checkpoint and generate SQL migrations the moment Cascade finishes scaffolding

How It Works

1

Connect

Add your ER Flow MCP Server URL to Windsurf's MCP configuration. The setup takes under a minute.

2

Describe

Tell Cascade what you're building: "Scaffold the database for a SaaS invoicing app with organizations, plans, and subscriptions."

3

Watch

Cascade reads your existing schema with get-data-model-dbml, then applies tables and relationships in batch operations.

4

Review

Switch to ER Flow to inspect the visual diagram. Verify column types, nullable flags, and foreign key directions.

5

Ship

Save a checkpoint and generate your migration files. Run them against your database and continue coding.

Connect Windsurf to ER Flow

Free to get started. No credit card required.