Relay is a minimalist, browser-first relational database modeling and Entity-Relationship (ER) diagramming studio. It compiles visual schema models into PostgreSQL, MySQL, and SQLite DDL, Mermaid diagrams, DBML, and technical documentation.
- Dual Notation: Toggle between conceptual Chen ER modeling (entities, relationship diamonds, attribute ovals, (min, max) cardinalities) and physical Crow's foot schemas with Manhattan orthogonal connectors.
- Advanced Hierarchies: Model ISA generalization/specialization with coverage and exclusivity flags, plus automatic primary key inheritance.
- N-Ary & Complex Attributes: Multi-entity relationships, composite attribute tree-branching, multivalued and derived attributes.
- Reverse Engineering: Import existing SQL DDL scripts or Mermaid ER code into editable visual entities.
- Code Generation: Real-time compilation to PostgreSQL, MySQL, SQLite, Mermaid, DBML, and Word (.docx) reports.
For detailed architecture, relational algebra specifications, and API documentation, see DOCUMENTATION.md.
# Clone the repository
git clone https://github.com/lexp-hub/Relay.git
cd Relay
# Install dependencies and build
npm install
npm run build
# Start the standalone local daemon
npm startLive studio: https://lexp-hub.github.io/Relay/