ERDly

About This Project

ERDly is a focused, developer-friendly visual ERD builder that accelerates schema design by combining a drag-and-drop canvas with an intelligent assistant. Built with React, TypeScript and React Flow, ERDly lets users create entities, define columns (primary keys, unique constraints, nullable flags), and model relationships (1:1, 1:N, N:M) with automatic generation of normalized junction tables for many-to-many patterns. The interface emphasizes rapid iteration: schema diffs are previewable, SQL exports are customizable for different RDBMS dialects, and import/export of JSON schema bundles enables collaboration. The standout capability is the AI-powered drafting assistant — it translates plain-language business requirements into a first-pass schema, suggests indexing strategies, and annotates columns with types and validation rules. The tool includes safety checks for common anti-patterns, previewable migration scripts, and an ergonomically designed UI so small teams can go from idea to deployable SQL faster. ERDly is optimized for local performance and can produce production-ready SQL that integrates with existing CI workflows.

Key Features & Highlights

Drag-and-drop schema canvas

Interactive canvas for visually composing entities, relationships and constraints with keyboard shortcuts and multi-select operations.

AI schema drafting

Generative assistant that converts natural-language requirements into a scaffolded schema with recommended types and indices.

Multi-dialect SQL export

Export production-ready SQL tuned for popular RDBMS dialects and preview migration scripts before applying.

Collaboration-ready bundles

Import/export JSON schema bundles and shareable links for team review and versioning.

Intelligent AI assistance

AI-assisted schema drafting that understands business requirements and generates optimal database designs.

Enterprise SQL generation

Production-ready SQL exports compatible with major database systems and migration tools.

Built-in validation

Visual editor with anti-pattern checks to prevent common database design mistakes.

Team collaboration tools

Quick import/export for collaboration with version control and shareable schema links.