Schemity vs YourERD
Schemity
schemity.comYourERD
yourerd.comSide by side
| Figure | Schemity | YourERD |
|---|---|---|
| Price from | $2.42/mo | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | Yes |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| API | Yes | — |
| Plans published | 8 | 1 |
| Spec score · Database Design Tools | 8.8 (#4) | 7.1 (#28) |
| Database support | The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases. | The FAQ says MySQL 8 is the available DDL target. |
| Privacy | The desktop app has no cloud backend, accounts, analytics, or telemetry; it transmits an automatically generated machine ID and country code for license verification. | The privacy policy says diagrams are not sent to the server when the service is used without signing in. |
| Security | The maker says the MCP server listens only on the user's machine, stores its token in the OS keychain, and does not give an AI agent database credentials. | The privacy policy says passwords use scrypt hashes, MCP and share-link tokens use SHA-256 hashes, and traffic is encrypted with HTTPS. |
| Support | The maker invites users to contact the creator directly about team purchase needs such as invoices, offline activation, security review, or volume licensing. | Support is by email, and the contact page says there is no phone line or live chat. |
Plans
Schemity
- EducationFree
- Education licenseFree
- Free trialFree
- LiteFree
- Schemity LiteFree
- Updates renewal$29 a year
- License$129, paid once
- Licensed desktop$129, paid once
In their own words
Schemity
Schemity is database design software that connects to live databases and previews proposed schema changes before they are applied. It lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite support. A migration displays its proposed changes and effects, and runs only when the user clicks Migrate. Design tools include ERD creation, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes. Its local MCP server offers 16 tools for Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and other MCP hosts. The desktop app stores work in plain JSON files that can be version-controlled with Git. It has no cloud backend, accounts, analytics, or telemetry, but transmits an automatically generated machine ID and country code for license verification. A two-week desktop trial unlocks every feature without a credit card. After it ends, offline design remains available, while live database features and Context Views pause until a license is active. Lite is free; the License is $129 one-time.