BRMW

BRMW is a web application for database modeling, built for teaching and learning. It runs entirely in the browser: there is no server, no account, and your models stay on your machine.

It follows the classic modeling workflow taught in database courses. You start with a conceptual model, convert it into a logical model, and generate the SQL to create the database. A NoSQL modeling module lets you explore the document-oriented alternative from the same conceptual model.

A hosted version, with accounts, cloud storage, sharing and other features, is available at app.brmodeloweb.com. Learn more at brmodeloweb.com.

Features

• Conceptual modeling with the entity-relationship notation (Peter Chen, with the Heuser conventions common in Brazilian courses): entities, relationships, attributes, keys, cardinalities, weak entities, ISA hierarchies and associative entities
• Logical modeling with tables, columns, primary and foreign keys, and views with query expressions
• NoSQL modeling with collections, embedded documents and references
• Automatic conversion from conceptual to logical and from conceptual to NoSQL, with interactive choices for the ambiguous cases (ISA strategies, attribute placement, references vs embedding)
• SQL generation for the logical model
• Diagram editing with multi-selection, copy and paste, undo and redo, snaplines, grid, page breaks and printing
• Local persistence: models are saved in the browser's localStorage
• Interface in English and Brazilian Portuguese

Technologies

• React 19 with TypeScript and styled-components
• JointJS (@joint/core, open source) for the diagram canvas, with custom editor widgets in app/editor/
• React Router 7 for routing
• react-i18next for internationalization
• Radix UI for accessible dialogs
• Webpack 5, Babel and Sass for the build
• Jest and Testing Library for tests

Getting started

You will need:

• Node.js 24.x (we recommend installing it via nvm or n)
• pnpm 10.x
• An editor with EditorConfig support

Then:

pnpm install
pnpm run:fe

Open http://localhost:9000. Models are stored in your browser, so clearing site data erases them.

Other commands:

Command	What it does
pnpm build	Production build into app/dist
pnpm test	Runs the test suite with coverage
pnpm test:watch	Runs the tests in watch mode

Project structure

app/
  editor/        editor widgets (canvas, selection, toolbar, clipboard, undo/redo, snaplines, print)
  joint/         JointJS shape definitions (conceptual, logical, NoSQL, links, notes)
  react/         React application
    pages/       one folder per screen: workspace, conceptual, logic, nosql
    components/  shared components and modals
    services/    local persistence and hooks
    router/      routes
    public/      translation files
  sass/          global styles

Each page is split into a *PageWrapper.tsx, which wires routing and services, and a *Page.tsx, which is a presentational component. The conversion engines live next to their editors in pages/logic/conversor.js and pages/nosql/conversor.js.

Contributing

Contributions are welcome. Please read the code of conduct before opening an issue or a pull request.

Contributors ✨

Thanks goes to these wonderful people (emoji key):

Milton Bittencourt de Souza Neto 💻 ⚠️ 🐛 🚧	Idmar Ramos Junior (Id) 💻 🎨 📆 🚧	Felipe de Souza da Costa 💻 🚇 👀	Márcio Santos 💻 👀	Telmo "Trooper" 💻	Arthur Mota 💻 👀	joaomfiumari 💻 🚇
Walmyr ⚠️	Tárliton Basso de Godoy 💻 🚇	John Fercher 💵	Henrique Ferraz 💵	Paulo Ricardo Stradioti 💵	Salim Nabbout 💵	Justin Ferraz 💵
walissonkuper 💵	David de Souza 💵	Jeverson misael da cruz filho 💵	João Marcelo de Oliveira Delfino 💻	Estéfano Tuyama Gerassi 💻	Felipecluiz 💻	Eduardo Castro 💵
claudiosanavria 💵	TBMFOCABR 💵	fabriciocore 💵	Julianna Lemos 💵	VIVIANECOELHO1 💵

This project follows the all-contributors specification. Contributions of any kind are welcome!

License

Copyright 2026 Milton Bittencourt

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the LICENSE file for the specific language governing permissions and limitations under the License.

This project continues the work started in brmodelo-app, also released under the Apache License 2.0.