ERD Designer

What ERD Designer is

ERD Designer is a free, open-source tool for visually designing database schemas. Users arrange tables on a canvas, define relationships and automatically synchronize foreign keys. It generates DDL for PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, BigQuery and Snowflake, and can import existing DDL. Table specifications can be exported to Excel or Google Spreadsheets; diagrams can be saved as PNG, SVG or interactive HTML. Column Share Models let users reuse column definitions across tables, while Column Groups apply common columns in bulk. ERD Designer is available in a browser, as a VSCode extension and as a Google Drive app. The browser version stores design data locally in IndexedDB and requires no installation or account. Google Drive files can be viewed simultaneously, but not edited simultaneously. A separately installed CLI compares designs with database schemas or revisions; comparison is read-only, and its migration command drafts SQL. The agent plugin and MCP server are experimental. The project directs bug reports and feature requests to GitHub Issues.