<h2 id="heading-introduce">Introduce</h2>
<p><a target="_blank" href="https://dbdiagram.io/home">dbdiagram.io</a> is a free, simple tool to draw ER diagrams by just writing code in a file.</p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1666256321965/xi2-h9-2N.gif" alt="dbdiagram-demo.0791273.gif" /></p>
<p>And <code>.dbml</code> is the format of that file.</p>
<h3 id="heading-why-i-use-dbml">Why i use <code>dbml</code>?</h3>
<ul>
<li>Good-looking DB tables design.</li>
<li>Visual relationship.</li>
<li>Code to draw instead of drag and drop.</li>
<li>Can export to SQL.</li>
</ul>
<h2 id="heading-prepare">Prepare</h2>
<pre><code class="lang-bash">npm install -g @dbml/cli
<span class="hljs-comment"># or</span>
pnpm install -g @dbml/cli
</code></pre>
<h2 id="heading-convert-a-dbml-file-to-sql">Convert a DBML file to SQL</h2>
<p>Using <code>dbml2sql</code> command:</p>
<pre><code class="lang-bash">dbml2sql schema.dbml -o schema.sql
cat schema.sql
<span class="hljs-comment"># output is not contain error</span>
</code></pre>
<h2 id="heading-convert-a-sql-file-to-dbml">Convert a SQL file to DBML</h2>
<p>Using <code>sql2dbml</code> command:</p>
<pre><code class="lang-bash">sql2dbml schema.sql --mysql -o schema.dbml
<span class="hljs-comment"># or</span>
sql2dbml schema.sql --postgres -o schema.dbml

cat schema.dbml
<span class="hljs-comment"># output is not contain error</span>
</code></pre>
<h2 id="heading-view-the-result">View the result</h2>
<p>Use <a target="_blank" href="https://dbdiagram.io/">dbdiagram.io</a> or <a target="_blank" href="https://marketplace.visualstudio.com/items?itemName=matt-meyers.vscode-dbml">vscode - extention - dbml</a>.</p>
<h2 id="heading-reference">Reference</h2>
<ul>
<li><a target="_blank" href="https://www.dbml.org/cli/#convert-a-dbml-file-to-sql">DBML - CLI - documents</a></li>
</ul>


## Introduce

[dbdiagram.io](https://dbdiagram.io/home) is a free, simple tool to draw ER diagrams by just writing code in a file.

![dbdiagram-demo.0791273.gif](https://cdn.hashnode.com/res/hashnode/image/upload/v1666256321965/xi2-h9-2N.gif align="left")

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

```bash
npm install -g @dbml/cli
# or
pnpm install -g @dbml/cli
```

## Convert a DBML file to SQL

Using `dbml2sql` command:

```bash
dbml2sql schema.dbml -o schema.sql
cat schema.sql
# output is not contain error
```

## Convert a SQL file to DBML

Using `sql2dbml` command:

```bash
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](https://dbdiagram.io/) or [vscode - extention - dbml](https://marketplace.visualstudio.com/items?itemName=matt-meyers.vscode-dbml).

## Reference

- [DBML - CLI - documents](https://www.dbml.org/cli/#convert-a-dbml-file-to-sql)




Convert between SQL file and DBML formats file

loclv blog, IT, công nghệ, frontend, backend, techtalk, Lưu Vĩnh Lộc, Luu Vinh Loc

Convert between SQL file and DBML formats file

Introduce

Why i use dbml?

Prepare

Convert a DBML file to SQL

Convert a SQL file to DBML

View the result

Reference

Why i use `dbml`?