Schemadrop is a database schema editor built on a simple idea: the schema is text, and everything else is a projection of it.
You write DBML — a readable DSL for database schemas — and the ER diagram renders live next to your editor. Your team edits with you in real time, Figma-style. When you're ready, you export SQL DDL, a PNG, or publish an immutable release anyone can view.
Table users {
id uuid [pk]
email text [unique, not null]
}
Table posts {
id uuid [pk]
author_id uuid [not null]
}
Ref: posts.author_id > users.idMore on how it works in the docs.