Which databases does Schemity support?

It reads PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite, and supports Snowflake design via GET_DDL import and SQL conversion.

Is there a subscription?

No. It is a $129 one-time purchase with 1 year of updates included; further updates are an optional $29/year.

What happens when the trial ends?

Offline design and existing workspaces keep working, while live-database features and Context Views pause until a license is bought.

Can AI agents change my database?

Agents work through a local MCP server and only stage edits; nothing touches the database until the user clicks Migrate.

Schemity

A native desktop ERD tool for software engineers. Design and document database schemas offline, no account required.

Category:

Design Assets

Maker:

Schemity

⚡️ Tags detected by AI

27 visitors went to Schemity from LandinTools in the last 30 days.

Your product? Claim it to see where they come from

About Schemity

Schemity is desktop database design software that connects to a live database, draws every table as an ERD, and infers missing foreign keys as dashed lines. It reads PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite, directly or over SSH, and supports Snowflake design through GET_DDL import. Large schemas can be split by domain into a Context Map and Context Views.

Before a schema change runs, Schemity draws it with dropped, added and changed columns and reports lost rows, failing statements, table rewrites and dependent views or triggers. Nothing reaches the database until the user clicks Migrate. A local MCP server with 16 tools lets AI agents such as Claude Code, Cursor and Codex read the schema and stage edits for review without holding database credentials.

Diagrams are saved as plain JSON files that can be committed to Git, and the app works offline. It includes 26 schema lint rules, SQL import, and exports to formats such as SVG, Mermaid, DBML, PlantUML, D2, OpenAPI and data dictionaries. It runs on macOS, Windows and Linux and is aimed at software engineers.

Best for

Software engineers managing production database schemas
Teams documenting legacy databases
Developers using AI coding agents on database work
Engineers who prefer one-time software purchases

Pros

Shows data loss and broken views before migrations run
Local MCP server keeps database credentials away from AI agents
Diagrams stored as Git-friendly JSON files
One-time purchase with no limits on tables or diagrams

Cons

Live-database features pause after the trial without a license
Updates after the first year cost $29/year

Pricing

Free 2-week trial with no credit card, then a $129 one-time license (up to 3 machines, 1 year of updates, $29/year optional renewal), a $499 Team License for up to 5 engineers, free education licenses, and a free browser-based Schemity Lite.

Schemity FAQ

Which databases does Schemity support?: It reads PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite, and supports Snowflake design via GET_DDL import and SQL conversion.
Is there a subscription?: No. It is a $129 one-time purchase with 1 year of updates included; further updates are an optional $29/year.
What happens when the trial ends?: Offline design and existing workspaces keep working, while live-database features and Context Views pause until a license is bought.
Can AI agents change my database?: Agents work through a local MCP server and only stage edits; nothing touches the database until the user clicks Migrate.