ERDly
Lightweight visual ERD builder with AI assistant to draft schemas and export SQL.
Project Overview
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
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.
Related Projects
A sleek and powerful Postman-lite API request builder with modern UI and enhanced request/response workflows.
A modern web application that converts CSV and Excel files into ready-to-use SQL INSERT statements with customizable options
Enterprise-grade academy platform integrating ASP.NET Core, React + Redux frontend, Tailwind CSS, WordPress CMS, Laravel admin, and Moodle for student LMS.
