🔥
Summer Sale — 45% off
the Schemity License with code
HOTSUMMER
· ends Aug 31 ·
Get the deal →
🔥
45% off License
· code
HOTSUMMER
→
Capabilities
Platforms
Pricing
Docs
Blog
Community
Github
Try Free
Blog
Thoughts on
Schema Design
ERD best practices for software engineers, database design workflows, and developer experience.
July 11, 2026
AI Schema Help That Never Leaves Your Machine
Add Ollama to Schemity and get private AI database design with zero cloud calls - an offline AI ERD tool for teams where cloud AI is banned...
July 10, 2026
The Schema Diagram Your Dashboard Won't Let You Keep
Supabase Studio and pgAdmin will draw your schema, then throw your layout away. A desktop ERD tool that stores the diagram as local JSON tur...
July 9, 2026
Finding a Column Shouldn't Take a SQL Query
Millions of developers query information_schema just to find which table holds a column. A desktop ERD tool with fuzzy search across entity...
July 8, 2026
Your ERD Shouldn't Be Able to Just Disappear
Cloud diagram tools can lose your ERD - one day it is just gone from the list, and recovery means a support ticket or a paid tier. A local E...
July 7, 2026
Schemity vs ChartDB: When the Diagram Can't Go to the Cloud
Looking for a ChartDB alternative that works offline? Schemity is a desktop ERD tool with BYOK AI, plain JSON storage in Git, and a one-time...
July 6, 2026
Why No Two Tables in Your Schema Look Alike
Schema drift starts at the blank entity. How entity templates and convention-aware field placement in a desktop ERD tool keep every table co...
July 5, 2026
Documenting Your Production Database Shouldn't Feel Dangerous
How to document a production database schema without fear: a desktop ERD tool that connects through SSH tunnels, keeps passwords in your OS...
July 4, 2026
Your Client's Schema Doesn't Belong in Your Cloud Account
An ERD tool for consultants and client work: one workspace per client, stored as local folders you can hand over or delete when the engageme...
July 3, 2026
Stop Hand-Translating Between SQL and Your ERD
Generate an ERD from a SQL dump, import CREATE TABLE statements in one paste, and turn diagram edits into a reviewed migration SQL diff - al...
July 2, 2026
AI Help With Your Database Design, Without the Cloud
A BYOK ERD tool changes the deal: private AI database design with your own OpenAI, Claude, Gemini, or DeepSeek key. AI ERD without cloud acc...
June 8, 2026
You Cannot Judge Coupling and Cohesion From the Same View
Low coupling and high cohesion are two questions at two scales. See why the main ERD perspective and a database context view answer differen...
June 5, 2026
A View Owes You Back the Context It Removes
Database context views and ERD perspectives give focus by removing noise - but they also take. Here is what a sub-diagram in your ERD tool o...
April 12, 2026
You Have Been Reading ERD Notation Wrong
A complete ERD notation guide for crow's foot notation. Most tutorials explain the symbols - none explain how 1:N vs N:N relationships trans...
April 10, 2026
Design Data Model for Multi-Tenant RBAC
A step-by-step guide to designing a multi-tenant RBAC schema. Learn identity foundation patterns, N:N relationships for roles and permission...
April 1, 2026
Schemity vs dbdiagram.io: When Your ERD Tool Needs to Outlive the Meeting
Looking for a dbdiagram.io alternative? Schemity is an offline desktop ERD tool where your diagrams live as JSON in your Git repo - not on s...
March 31, 2026
ERD design with joy
Most database design tools treat schema work as a chore. What if a lightweight desktop ERD tool got out of the way - with ERD custom waypoin...
March 30, 2026
ERD tool built for software engineers who touch a database
Import a workspace from anywhere on your machine and treat your ERD like infrastructure - version-controlled in Git, reviewed in PRs, and ke...
March 15, 2026
Your ERD is hiding your domain model
ERD check constraints support turns your schema into living documentation. See how domain-driven design database schema patterns surface val...
March 15, 2026
Your ERD tool can't keep up with your thinking
The best ideas happen fast. Most ERD tools make you slow down. A lightweight desktop ERD tool built for the speed of thought - keyboard-firs...
March 14, 2026
The ERD that lives in your Git repo
Stop exporting PNGs to Confluence. A Git-native ERD tool stores your database diagrams as JSON files you can version control, review in PRs,...