- Home
- Database Design Tools
- Schemity
Schemity
What it is
Schemity is database design software that reads live databases and previews the effects of schema changes before they run. It displays proposed migrations, but applies them only after the user selects Migrate. Supported databases are 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 and works with Claude Code, Claude Desktop, Cursor, Codex, OpenCode, and other MCP hosts. The desktop app stores projects as plain JSON files on the user's machine, suitable for Git version control. 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 requiring a credit card. After the trial, offline design remains available, while live database features and Context Views pause until a license is active. Lite offers free browser-based design and link sharing; a License costs $129 one-time.
For and against
For
- Previews migration effects before changes run.
- Supports six listed database systems.
- Desktop projects are plain JSON files.
- Two-week trial unlocks all features without a credit card.
Against
- Live database features pause after trial without a license.
- Context Views also pause after trial without a license.
- License costs $129 one-time.
The verdict
Schemity combines schema design with review before migration, and keeps desktop project files local. Its trial provides all features for two weeks, after which live features require an active license.
Who it suits
Schemity suits software engineers designing and maintaining database schemas. Its local MCP server is relevant to users of the listed MCP hosts.
Plans and prices
Schemity Lite
design, save, share and export schemas · no live database connections
Read 15 Oct 2026 · schemity.com
Education
all features · .edu verification required
Read 15 Oct 2026 · schemity.com
Free trial
all desktop features unlocked · no credit card · image exports carry a watermark
Read 15 Oct 2026 · schemity.com
Updates renewal
requires an existing license · extends updates for one year
Read 15 Oct 2026 · schemity.com
Licensed desktop
all features · no table, diagram or workspace caps · use on up to 3 machines
Read 15 Oct 2026 · schemity.com
Lite
Browser-based schema design · Share by link
Read 4 Oct 2026 · schemity.com
Education license
All features unlocked · 1 year of updates included · Request with a .edu address
Read 4 Oct 2026 · schemity.com
License
All features unlocked · 1 year of updates included · Use forever after updates expire · Optional updates renewal $69/year
Read 4 Oct 2026 · schemity.com
On the record
- 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.schemity.com · read 15 Oct 2026
- AI credentials
- The local MCP server keeps its token in the operating-system keychain and does not give an agent database credentials.schemity.com · read 15 Oct 2026
- AI integration
- A local MCP server exposes sixteen tools for schema reading, impact measurement, drawing and staged organization actions.schemity.com · read 15 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 · read 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 · read 4 Oct 2026
- Capterra pricing record
- Capterra lists a $129 one-time license and a $69-per-year updates add-on, and identifies a free education option.capterra.com · read 15 Oct 2026
- Company location
- Son Tran's public DEV profile identifies Hanoi, Vietnam as his base and describes him as an indie founder who built Schemity.dev.to · read 15 Oct 2026
- 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.schemity.com · read 15 Oct 2026
- Context Map
- The Context Map represents domains as nodes and counts foreign-key dependencies between them.schemity.com · read 15 Oct 2026
- Context views
- Context Views provide focused read-only projections of one shared schema so domains such as billing or authentication can be viewed separately.schemity.com · read 15 Oct 2026
- Database support
- The site lists PostgreSQL, Supabase, MySQL, MariaDB, SQL Server, and SQLite as supported databases.schemity.com · read 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 · read 4 Oct 2026
- Documentation depth
- The documentation index lists 34 guides covering installation, six database engines, reverse engineering, design, context views, JSON storage, MCP, migrations and exports.schemity.com · read 15 Oct 2026
- 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.schemity.com · read 15 Oct 2026
- Export formats
- Desktop exports include PNG, JPEG, SVG, SQL, Mermaid, DBML, PlantUML, D2, OpenAPI and data dictionaries in HTML, PDF, Markdown or Excel.github.com · read 15 Oct 2026
- Git-native storage
- Workspaces are human-readable JSON folders that can be placed inside a Git repository and reviewed as pull-request diffs.schemity.com · read 15 Oct 2026
- Impact analysis
- Impact analysis reports potential data loss, failing statements, table locks or rewrites, broken dependents and foreign-key propagation before migration.schemity.com · read 15 Oct 2026
- Import formats
- The product imports SQL CREATE TABLE statements, full SQL dumps and DBML files.schemity.com · read 15 Oct 2026
