Schema ERD
Under Schema → Schema ERD, DB Studio renders an entity-relationship diagram of a connection's live schema, tables with columns (types, primary keys) and foreign-key relationships drawn as edges. It is a read-only snapshot laid out for exploration: to orient in an unfamiliar database, to see how tables relate before authoring a change, or to share a schema's shape.
Supported Dialects
- PostgreSQL (incl. CockroachDB, TimescaleDB)
- MySQL / MariaDB
- SQL Server, tables, columns (identity and full type formatting:
varchar(n),decimal(p,s)), primary keys, unique constraints, indexes, and cross-schema FK edges - SQLite
Document and graph stores (MongoDB, Neo4j, Redis) yield an approximate structural view rather than a relational ERD. On an unsupported dialect DB Studio names the supported set rather than failing silently.