royalbhati/sqltoerdiagram

SQL to ER Diagram is a browser-based tool that turns SQL schema code into a visual diagram showing how database tables relate to each other. You paste in CREATE TABLE statements, and the page draws an interactive chart with boxes for each table and lines connecting tables that reference each other through foreign keys. Nothing is sent to a server: the entire tool runs in your browser, so your database schema stays on your machine. The diagram is interactive in several ways. You can drag tables to arrange them, zoom in and out, and click a table to highlight only its relationships while fading out everything else. You can also double-click table names, column names, or data types to edit them directly on the diagram, and the tool updates the SQL text in the editor to match. Renaming a table also updates every reference to that table elsewhere in the schema. A layout button auto-arranges tables to avoid overlaps, with options for horizontal or vertical direction and different spacing presets. You can save a project as a JSON file that stores your SQL, your table positions, the camera view, and which database dialect you are using. You can also generate a share link that encodes the entire project in the URL itself, compressed and stored in the link fragment so it never touches a server. The tool supports MySQL, PostgreSQL, SQLite, and SQL Server syntax for reading schemas and for suggesting column types when you add new columns. Additional features include sticky notes and group boxes you can add to annotate sections of the diagram, PNG and SVG export, light and dark themes, and a syntax-highlighted SQL editor. The tool is open source and available at sqltoerdiagram.com. To run it locally, you install dependencies with npm and start a development server.