Introduce
dbdiagram.io is a free, simple tool to draw ER diagrams by just writing code in a file.
And .dbml is the format of that file.
Why i use dbml?
- Good-looking DB tables design.
- Visual relationship.
- Code to draw instead of drag and drop.
- Can export to SQL.
Prepare
npm install -g @dbml/cli
# or
pnpm install -g @dbml/cli
Convert a DBML file to SQL
Using dbml2sql command:
dbml2sql schema.dbml -o schema.sql
cat schema.sql
# output is not contain error
Convert a SQL file to DBML
Using sql2dbml command:
sql2dbml schema.sql --mysql -o schema.dbml
# or
sql2dbml schema.sql --postgres -o schema.dbml
cat schema.dbml
# output is not contain error
View the result
Use dbdiagram.io or vscode - extention - dbml.