Design Your Database Visually

Schema Flow is a powerful visual database schema designer that runs entirely in your browser. Drag and drop tables, define columns, create relationships, and export production-ready code for your favorite ORM or raw SQL.

Visual Table Designer

Create database tables with an intuitive drag-and-drop interface:

• Add tables with a single click
• Define columns with types, constraints, and defaults
• Mark primary keys and foreign keys visually
• Rearrange freely on an infinite canvas
• Full undo/redo with keyboard shortcuts (⌘Z/⌘⇧Z)

Relationship Connections

Draw relationships between tables with visual connectors:

• One-to-One (1:1) relationships
• One-to-Many (1:N) relationships
• Many-to-Many (M:N) through junction tables
• Self-referential relationships supported
• ON DELETE/ON UPDATE actions configurable

Multi-Format Export

Generate production-ready code for your stack:

SQL Databases

• PostgreSQL — Full DDL with constraints, indexes, and enums
• MySQL — InnoDB engine, UTF8MB4 charset support
• SQLite — PRAGMA foreign_keys, CHECK constraints

ORMs

• Prisma — Complete schema.prisma with models and relations
• Drizzle — TypeScript pgTable definitions with full relation support
• TypeORM — Entity classes with all decorators

Images

• PNG — High-resolution diagram export
• SVG — Scalable vector for documentation

SQL Import

Already have a database? Import existing schemas:

• Paste CREATE TABLE statements
• Supports PostgreSQL, MySQL, and SQLite syntax
• Automatically creates visual relations from foreign keys
• Handles inline and ALTER TABLE constraints

Schema Templates

Kickstart your project with pre-built templates:

• 📝 Blog — Users, posts, categories, comments
• 🚀 SaaS — Organizations, members, projects, subscriptions
• 🛒 E-commerce — Products, orders, customers, addresses

100% Local & Private

No cloud, no accounts, no data collection:

• Runs entirely in your browser
• Your schemas never leave your machine
• No signup or login required
• Export and save locally anytime

Developer-Friendly

Built with the modern stack developers love:

• Next.js 14 with App Router
• React Flow for the visual canvas
• Zustand + Zundo for state with undo/redo
• TypeScript for type safety
• shadcn/ui + Tailwind CSS for styling
• Dark/Light Mode support

Save & Load Projects

Export your schema as JSON to save your work. Load it back anytime to continue where you left off. Share project files with your team.