Schemity is database design software that reads a live database and previews schema changes before they run. It displays proposed changes and their effects, and only runs a migration after the user clicks Migrate. Supported databases include PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite. Design features include ERD design, 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 the user's machine, which can be version-controlled with Git. It has no cloud backend, accounts, analytics or telemetry, but transmits a machine ID and country code for license verification. A two-week trial unlocks every feature without a credit card. After it ends, offline design still works, 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 is aimed at software engineers designing and maintaining database schemas. Its local MCP server may also suit people working with supported MCP hosts.

What is good

Previews migration effects before running changes.
Supports six listed databases.
Schema linting checks 26 problem classes.
Trial unlocks all features without a credit card.

What to know first

Trial lasts two weeks.
Live database features pause after the trial without a license.
License costs $129 one-time.

Verdict

Schemity combines schema design with a review step before migrations run, and supports a range of databases. Its trial is time-limited, and live database features require an active license afterward.

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: Yes
Reverse engineering: Yes
Forward engineering: Yes
SQL export: Yes
Supported databases: MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, Supabase
Version history: Yes
Deployment: web_and_desktop

Best Schemity alternatives

See all 12

Two bars Hackolade Studio Free tier No. 1$145.83/mo6.6 Two bars MySQL Free tier No. 2Free6.6 Two bars DbSchema Free tier No. 3$9/mo6.5 Two bars pgModeler Free tier No. 4$59.90/mo6.5 One bar ChartDB Free tier No. 6$25/mo6.4 One bar Database Workbench Free tier No. 7Free6.4

The record

Product

Schemity is database design software that reads a live database and previews the effects of schema changes before the user runs them.

Database support

The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases.

Migration review

Schemity displays proposed changes and their effects, and only runs a migration when the user clicks Migrate.

Design features

Features include ERD design, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes.

AI integrations

Its local MCP server offers 16 tools and works with Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and any MCP host.

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.

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.

Local storage

Schemity stores work as plain JSON files on the user's machine, which can be version-controlled with Git.

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.

Trial

The desktop trial lasts two weeks, unlocks every feature, and requires no credit card.

Trial limits

After the trial, offline design continues to work, while live database features and Context Views pause until a license is active.

Support

The maker invites users to contact the creator directly about team purchase needs such as invoices, offline activation, security review, or volume licensing.

Audience

The maker describes Schemity as database design software for software engineers and says its creator uses it to design and maintain production schemas.

Price from

Free