A Free Database Designer for Developers and Analysts

MySQL

2. In your terminal run the following command On Linux you might need to add sudo before it

$ mysqldump -h<host>-u<username>-P<port>-p--no-data<database_name>><output_path>

Example

$ mysqldump -hlocalhost-uroot-P3306-p--no-dataecommerce>C:\mysql_schema.sql

Copy the dumped SQL content and paste it into this modal

Enter to Rename, Shift+Enter to Preview

Uploading a schema to dbdiagram.io

sqlite3 app.db .schema > schema.sql

Then paste schema.sql into dbdiagram.io → Import → From SQL.

The deal with dbdiagram.io

dbdiagram.io works with DBML (text-based schema language) — it doesn't accept raw .db files. But you can still use it by extracting your schema first.

For SQLite (app.db), run this:

bash

sqlite3 app.db .schema

That dumps all your CREATE TABLE statements. You'd then either paste them directly (dbdiagram supports SQL import) or convert to DBML.

On dbdiagram.io → click Import → From SQL → paste the output. Done. ✅