Everything you need to know about Schemity.
General
Schemity is a local-first desktop application for database ERD (Entity Relationship Diagram) visualization and migration generation. It lets you design database schemas visually, reverse-engineer existing databases, and generate precise SQL migrations — all without sending your data to any cloud server.
Schemity currently supports MySQL and PostgreSQL. PostgreSQL users also get multi-schema support — not just the public schema.
Schemity is available as a native desktop app on:
Schemity is free forever for education and personal learning. Students and educators get full access to all features at no cost.
A professional/commercial license is planned. Pricing has not yet been announced.
Features
Use the visual ERD designer to drag and drop entities onto the canvas, define fields, and connect them with relationships. The interface supports auto-resize, snap-to-guide alignment, and smart connection lines. For speed, use entity templates to reuse common field patterns across entities.
Yes. Schemity supports reverse engineering — connect to an existing MySQL or PostgreSQL database and the ERD diagram is generated automatically. This is useful for documenting legacy systems or onboarding to a new codebase.
Schemity compares your ERD design with the actual database state and generates the exact SQL needed to bring them in sync. It handles CREATE, ALTER, and DROP statements automatically. Every migration requires explicit confirmation before being applied, protecting you from accidental changes.
Schemity supports one-to-many and many-to-many relationships, built with intuitive drag-and-drop — no manual foreign key wiring required. Relationship lines adapt and reroute automatically as you move entities on the canvas.
Schemity supports full constraint coverage including:
Yes. Schemity supports secure SSH tunneling for connecting to remote databases. Your database credentials are stored safely in your operating system's native keyring — never in plaintext files.
Schemity is built for keyboard-first use. It supports:
h j k l)Cmd+1 through Cmd+9Yes. Schemity supports multiple tabs simultaneously. You can switch between them quickly using number-key navigation, making it easy to work across multiple schemas or projects in a single session.
Yes. Schemity has full temporal state management with undo/redo history. You can step back through your entire edit history with confidence.
Yes. You can assign custom colors to entities and their relationships for instant visual grouping and clearer diagram readability.
Privacy & Data
No. Schemity is 100% offline. Your database schemas, designs, and all project data are stored locally on your machine and are never transmitted to any server.
Your workspace is stored as JSON files in a local folder on your machine. This means you have complete data ownership, no cloud dependency, and easy version control with Git.
The only information Schemity requires is your device ID and email address, used solely for license activation and verification via LemonSqueezy. No schema data, project files, or other user content is ever shared with any third party.
Yes. Schemity does not store your database credentials on any remote server. All connection details, including SSH credentials, remain on your local machine and are stored in your OS native keyring.
License & Pricing
License activation is handled through LemonSqueezy. After purchase, you will receive a license key via email. Enter that key along with your email address inside Schemity to activate it on your device.
The license is tied to your device ID. License transfers are subject to the terms of the license type you have acquired. Contact support@schemity.com for assistance.
A professional license for commercial use is planned. Pricing details have not yet been announced. Follow the Discord community for updates.
Support
Use the GitHub feedback repository to report bugs and submit feature requests. You can also reach out on the Discord community.
Email us at support@schemity.com for any questions, licensing issues, or general inquiries.
Yes! Join the Schemity Discord server to connect with other users, share feedback, and get updates on new releases.
New versions are released periodically. Download the latest installer from the Platforms section of the website and install it over your existing version. While backward compatibility is a goal, some updates may affect existing configurations.