Hey everyone,
I’ve been working on a desktop app called Schemity - an ERD (Entity Relationship Diagram) tool for database designers and developers.
Most ERD tools I’ve tried are either cloud-only, have rigid relations, hard to use or don’t actually connect to a real database. Schemity tries to fill that gap.
What it does:
- Design database schemas visually with entities, fields, and relationships
- Connect to MySQL or PostgreSQL (direct or via SSH tunnel)
- Reverse-engineer an existing database into a diagram instantly
- Generate and apply SQL migrations directly from diagram changes
- Works fully offline - data is stored as local JSON files, no cloud, no account required
A few things I’m proud of:
- Snap guides, entity color coding, custom relationship line waypoints
- Unique-together, check constraints, and index management
- Full undo/redo, copy/paste across diagrams, multi-tab editing
- Keyboard-first design with vim-style navigation (h/j/k/l)
- Entity templates for reusable field sets
Available on macOS, Windows, and Linux.
Would love to hear feedback, especially from anyone doing schema-heavy work. Happy to answer questions!
83% thành viên diễn đàn không hỏi bài tập, còn bạn thì sao?