Sqlite
Learn how to import existing SQLite database schemas into StackRender using tools like sqlite3 and DB Browser for SQLite. Convert your SQL schema into a visual ERD diagram in seconds.
You can import an existing SQLite database schema into StackRender using the sqlite3 command-line tool.
Install sqlite3
Make sure sqlite3 is installed on your machine.
It is included with most operating systems or can be installed from the SQLite website.
Export the Database Schema
Run the following command in your terminal to export the database schema:
sqlite3 [database_path] .schema > [output_file.sql]Example:
sqlite3 example_db.db .schema > example_db.sqlThis command generates a .sql file containing the schema of your SQLite database.
Import into StackRender
Open the generated .sql file, copy its contents, and paste them into the Import SQL section in StackRender.
Then click Import to generate the diagram.
You can also export a SQLite database schema using DB Browser for SQLite and import it into StackRender.
Open DB Browser for SQLite
Launch DB Browser for SQLite.
Open Your Database
Click File → Open Database and select your .sqlite or .db database file.
Export the Database Schema
From the top menu, navigate to:
File → Export → Database to SQL file
In the dialog, choose Export schema only.
Import into StackRender
Click Save to generate the .sql file.
Open the generated .sql file, copy its contents, and paste them into the Import SQL section in StackRender.
Then click Import to generate the diagram.
MariaDB
Learn how to import existing MariaDB database schemas into StackRender using tools like mariadb-dump and HeidiSQL. Convert your SQL schema into a visual ERD diagram in seconds.
Export
Learn how to export production-ready SQL (DDL) from your database diagrams in StackRender. Generate clean SQL scripts for your preferred database dialect and use them to deploy or recreate your database schema anywhere.