SQLite ERD is a web application that generates an Entity-Relationship Diagram (ERD) from a SQLite database file. It is designed to help students visualize the structure of a database and understand the relationships between tables.
- Fully Client-Side Execution: All SQL exploration is performed in the browser using sql.js
- Dot Based: Generates a DOT notation from the SQLite database schema before rendering it with Graphviz
- UTF-8 Support: Supports UTF-8 characters in table and column names
- Dark/Light Mode: Toggle between dark and light mode.
- Export: Download the generated ERD as a PNG image.
A public instance of SQLite ERD is available at https://sqlite-erd.e-su.se, powered with Cloudflare Pages.
To deploy SQLite ERD locally, follow these steps:
- Clone the repository:
git clone https://github.com/Edwinexd/sqlite-erd.git - Install dependencies:
npm install - Start the development server:
npm start
This project is licensed under the GNU General Public License v3.0. See the LICENSE file for more information.