Back to selected workAI Developer Tool 
ERD Architect AI
Instant Entity-Relationship Diagram generator parsing SQL, Prisma schemas, and natural language prompts.
https://ai-er-diagram-generator.vercel.appVerified Production Build
Next.js 15ReactFlowGoogle Gemini 2.5ELKjsTypeScriptTailwind CSS v4
“Turn SQL, ORM schemas, and plain prompts into interactive, auto-layouted ER diagrams instantly.”
System Architecture
ERD Architect AI transforms raw SQL DDL, Prisma schema definitions, DBML, or plain English prompts into interactive, auto-layouted Entity-Relationship Diagrams in seconds. Built on Next.js and ReactFlow with Google Gemini 2.5 intelligence, it removes the friction of manual database diagramming.
Client LayerNext.js 15 App Router, ReactFlow (@xyflow/react), Tailwind CSS v4, Lucide React
REST APINext.js Route Handlers streaming Gemini 2.5 structural schema extraction
Real-time ProtocolClient-side ELKjs layout calculation and interactive node position physics
Database & PersistenceStateless diagram compiler with exportable JSON, SVG, and PNG serialization
Authentication & SecurityEnvironment-isolated Gemini API key gateway with request sanitization
Production Hardening
ELK (Eclipse Layout Kernel) auto-layout algorithms for clean Top-Down and Left-Right DAG structures
Interactive relationship edge popups displaying foreign keys, cardinality, and constraints on hover
High-resolution vector SVG and lossless raster PNG diagram export pipelines
Multi-format schema input support (SQL CREATE TABLE, Prisma models, DBML, and conversational prompts)
Responsive collapsible drawer layout optimized for both desktop workflows and mobile review
Next Project
JobTrackr