Sorry if this is a bit off-topic, but I'd like to know if you can
recommend a tool to generate a graph of table/field relationships from
a given MySQL DB ?
I know MySQL Workbench does this, but it's been years since i've been
asked something like this, so there may be better tools that i
missed.
My only requirement is that it needs runs on Linux.
We have recently worked on a one-off tool for a specific customer that can generate such a graph from either foreign key relationships or from table and column naming conventions. It is not part of percona-toolkit and it is not generic/broadly usable, but it *can* be and it is a good start. https://code.launchpad.net/~percona-toolkit-dev/percona-toolkit/pt-ke...
> Sorry if this is a bit off-topic, but I'd like to know if you can > recommend a tool to generate a graph of table/field relationships from > a given MySQL DB ? > I know MySQL Workbench does this, but it's been years since i've been > asked something like this, so there may be better tools that i > missed.
> My only requirement is that it needs runs on Linux.
I've been using SchemaSpy (+ Graphviz) to generate full entity-relationship graphs. Very happy with the results, It produces HTML, CSS, Images + Imagemaps (giving you clickable interactive graphs).
You can view the entire schema graph (for me it's quite large - recommend viewing that graph in a tool that allows panning and zooming), click into individual tables, display tables with one or 2 degrees of separation, and get a lot of other information also.
> We have recently worked on a one-off tool for a specific customer that can generate such a graph from either foreign key relationships or from table and column naming conventions. It is not part of percona-toolkit and it is not generic/broadly usable, but it *can* be and it is a good start. > https://code.launchpad.net/~percona-toolkit-dev/percona-toolkit/pt-ke...
> On Apr 2, 2012, at 9:53 AM, Romain GUINOT wrote:
>> Hi guys,
>> Sorry if this is a bit off-topic, but I'd like to know if you can >> recommend a tool to generate a graph of table/field relationships from >> a given MySQL DB ? >> I know MySQL Workbench does this, but it's been years since i've been >> asked something like this, so there may be better tools that i >> missed.
>> My only requirement is that it needs runs on Linux.
>> Thanks for any input, >> Regards, >> Romain.
> -- > You received this message because you are subscribed to the Google Groups "Percona Discussion" group. > To post to this group, send email to percona-discussion@googlegroups.com. > To unsubscribe from this group, send email to percona-discussion+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
> I've been using SchemaSpy (+ Graphviz) to generate full entity-relationship graphs. Very happy with the results, It produces HTML, CSS, Images + Imagemaps (giving you clickable interactive graphs).
> You can view the entire schema graph (for me it's quite large - recommend viewing that graph in a tool that allows panning and zooming), click into individual tables, display tables with one or 2 degrees of separation, and get a lot of other information also.
> Regards,
> Morgan
> On 3/04/2012, at 2:08 AM, Baron Schwartz wrote:
> > We have recently worked on a one-off tool for a specific customer that can generate such a graph from either foreign key relationships or from table and column naming conventions. It is not part of percona-toolkit and it is not generic/broadly usable, but it *can* be and it is a good start.
> >https://code.launchpad.net/~percona-toolkit-dev/percona-toolkit/pt-ke...
> > On Apr 2, 2012, at 9:53 AM, Romain GUINOT wrote:
> >> Hi guys,
> >> Sorry if this is a bit off-topic, but I'd like to know if you can
> >> recommend a tool to generate a graph of table/field relationships from
> >> a given MySQL DB ?
> >> I know MySQL Workbench does this, but it's been years since i've been
> >> asked something like this, so there may be better tools that i
> >> missed.
> >> My only requirement is that it needs runs on Linux.
> >> Thanks for any input,
> >> Regards,
> >> Romain.
> > --
> > You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> > To post to this group, send email to percona-discussion@googlegroups.com.
> > To unsubscribe from this group, send email to percona-discussion+unsubscribe@googlegroups.com.
> > For more options, visit this group athttp://groups.google.com/group/percona-discussion?hl=en.
