Free Online Database Schema Designer
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.
What You Can Design in Schemity Lite
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.
Rapid Prototyping
Sketch your schema in seconds. Go from concept to concrete entities before the idea fades.
Smart Relationships
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.
Flexible Relationship Lines
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.
Check Constraints as Documentation
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.
Custom Entity Colors
Group related entities visually. Color-code entity groups and their relationship lines for instant clarity on large schemas.
Clear Unique Together
Instantly distinguish between single-field unique constraints and ERD composite unique constraints at a glance.
Tabs as Systems
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.
Schemas as Structure
Model across PostgreSQL schemas - not just the public schema. Use them to express domains and structural boundaries inside a single database.
Design, Save, and Share Schemas in Your Browser
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.
Visual ERD Design
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.
Save to the Cloud
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.
Share With a Public Link
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.
Reusable Entity Templates
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 to Images
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.
Nothing to Install
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.
From Blank Canvas to Shared Link in Three Steps
Open and Sign In
Go to lite.schemity.com and sign in with Google. Your diagrams are saved to the cloud automatically, available from any computer.
Model Your Schema
Add tables, define columns, and connect entities to build your entity relationship diagram. Use entity templates to skip the repetitive fields.
Save and Share
Share a public link so anyone can view your design, or export the diagram as an image for docs and reviews.
Connect to a Live Database? Get the Desktop App
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 Live Databases
Connect directly to MySQL, MariaDB, PostgreSQL, SQL Server, SQLite, and Supabase to visualize your real schema on the desktop.
Reverse-Engineer Schemas
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.
Generate SQL Migrations
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.