Generate ER Diagram from SELECT Queries (JOIN Analysis Tool)
No installation required. Runs entirely in your browser. Introduction When working with existing systems, have you ever struggled with complex SQL like this? Too many JOINs to understand the struct...
Source: DEV Community
No installation required. Runs entirely in your browser. Introduction When working with existing systems, have you ever struggled with complex SQL like this? Too many JOINs to understand the structure Hard to visualize table relationships No ER diagram available I had the same problem, so I built a tool that generates ER diagrams directly from SELECT queries. đ Try it here: SQL2ER trancelens.com â What This Tool Does You can paste a SELECT query, and it will automatically generate an ER diagram based on JOIN relationships. Example SELECT u.name, o.id, p.name FROM users u JOIN orders o ON u.id = o.user_id JOIN order_items oi ON o.id = oi.order_id JOIN products p ON oi.product_id = p.id; đ The tool analyzes JOIN conditions like: u.id = o.user_id and converts them into relationships between tables. Why This Is Useful Most existing tools (like DDL-based ER generators) require CREATE TABLE statements. However, in real-world scenarios: You often only have SELECT queries Youâre analyzing le
