Schemity

Visit site Alternatives

Score7.1

Rank#5 of 32

PriceFree

Free planYes

Free trialYes

Runs onLinux, macOS, Web, Windows

Summary

Schemity is database design software that reads a live database and previews schema changes before they are run. It shows proposed changes and their effects, and only carries out a migration after you click Migrate. Supported databases include PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite. 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 as plain JSON files on your machine, suitable for version control with Git. It has no cloud backend, accounts, analytics, or telemetry, but sends an automatically generated machine ID and country code for license verification. A two-week desktop trial unlocks all features without a credit card. Afterward, offline design continues to work, while live database features and Context Views pause until a license is active. Lite provides free browser-based design and link sharing; a License costs $129 one-time.

Who it is for

Schemity suits software engineers who want to design database schemas and review proposed changes before applying migrations. Its local MCP server may be useful to people working with the listed MCP-compatible tools.

What is good

Previews migration effects before execution.
Supports six listed database types.
Stores desktop work as local JSON files.
Two-week trial unlocks all features without a credit card.
Lite includes browser design and link sharing for free.

What to know first

Live database features pause after the trial without a license.
Context Views also pause after the trial without a license.
A License costs $129 one-time.

Verdict

Schemity brings schema design and migration review together, with local file storage and integrations through its MCP server. Note that live database features and Context Views require an active license after the trial.

Schemity plans and pricing

All plans

Lite Free Free Browser-based schema design · Share by link schemity.com · 4 Oct 2026

Education license Free Free for students and educators All features unlocked · 1 year of updates included · Request with a .edu address schemity.com · 4 Oct 2026

License $129 once $129 one-time All features unlocked · 1 year of updates included · Use forever after updates expire · Optional updates renewal $69/year schemity.com · 4 Oct 2026

Compared on database design tools

Free plan: Yesschemity.com
Reverse engineering: Yesschemity.com
Forward engineering: Yesschemity.com
SQL export: Yesschemity.com
Supported databases: MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, Supabaseschemity.com
Version history: Yesschemity.com
Deployment: web_and_desktopschemity.com

Facts

Product: Schemity is database design software that reads a live database and previews the effects of schema changes before the user runs them.schemity.com · 4 Oct 2026
Database support: The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases.schemity.com · 4 Oct 2026
Migration review: Schemity displays proposed changes and their effects, and only runs a migration when the user clicks Migrate.schemity.com · 4 Oct 2026
Design features: Features include ERD design, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes.schemity.com · 4 Oct 2026
AI integrations: Its local MCP server offers 16 tools and works with Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and any MCP host.schemity.com · 4 Oct 2026
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.schemity.com · 4 Oct 2026
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.schemity.com · 4 Oct 2026
Local storage: Schemity stores work as plain JSON files on the user's machine, which can be version-controlled with Git.schemity.com · 4 Oct 2026
Platforms: The desktop app is listed for macOS 11 or newer, Windows 10/11 x64, and Ubuntu or Debian x64; Schemity Lite runs in a browser.schemity.com · 4 Oct 2026
Trial: The desktop trial lasts two weeks, unlocks every feature, and requires no credit card.schemity.com · 4 Oct 2026
Trial limits: After the trial, offline design continues to work, while live database features and Context Views pause until a license is active.schemity.com · 4 Oct 2026
Support: The maker invites users to contact the creator directly about team purchase needs such as invoices, offline activation, security review, or volume licensing.schemity.com · 4 Oct 2026
Audience: The maker describes Schemity as database design software for software engineers and says its creator uses it to design and maintain production schemas.schemity.com · 4 Oct 2026