SchemaCrawler 是一个免费的开源工具，可以在 GraphViz 的帮助下生成 ER 图。 您可以使用正则表达式来选择要显示的表和列。 关系是从常用的命名约定推断出来的。
SchemaCrawler is a free, open source tool that can generate E-R diagrams, with the help of GraphViz. You can use regular expressions to select the tables and columns you want to display. Relationships are inferred from commonly used naming conventions.
I've had some success using two commercial (but relatively cheap!) tools- but I still haven't found any really solid open source ones after months of looking.
MyEclipseIDE is a subscription product, I think it's around $60 a year. It's a set of bundled plugins for Eclipse, one of them is an ERD analyzer that works OK. If you're programming in Java (or another eclipse-supported language), it may be worth it.
SQLMaestro for MySQL: This one is a bit more expensive, with a $99 noncommercial / $179 single seat license. The ERD it generates is much better, and it provides other tools that make it easier to administer and maintain a more complex schema.
My understanding is that MySQL Workbench is still under active development, but they've been banging on it for a long time without really wrapping it up. Maybe now that Sun owns them, they'll get it together.
我正在使用 Mysql Workbench 6.1。 默认情况下，对于大量表，图表看起来会很拥挤，从而很难弄清楚表之间的关系。 许多表格会覆盖在其他表格上。 这是因为，默认布局尺寸很小。
在菜单中，转到模型 >> “图表属性和大小”。
将宽度和大小更改为较大的值（例如宽度 23 和高度 5） -
然后在菜单中，转到排列>> 自动布局。
现在我们应该看到一个包含所有关系的清晰图表。 现在我们可以重新调整宽度和高度，更有意义
I am using Mysql Workbench 6.1. By default the diagram will look crunched for large number of tables, making it difficult to figure out relationship between tables. Many tables will overlay on other tables. This is because, the default layout size is small.
In the menu, Go to Model >> "Diagram properties and size".
Change width and size to some thing big (for example width 23 and height 5) -
Then in the menu, Go to Arrange >> Autolayout.
Now we should see a clean diagram with all the relations. Now we can re-adjust width and height, more meaningfully
发布评论
评论（7）
您可以查看 DBDesigner ...
现在称为 MySQL Workbench
http://dev.mysql。 com/downloads/workbench/5.0.html
You might check out DBDesigner ...
Now known as MySQL Workbench
http://dev.mysql.com/downloads/workbench/5.0.html
SchemaCrawler 是一个免费的开源工具，可以在 GraphViz 的帮助下生成 ER 图。 您可以使用正则表达式来选择要显示的表和列。 关系是从常用的命名约定推断出来的。
SchemaCrawler is a free, open source tool that can generate E-R diagrams, with the help of GraphViz. You can use regular expressions to select the tables and columns you want to display. Relationships are inferred from commonly used naming conventions.
我使用两个商业（但相对便宜！）工具取得了一些成功，但经过几个月的寻找，我仍然没有找到任何真正可靠的开源工具。
我的理解是，MySQL Workbench 仍在积极开发中，但他们已经研究了很长时间，但没有真正完成它。 也许既然Sun 拥有了它们，它们就会整合在一起。
I've had some success using two commercial (but relatively cheap!) tools- but I still haven't found any really solid open source ones after months of looking.
My understanding is that MySQL Workbench is still under active development, but they've been banging on it for a long time without really wrapping it up. Maybe now that Sun owns them, they'll get it together.
查看 Vertabelo。
它是一个在 Chrome 浏览器下工作的在线数据库建模器。
它为您提供：
而且它是免费的。
Check out Vertabelo.
It's an online database modeler that works under Chrome browser.
It provides you with:
Moreover it's free of charge.
使用 PHPMyAdmin 生成 ERD 也是一个更好的选择。 PHPMyadmin 从 3.4 版本开始添加了此功能
生成 ERD 的详细步骤： http://goo.gl/0z3vFE
您可以参考到 PHPMyAdmin 文档了解更多信息： http://www.phpmyadmin.net/documentation/#pmadb
Generate ERD with PHPMyAdmin is also a better option. PHPMyadmin added this functionality from version 3.4
detail step to generate ERD : http://goo.gl/0z3vFE
You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb
我正在使用 Mysql Workbench 6.1。 默认情况下，对于大量表，图表看起来会很拥挤，从而很难弄清楚表之间的关系。 许多表格会覆盖在其他表格上。 这是因为，默认布局尺寸很小。
在菜单中，转到模型 >> “图表属性和大小”。
将宽度和大小更改为较大的值（例如宽度 23 和高度 5） -
然后在菜单中，转到排列>> 自动布局。
现在我们应该看到一个包含所有关系的清晰图表。 现在我们可以重新调整宽度和高度，更有意义
I am using Mysql Workbench 6.1. By default the diagram will look crunched for large number of tables, making it difficult to figure out relationship between tables. Many tables will overlay on other tables. This is because, the default layout size is small.
In the menu, Go to Model >> "Diagram properties and size".
Change width and size to some thing big (for example width 23 and height 5) -
Then in the menu, Go to Arrange >> Autolayout.
Now we should see a clean diagram with all the relations. Now we can re-adjust width and height, more meaningfully
我使用 dbeaver 它可以管理 mysql 和许多其他东西，如 postgresql
有用的链接：
https://dbeaver.com/docs/wiki/Database-Structure-Diagrams/< /a>
I use dbeaver which can manage mysql and many others like postgresql
Useful link :
https://dbeaver.com/docs/wiki/Database-Structure-Diagrams/