Skip to content
lexp-hubPublic

Repository files navigation

Relay Logo

Relational SQL schema designer & Entity-Relationship diagram studio

Live Demo Node.js Standalone Dialects Export Formats License

Open Web Studio →


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.


Quick Start

# 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 start

Live studio: https://lexp-hub.github.io/Relay/


License

MIT

Releases

Packages

Contributors

Languages