Schemity Lite is a free, browser-based ERD tool for designing database schemas. Visually map your tables, columns, and relationships as an entity relationship diagram, then save and share your designs from anywhere - no install, no credit card.
Runs in your browser. Sign in with Google to save and share.
A schema visualizer with smart defaults, drag-and-drop relationships, and a visual editor that gets out of your way - so you spend time understanding the schema, not fighting the tool.
Sketch your schema in seconds. Go from concept to concrete entities before the idea fades.
Create 1:N, 1:1, or N:N relationships with simple drag-and-drop. Auto junction table generation, auto FK naming - no manual wiring needed.
Arrange your ERD the way you think about it, not the way the layout forces you. Lines adapt and reroute automatically, turn with rounded corners, and hop over each other where they cross. Add ERD custom waypoints for full control.
Full check constraint support - write any expression you need. For IN constraints, Schemity extracts the allowed values into a selectable dropdown for default values - self-documenting and enforceable in one step.
Group related entities visually. Color-code entity groups and their relationship lines for instant clarity on large schemas.
Instantly distinguish between single-field unique constraints and ERD composite unique constraints at a glance.
Use tabs to separate the systems you work on - one product, one tab. Quick number-key navigation keeps you focused as you move between domains.
Model across PostgreSQL schemas - not just the public schema. Use them to express domains and structural boundaries inside a single database.
A free online schema visualizer for quick data modeling. Sketch an ERD, keep it in the cloud, and hand a public link to anyone - no account needed for viewers.
Map tables, columns, and relationships on an infinite canvas. Draw foreign keys between entities and read them at a glance with clean, crow's foot notation connection lines.
Sign in with Google and your diagrams are stored in the cloud, ready to pick up on any computer. No files to manage, nothing to install - just open your browser and keep working.
Turn any diagram into a public link and send it to teammates, clients, or stakeholders. Viewers open it in their browser - no sign-in, no setup required to look.
Define a template with the fields you add to almost every table -
like id, created_at, and updated_at -
and new entities start pre-populated, so you stop retyping the same columns.
Export your schema as an image to drop into docs, design reviews, or slide decks. A fast SQL diagram tool for sharing your data model with anyone, technical or not.
Schemity Lite runs entirely in your browser, on any operating system. A free database design tool you can open on a borrowed laptop and start modeling in seconds.
Go to lite.schemity.com and sign in with Google. Your diagrams are saved to the cloud automatically, available from any computer.
Add tables, define columns, and connect entities to build your entity relationship diagram. Use entity templates to skip the repetitive fields.
Share a public link so anyone can view your design, or export the diagram as an image for docs and reviews.
Schemity Lite is the free, browser-based version for visual schema design. When you need to work against real databases, the Schemity desktop app is an offline ERD tool that keeps your schema on your machine - no cloud, no subscription.
Connect directly to MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Supabase to visualize your real schema on the desktop.
Reverse engineer PostgreSQL to ERD in seconds, or generate an ERD from a SQL dump - get a complete picture of an existing database without manual work.
Schemity diffs your ERD against the live database and produces the exact SQL migration. Plus a built-in BYOK AI assistant, Context Views, and Git-native JSON storage.