CODEWITHSUNDEEP
mysqldatabaseerd
Brock Boland
Brock Boland

Reputation: 16640

What tool can I use to build a nicely-formatted SQL DB diagram on a Mac?

I need to create an entity relationship diagram for a MySQL database. It doesn't need to be automatically generated or anything, and I don't have foreign keys defined anyway.

I could swear that I once used a tool that would display the relationships between fields, but this old screenshot from MS Access is the closest I've been able to find to what I'm trying to do (source: http://acdrupal.evergreen.edu/files/studycenter/database_entity_relationship_diagram.jpg).

MS Access Entity Relationship Diagram

Can anyone name an app (preferably for Macs) that can be used to build this kind of diagram? I've tried several of the popular ones - ArgoUML, OmniGraffle, MySQL Workbench - but it doesn't seem that any of them will show those relationship lines from one specific field to another. Instead, they have a generic one-to-one or many-to-one line that goes to the table, but not the specific field.

Upvotes: 1

Views: 1629

Answers (3)

Avi Flax
Avi Flax

Reputation: 51819

As of today (literally today, 2023-12-06) JetBrains’ IDEs such as IntelliJ IDEA, PyCharm, RubyMine, can do this. It’s pretty good too. NB: I think the feature might only available in the “pro” editions of these IDEs.

Upvotes: 0

Randy
Randy

Reputation: 16677

i like Visio for these drawings.

Upvotes: 0

stan229
stan229

Reputation: 2607

http://www.malcolmhardie.com/sqleditor/

This looks like it supports it if I understand what you need

Upvotes: 1

Related Questions