Skip to content
SPECIFICTION
Get listed

Schemity

schemity.com

From $2.42/mo Free plan WebWindowsmacOSLinuxAPI
Visit schemity.com
Spec score 8.8 #4 of 35 in Database Design Tools

What it is

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.

Spec sheet

What it does
Schemity is database design software that connects to live databases, visualizes schemas and previews the effects of schema changes before they run.Read 15 Oct 2026 · schemity.com
Product
Schemity is database design software that reads a live database and previews the effects of schema changes before the user runs them.Read 4 Oct 2026 · schemity.com
Audience
The maker describes Schemity as database design software for software engineers and says its creator uses it to design and maintain production schemas.Read 4 Oct 2026 · schemity.com
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.Read 4 Oct 2026 · schemity.com
Trial
The desktop trial lasts two weeks, unlocks every feature, and requires no credit card.Read 4 Oct 2026 · schemity.com
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.Read 4 Oct 2026 · schemity.com
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.Read 4 Oct 2026 · schemity.com
Support
The maker invites users to contact the creator directly about team purchase needs such as invoices, offline activation, security review, or volume licensing.Read 4 Oct 2026 · schemity.com
Maker
The product identifies Son Tran, a software engineer, as Schemity's creator and maintainer.Read 15 Oct 2026 · schemity.com
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.Read 15 Oct 2026 · schemity.com
AI credentials
The local MCP server keeps its token in the operating-system keychain and does not give an agent database credentials.Read 15 Oct 2026 · schemity.com
AI integration
A local MCP server exposes sixteen tools for schema reading, impact measurement, drawing and staged organization actions.Read 15 Oct 2026 · schemity.com
AI integrations
Its local MCP server offers 16 tools and works with Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and any MCP host.Read 4 Oct 2026 · schemity.com
Capterra pricing record
Capterra lists a $129 one-time license and a $69-per-year updates add-on, and identifies a free education option.Read 15 Oct 2026 · capterra.com
Company location
Son Tran's public DEV profile identifies Hanoi, Vietnam as his base and describes him as an indie founder who built Schemity.Read 15 Oct 2026 · dev.to
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.Read 15 Oct 2026 · schemity.com
Context Map
The Context Map represents domains as nodes and counts foreign-key dependencies between them.Read 15 Oct 2026 · schemity.com
Context views
Context Views provide focused read-only projections of one shared schema so domains such as billing or authentication can be viewed separately.Read 15 Oct 2026 · schemity.com
Database support
The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases.Read 4 Oct 2026 · schemity.com
Design features
Features include ERD design, inferred relationships, SQL and DBML import, check constraints, junction table generation, and schema linting across 26 problem classes.Read 4 Oct 2026 · schemity.com
Documentation depth
The documentation index lists 34 guides covering installation, six database engines, reverse engineering, design, context views, JSON storage, MCP, migrations and exports.Read 15 Oct 2026 · schemity.com
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.Read 15 Oct 2026 · schemity.com
Export formats
Desktop exports include PNG, JPEG, SVG, SQL, Mermaid, DBML, PlantUML, D2, OpenAPI and data dictionaries in HTML, PDF, Markdown or Excel.Read 15 Oct 2026 · github.com
Git-native storage
Workspaces are human-readable JSON folders that can be placed inside a Git repository and reviewed as pull-request diffs.Read 15 Oct 2026 · schemity.com
Impact analysis
Impact analysis reports potential data loss, failing statements, table locks or rewrites, broken dependents and foreign-key propagation before migration.Read 15 Oct 2026 · schemity.com
Import formats
The product imports SQL CREATE TABLE statements, full SQL dumps and DBML files.Read 15 Oct 2026 · schemity.com
Licence status
Schemity is described as proprietary software with a one-time licence rather than an open-source project.Read 15 Oct 2026 · schemity.com
Limit: collaboration
The maker's comparison states Schemity is deliberately single-designer and lacks real-time multi-user cursors and live collaborative editing.Read 15 Oct 2026 · schemity.com
Limit: no flowchart feature
The Capterra catalog's feature comparison says Schemity does not offer Flowchart functionality.Read 15 Oct 2026 · capterra.com
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.Read 15 Oct 2026 · schemity.com
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.Read 15 Oct 2026 · schemity.com
Local storage
Schemity stores work as plain JSON files on the user's machine, which can be version-controlled with Git.Read 4 Oct 2026 · schemity.com
MCP hosts
The maker documents compatibility with Claude Code, Claude Desktop, Cursor, Codex, OpenCode and other MCP hosts.Read 15 Oct 2026 · schemity.com
Migration generation
Schemity compares a diagram with a connected database and generates SQL migration differences that are applied only after explicit approval.Read 15 Oct 2026 · schemity.com
Migration review
Schemity displays proposed changes and their effects, and only runs a migration when the user clicks Migrate.Read 4 Oct 2026 · schemity.com
Migration-file analysis
Users can analyze pasted or existing Prisma, Alembic, Django, Rails, EF or Flyway SQL migration files without executing them.Read 15 Oct 2026 · schemity.com
Notable release
The homepage lists Schemity version 2.10.1 released on January 9, 2026, with interface improvements, dependency updates and bug fixes.Read 15 Oct 2026 · schemity.com
Offline operation
Installation and normal operation require no account or internet connection, and the documentation describes air-gapped use.Read 15 Oct 2026 · schemity.com
Praise: local and Git model
The public GitHub community repository emphasizes local JSON diagrams, no cloud dependency and Git-based versioning.Read 15 Oct 2026 · github.com
Praise: offline workflow
A Reddit discussion describes Schemity as fitting the request for an offline dbdiagram-style tool that generates diagrams from schema input.Read 15 Oct 2026 · reddit.com
Praise: SQL and DBML import
The maker's Reddit reply says Schemity accepts pasted SQL or DBML and offers a free browser version for trying it.Read 15 Oct 2026 · reddit.com
Rating on Capterra
0.0 out of 5 from 0 reviewsRead 15 Oct 2026 · capterra.com
Reverse engineering
The desktop app reverse-engineers live schemas and re-syncs them when diagrams open, preserving existing layout while showing database changes for review.Read 15 Oct 2026 · github.com
Schema lint
Schema lint runs locally and marks seventeen documented rules on the diagram, with per-diagram ignores stored in the JSON file.Read 15 Oct 2026 · schemity.com
Security statement
The maker says schemas are not uploaded to a vendor cloud, passwords are kept in the OS keychain, and licensing stores only a device ID and country.Read 15 Oct 2026 · schemity.com
Support channel
The site links to email support, an FAQ and a Discord community.Read 15 Oct 2026 · schemity.com
Supported databases
The product documents PostgreSQL, Supabase, MySQL, MariaDB, SQL Server and SQLite connections, with Snowflake available for design-only work.Read 15 Oct 2026 · github.com
System requirements
Official downloads target macOS 11 or newer on Apple Silicon or Intel, Windows 10/11 x64 and Ubuntu or Debian x64.Read 15 Oct 2026 · schemity.com
Trial limits
After the trial, offline design continues to work, while live database features and Context Views pause until a license is active.Read 4 Oct 2026 · schemity.com

Plans and prices

Education Free free forever for students and educators all features · .edu verification required Read 15 Oct 2026 · schemity.com
Education license Free Free for students and educators All features unlocked · 1 year of updates included · Request with a .edu address Read 4 Oct 2026 · schemity.com
Free trial Free 14 days all desktop features unlocked · no credit card · image exports carry a watermark Read 15 Oct 2026 · schemity.com
Lite Free Free Browser-based schema design · Share by link Read 4 Oct 2026 · schemity.com
Schemity Lite Free free browser version design, save, share and export schemas · no live database connections Read 15 Oct 2026 · schemity.com
Updates renewal $29 a year optional annual renewal after the first included year requires an existing license · extends updates for one year Read 15 Oct 2026 · schemity.com
License $129, paid once $129 one-time All features unlocked · 1 year of updates included · Use forever after updates expire · Optional updates renewal $69/year Read 4 Oct 2026 · schemity.com
Licensed desktop $129, paid once one-time purchase; 1 year of updates included all features · no table, diagram or workspace caps · use on up to 3 machines Read 15 Oct 2026 · schemity.com

Every Schemity plan and price →

Strong points and limits

Strong points

  • Previews migration effects before applying changes.
  • Supports six listed databases.
  • Schema linting covers 26 problem classes.
  • Desktop work is stored as plain JSON files.
  • Two-week trial unlocks every feature without a credit card.

Limits

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

Who it suits

Schemity is aimed at software engineers designing and maintaining database schemas. It may suit people who want to review migrations before applying them or keep design files under version control.

Verdict

Schemity offers live-schema review alongside design tools and local JSON storage. Its free Lite plan is browser-based, while the desktop trial’s live features require an active license after two weeks.

Where Specifiction places it

Alternatives to SchemityAll alternatives →