Break complex schemas into focused Context Views - one source of truth, many perspectives. Your schema never leaves your machine. One-time purchase, no subscription.
PostgreSQL
Supabase
MySQL
MariaDB
SQL Server
SQLite
A schema visualizer with smart defaults, drag-and-drop relationships, and a visual editor that gets out of your way - so your team spends time understanding the schema, not fighting the tool.
Sketch your schema in seconds. Go from concept to concrete entities before the idea fades.
Create 1:N, 1:1, or N:N relationships with simple drag-and-drop. Auto junction table generation, auto FK naming - no manual wiring needed.
Arrange your ERD the way you think about it, not the way the layout forces you. Lines adapt and reroute automatically, turn with rounded corners, and hop over each other where they cross. Add ERD custom waypoints for full control.
Full check constraint support - write any expression you need. For IN constraints, Schemity extracts the allowed values into a selectable dropdown for default values - self-documenting and enforceable in one step.
Group related entities visually. Color-code entity groups and their relationship lines for instant clarity on large schemas.
Instantly distinguish between single-field unique constraints and ERD composite unique constraints at a glance.
Every schema change requires explicit migration confirmation - no accidental alterations to your database. Review the exact ERD migration SQL diff before applying.
Use tabs to separate the systems you work on - one product, one tab. Quick number-key navigation keeps you focused as you move between domains.
Model across PostgreSQL schemas - not just the public schema. Use them to express domains and structural boundaries inside a single database.
Import CREATE TABLE statements, a SQL dump file, or a DBML file. Schemity builds entities, fields, and relationships automatically - no database connection needed. Export back to DBML anytime.
AI ERD without cloud - full control from chat. Create entities, define relationships, edit or delete fields, and import entities into Context Views. BYOK - your data goes directly to your AI provider, never through our servers. Or chat with local models via Ollama and keep everything on your machine.
Connect your database, break it into focused Context Views, and evolve the schema with confidence - all from a single source of truth.
Reverse engineer PostgreSQL to ERD in seconds, visualize a MySQL schema on your desktop, or start from scratch. Get a complete visual picture of your schema - no weeks of manual documentation. Everything stays on your machine.
Reduce 50 tables down to a 10-table focused view. Create one Context View per concern - auth, billing, analytics - ready for audits, handovers, or onboarding new team members.
Schemity diffs your ERD against the live database and generates the exact SQL migration. Your ERD lives as plain JSON in your repo - no third-party server ever sees your schema.
An ERD tool with no cloud means your client's schema never touches a third-party server. What we don't store, we don't have to protect - and you don't have to audit. Safe for NDA projects, client work, and air-gapped environments.
We only store an auto-generated device ID and your country - for license management and regional support. No name, no email, no usage tracking. Nothing that identifies you.
All payment processing and billing are managed by LemonSqueezy. Schemity never sees or stores your payment information.
Because Schemity stores almost nothing, it largely satisfies SOC 2 and ISO 27001 requirements by design. Your ERD files live locally in your repo - not on our servers.
Experience seamless performance and native feel across all major operating systems.
Working notes on context views, ERD best practices for software engineers, and the principles behind a Git-native ERD tool. The latest few posts.
