Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Schemity

schemity.com

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • API
8.5 Club score Visit schemity.com

What Schemity is

Schemity is database design software that reads live databases and previews schema changes before they are applied. It displays proposed migrations and their effects, and runs one only after the user clicks Migrate. Supported databases are PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite. Design tools include ERDs, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes. A local MCP server provides 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 sends an automatically generated machine ID and country code for license verification. A two-week desktop trial unlocks every feature without a credit card. After the trial, offline design remains available, while live database features and Context Views pause until a license is active. Lite is free for browser-based design and link sharing; a License costs $129 one-time.

Who it suits

Schemity is aimed at software engineers who design or maintain database schemas. It may suit users who want to preview migrations before applying them or keep design files under version control.

Good to know, and what to watch

  • Previews migration effects before running changes.
  • Supports six listed database platforms.
  • Includes ERD design, SQL and DBML import.
  • Stores designs as plain JSON files locally.
  • Two-week trial unlocks all features without a credit card.
  • Live database features pause after the trial without a license.
  • Desktop license costs $129 one-time.
  • License verification transmits a machine ID and country code.

Education

Free

Education license

Free

Free trial

Free

Lite

Free

Free plan · 14-day trial

Getting started

  1. Open the Schemity website
  2. Use Lite for free browser-based design and link sharing
  3. Start the two-week desktop trial without a credit card
  4. Connect one of the supported databases for live features
  5. Use the desktop app to save designs as JSON files

Limits to check

Lite is limited to browser-based schema design and sharing by link. After the two-week trial, offline design remains available, but live database features and Context Views pause until a license is active.

The Club's review

Schemity is a database design application for engineers who need to understand schema changes before applying them. It is best suited to developers and teams working with live databases, especially those who want local project files and a deliberate approval step. Its strongest proposition is controlled migration review; the main trade-off is that live capabilities require a paid license after the trial.

Overview

Schemity connects to a live database, reads its schema and previews proposed changes together with their effects. A migration is not executed until the user clicks Migrate, creating a clear pause for inspection before a potentially consequential operation. That makes it more than a diagramming tool, although it does not replace a team's wider code-review or deployment process.

Supported databases include PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite. Desktop projects are stored as plain JSON on the user's machine, so teams can put them under Git version control. The desktop application has no cloud backend, accounts, analytics or telemetry. It does send an automatically generated machine ID and country code for license verification, a limited verification exchange that privacy-conscious buyers should still account for.

Key features

  • Migration review: Proposed schema operations and their consequences are shown before execution, while the explicit Migrate action keeps the final decision with the user. This is valuable for production-minded engineers who want visibility before altering a live system.
  • Database modeling: ERD design, inferred relationships, check constraints and junction-table generation cover both visual modeling and common relational structures. SQL and DBML import make it practical to start from an existing design rather than redraw it.
  • Schema linting: Checks span 26 classes of problems, giving designers a way to catch structural issues during modeling instead of discovering them during deployment.
  • Reverse and forward engineering: Schemity can read an existing database and export SQL for a planned design. Version history supports keeping track of iterations, while web and desktop deployment accommodate browser-based sharing and installed work.
  • AI-agent integration: A local MCP server exposes 16 tools to Claude Code, Claude Desktop, Cursor, Codex, OpenCode and other MCP hosts. It listens only on the user's machine, keeps its token in the operating system keychain and does not provide an AI agent with database credentials. That architecture is a meaningful safeguard for teams experimenting with AI-assisted schema work, though the usefulness depends on adopting an MCP-compatible client.

Pricing

The Lite plan is free and provides browser-based schema design plus link sharing. It is a sensible choice for lightweight modeling or sharing a design, but it does not cover the full desktop and live-database workflow.

An Education license is free for students and educators who request it with a .edu address. It unlocks all features and includes one year of updates, making it the most complete no-cost option for eligible academic users.

The License costs $129, paid once. It unlocks all features, includes one year of updates and can be used forever after updates expire. Continued updates are optional at $69 a year. This ownership model is attractive to individuals and small teams that dislike perpetual subscriptions, while the one-seat or team terms are not defined by the plan itself; organizations should contact the creator for invoices, offline activation, security review or volume licensing.

The desktop trial lasts 14 days, requires no credit card and unlocks every feature. After it ends, offline design continues to work, but live database features and Context Views pause until a license is active. That makes the trial useful for a complete evaluation, but not a route to indefinitely free live-database use.

Platforms

Schemity runs on Linux, macOS, Windows and the web. Web access supports browser-based design and sharing, while the desktop application provides the local JSON workflow and live-database features. Buyers should choose the platform that matches whether they prioritize link-based collaboration or local, version-controlled projects.

Who it's for

Schemity fits software engineers designing or maintaining production schemas, database practitioners who want a review gate before migrations, and privacy-conscious teams that prefer local storage and an on-device AI bridge. It is less suitable for someone who only needs a free, permanently live database-management environment: the free Lite plan is browser-focused, and desktop live features stop after the trial without a license.

Pros and cons

Pros

  • Migration approval is explicit: Effects are previewed and execution requires a deliberate click, reducing accidental application of changes.
  • Broad relational coverage: Six named database systems, including Supabase and SQLite, make the tool relevant across varied stacks.
  • Local-first workflow: JSON files can be version-controlled, and the desktop app avoids accounts, cloud backend, analytics and telemetry.
  • Strong AI boundary: The local MCP server keeps credentials away from agents while supporting 16 tools and several major MCP clients.
  • Perpetual-use license: The $129 license remains usable after its included update year ends, with renewal optional.

Cons

  • Live features are time-limited without payment: They pause after the 14-day trial, even though offline design remains available.
  • Free Lite is narrow: It covers browser design and link sharing rather than the complete desktop workflow.
  • Update renewal adds an ongoing cost: Staying current costs $69 per year after the first included year.
  • Team purchasing needs a direct conversation: Invoices, offline activation, security review and volume licensing are handled by contacting the creator.

Alternatives

MySQL is the better choice when the priority is running a database platform itself, with a free GPL-licensed Community Edition and replication and high-availability components, rather than modeling and reviewing migrations in a dedicated design application.

Hackolade Studio suits users who need a freemium modeler with a 50-object Community Edition cap and a 14-day Workgroup trial.

DbSchema is worth choosing when saved design files and schema synchronization are central requirements in its Pro plan.

pgModeler is an alternative for PostgreSQL-focused users comparing time-limited single-user licenses or a team lifetime option.

Database Workbench is aimed at Linux and Windows users choosing among Basic, Professional and Enterprise database-system tiers.

drawDB is the simpler free web or self-hosted route, offering local diagrams and SQL-dialect import and export; paid tiers add cloud sync and sharing.

ERBuilder Data Modeler is a Windows-only alternative with Professional at $139 a year and Enterprise at $399 a year.

WorksCove ERD is a web-based option with a Professional plan at $10 a month and features including unlimited projects and tables, SQL and PNG export, and version history.

Verdict

Choose Schemity if you are an engineer who wants database modeling, live-schema inspection and a visible migration approval step in one local-first tool. The one-time $129 license and careful MCP security boundary strengthen its case for individual developers and small teams. Look elsewhere if you need permanently free live features, a narrowly PostgreSQL-only modeler, or a database platform rather than a schema-design and migration-review application.

The verdict

Schemity combines schema design with a review step before migrations run. Its free Lite plan covers browser-based design and link sharing; users needing live database features after the trial need an active license.

Questions people ask

Is there a free plan?

Yes. Lite is free and provides browser-based schema design with link sharing.

How much is the full license?

The License costs $129 once, includes one year of updates, and can be used forever after updates expire. Optional updates renewal is $69 a year.

How long is the trial?

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

Which databases are supported?

Schemity lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite.

Does it work with AI coding tools?

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

What the maker publishes

AI assistant
AI Chat supports bring-your-own provider keys and can use a local Ollama model so model calls can remain on the user's machine. source
AI credentials
The local MCP server keeps its token in the operating-system keychain and does not give an agent database credentials. source
AI integration
A local MCP server exposes sixteen tools for schema reading, impact measurement, drawing and staged organization actions. source
AI integrations
Its local MCP server offers 16 tools and works with Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and any MCP host. source
Audience
The maker describes Schemity as database design software for software engineers and says its creator uses it to design and maintain production schemas. source
Capterra pricing record
Capterra lists a $129 one-time license and a $69-per-year updates add-on, and identifies a free education option. source
Company location
Son Tran's public DEV profile identifies Hanoi, Vietnam as his base and describes him as an indie founder who built Schemity. source
Company size and funding
The opened maker pages identify an individual creator but do not state a legal entity, employee count, headquarters outside Hanoi, funding or investors. source
Context Map
The Context Map represents domains as nodes and counts foreign-key dependencies between them. source
Context views
Context Views provide focused read-only projections of one shared schema so domains such as billing or authentication can be viewed separately. source
Database support
The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases. source
Design features
Features include ERD design, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes. source
Documentation depth
The documentation index lists 34 guides covering installation, six database engines, reverse engineering, design, context views, JSON storage, MCP, migrations and exports. source
ERD design
Its canvas models entities, fields and crow's-foot relationships, including 1:N, 1:1 and N:N links with generated junction tables. source
Export formats
Desktop exports include PNG, JPEG, SVG, SQL, Mermaid, DBML, PlantUML, D2, OpenAPI and data dictionaries in HTML, PDF, Markdown or Excel. source
Git-native storage
Workspaces are human-readable JSON folders that can be placed inside a Git repository and reviewed as pull-request diffs. source
Impact analysis
Impact analysis reports potential data loss, failing statements, table locks or rewrites, broken dependents and foreign-key propagation before migration. source
Import formats
The product imports SQL CREATE TABLE statements, full SQL dumps and DBML files. source
Licence status
Schemity is described as proprietary software with a one-time licence rather than an open-source project. source
Limit: collaboration
The maker's comparison states Schemity is deliberately single-designer and lacks real-time multi-user cursors and live collaborative editing. source
Limit: no flowchart feature
The Capterra catalog's feature comparison says Schemity does not offer Flowchart functionality. source
Limit: post-trial access
After the trial, offline design remains usable but live database features and Context Views pause until licensing, while only existing workspaces remain fully usable. source
Limit: team purchasing
The pricing page says invoice, purchase-order, offline activation, security review and larger team licensing are not automated and require direct contact. source
Local storage
Schemity stores work as plain JSON files on the user's machine, which can be version-controlled with Git. source

Checked against the maker's pages on 15 Oct 2026.