top | item 47157322

(no title)

siriusastrebe | 4 days ago

This is awesome! You could probably incorporate a graph visualizer to map out all the table relations (which could be a good selling visual).

How does it distinguish which tables have foreign keys to other tables? Can with work without defining constraints?

discuss

order

Gordiny|4 days ago

Thanks! A graph visualizer is interesting, but it’s not really the goal here. There are already good tools that map entire schemas. DBTree is more about focused, node-by-node data exploration, without loading or visualizing everything upfront.

It relies on actual foreign key constraints. If there’s no FK defined, it won’t infer the relationship. The chevron is shown based on those constraints, and the related rows are only queried when you expand the node, which keeps performance under control.