Capabilities
Everything you need to ship a clear data model
Zychema focuses on the work between whiteboard and production — without noisy dashboards or unrelated tooling.
Schema designer
Model PostgreSQL and MySQL tables, columns, and constraints. Edit mock data with drag-and-drop rows, URL previews for avatar columns, and on-demand loading for large schemas.
Mock data grid
Add sample rows in Table view, reorder with drag handles, delete rows, and preview image URLs — no live database required.
Fast partial loading
Open large projects without fetching the entire schema at once. Tables, columns, and diagram data load in focused chunks so the designer stays responsive.
ER diagram
See relationships at a glance and keep diagrams aligned with your live schema.
Import & export
Import SQL, JSON, or Excel. Export DDL, data, and Mermaid erDiagram (.mmd) for Mermaid Live Editor — table and column names match your schema.
Visual Query Builder
Build JOINs, filters, and sorts visually. Preview SQL and a mock results grid on desktop or mobile — no live database required.
Schema Diff & Migrations
Compare schema states visually and auto-generate ALTER TABLE SQL migration scripts instantly.
Schema Health & Linter
Detect primary keys issues, missing foreign keys, or redundant indices with real-time feedback.
Interactive Docs Viewer
Automatically generate database documentation and export to Markdown or printable PDF formats.
Git integration
Track schema history, compare versions, and restore previous snapshots inside your workspace.
Team & realtime diagram
Invite editors and viewers, stream member presence over SSE, upload profile avatars, and collaborate on diagram layout with live sync.
Diagram image export
Export your ER canvas as PNG, JPG, or PDF for decks, wikis, and handoffs.
Why teams choose us
Built for clarity, not complexity
Zychema helps you move from idea to executable schema with less back-and-forth. Interfaces stay calm so reviewers and engineers can focus on the model.
- One workspace for diagrams, table design, and multi-format export
- Mock data rows with add, drag-and-drop reorder, delete, and URL previews
- Partial schema loading so large projects open quickly in DB Designer
- Schema Health linter, Docs (MD/PDF), Diff migrations, and Query Builder
- Export SQL, JSON, Excel, and Mermaid erDiagram with real table names
- PostgreSQL and MySQL types with sensible defaults
- Project roles, invites, profile avatars, and live member presence
- Import existing SQL, JSON, or Excel to bootstrap a schema quickly
- Plans that scale from solo builders to growing teams
A single view of your schema, diagram, and export tools.
Pricing
Straightforward plans as you grow
Compare tiers below. Create an account to subscribe or change plans anytime from settings.