{"repo":"kkomelin/ermate","free":true,"listed":false,"github":"https://github.com/kkomelin/ermate","clone":"git clone https://github.com/kkomelin/ermate.git","description":"AI-powered Visual Database Schema Designer","language":"TypeScript","stars":12,"topics":["ai","database","entity-relationship","er-diagram","mysql","postgres","pwa","schema","sql","sqlite"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"ERMate - AI-powered Visual Database Schema Designer Design ER diagrams, define tables and relationships manually or via prompts, and share via URL. 🚀 Try it live Features - Visual canvas - drag-and-drop tables on an interactive grid with zoom, pan, and fit-to-view - Tables & columns - create tables with default columns (id, created at, updated at); add columns with types (VARCHAR, INTEGER, BOOLEAN, TEXT, TIMESTAMP) and constraints (PRIMARY KEY, NOT NULL, UNIQUE) - Relationships - connect columns visually to define one-to-one, one-to-many, and many-to-many relationships - Junction tables - auto-generate junction tables with foreign keys for many-to-many relationships - AI-powered design - create tables, columns, and relationships using natural language; includes batch operations, smart auto-layout, and LLM safety features - SQL export/import - export schemas as SQL DDL or import from SQL dumps with dialect selection (PostgreSQL, MySQL, SQLite) - JSON export/import - download or load schemas as JSON files for backup and transfer - Load schemas - open previously saved schemas from local storage - Share via URL - generate compressed shareable links with the full schema embedded in the URL hash - Auto-save - changes are automatically saved to localStorage after 1 second of inactivity - Restore on startup - automatically loads the last opened schema when you return - Undo/redo - full undo history for schema changes (Ctrl+Z / Ctrl+Shift+Z) - Validation - validate schemas for errors","default_branch":null,"files":null,"tree":[],"storefront":"/r/kkomelin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kkomelin/ermate/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}