
Schemity
Database design software with AI agent integration via local MCP server
Schemity is database design software that reads live databases into ERDs, provides a local MCP server for AI agents to safely interact with schemas, and shows
About this launch

Schemity is database design software for software engineers. It reverse-engineers live databases into visual Entity Relationship Diagrams, breaking large schemas into focused Context Views by domain. The software includes a local database MCP server with 18 tools that allow AI agents like Claude Code and Cursor to read schemas and propose changes without executing SQL or accessing data. All edits stage as unsaved changes on the diagram, requiring explicit approval before migrations run. Diagrams are stored as plain JSON files for Git version control. The tool supports PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Supabase and Snowflake. It runs entirely offline on macOS, Windows and Linux.
What it does
- Reverse engineering for PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, Supabase and Snowflake
- Local database MCP server with 18 tools for AI agents
- Migration generation with reviewable SQL diff
- Export to multiple formats: SQL, SVG, Mermaid, DBML, PlantUML, D2, OpenAPI and data dictionary
- Git-native JSON file storage for version control
- SSH tunneling for secure database connections
Pricing
Pricing model: Paid
License: $129 one-time, includes 1 year of updates. Team License: $499 one-time for up to 5 engineers. After first year, updates optional at $29/year. 2-week free trial, 14-day refund. Free for students and educators.
Shopper questions
What is a database MCP server?
A server that speaks the Model Context Protocol and gives an AI agent tools for a database. Most offer a tool that runs SQL. Schemity offers tools that read the schema and measure a change instead, and none of the tools run SQL the agent writes.
Does Schemity's MCP server run queries against my database?
Only to read the catalogue (tables, keys, dependent views, size estimates) for impact analysis, and a COUNT when a finding needs an exact number and you ask for it. A count is a SELECT COUNT with a 60-second timeout, inside a read-only transaction on PostgreSQL and MySQL. No tool returns a row.
Can an AI agent change my database schema through Schemity?
The agent can propose changes, which land on the diagram as unsaved changes behind an Agent changes button. Deleting anything you made asks you first, and the database changes only when you click Migrate or run the migration yourself.
Which AI agents does it work with?
Claude Code, Claude Desktop, Cursor, Codex, OpenCode, MCP Inspector, and any other MCP host that speaks stdio or Streamable HTTP. A local model works too, through a host such as LM Studio.
Does my schema leave my machine?
The server listens only on your machine, and Schemity sends nothing to you through it. What the agent reads goes to whichever model its host uses, the same place your code already goes; with a local model, nothing leaves at all.
Schemity has a free listing. The owner can unlock the full profile with a paid launch for $5:
- Founder story (locked)
- Milestones (locked)
- Demo video (locked)
- Dofollow website link: not on this free listing (its website link is nofollow)
Shoppers also viewed
- Hexby.ai
Design tools
- Emblematic
Design tools
- DASHUND.link
Design tools
- Apptune
Design tools