Schemity

Schemity is a native desktop ERD (Entity Relationship Diagram) tool for database designers and developers. It works fully offline - no cloud, no account required - with data stored as local JSON files that are version-control friendly.

Database Integration

• Connect to MySQL or PostgreSQL via direct connection or SSH tunnel
• Reverse-engineer an existing database into a diagram instantly
• Generate and apply SQL migrations directly from diagram changes
• Pure design mode available (no database connection required)

Visual Design

• Create and manage entities, fields, relationships, and constraints
• Support for primary keys, foreign keys, unique-together, check constraints, and ndexes
• 1:N, 1:1, N:N, and self-referencing relationships
• Smart snap guides, entity color coding, and custom relationship line waypoints
• Legend/annotation boxes for grouping and notes

Productivity

• Keyboard-first design with vim-style navigation (h/j/k/l)
• Full undo/redo, copy/paste across diagrams, multi-tab editing
• Entity templates for reusable field sets
• Quick entity search, field duplication, and fast move shortcuts
• Export diagrams to PNG

Available on macOS, Windows, and Linux.