If you use the open-source diagram app Dia, there are several tools to generate Dia diagrams from SQL databases including MySQL and PostgreSQL.
update: MySQL Workbench 5.2 supports reverse-engineering diagrams from a live database in addition to an SQL script. MySQL Workbench 5.2 just announced their Release Candidate 1 (as of 5/12/2010).
SchemaSpy is a very good option for reverse engineering. For diagramming bit it uses another tool GraphViz. For everything to work together make sure GraphViz is installed and its path to its bin is accessible to the SchemaSpy.
发布评论
评论（5）
对于 MySQL，请尝试 MySQL Workbench。
对于 MySQL 和 PostgreSQL，请尝试 TOAD Data Modeler。
如果您使用开源图表应用程序Dia，则有几个工具，用于从 SQL 数据库（包括 MySQL 和 PostgreSQL）生成 Dia 图。
更新：除了 SQL 脚本之外，MySQL Workbench 5.2 还支持来自实时数据库的逆向工程图。 MySQL Workbench 5.2 刚刚宣布其候选版本 1（截至 2010 年 5 月 12 日）。
For MySQL, try MySQL Workbench.
For both MySQL and PostgreSQL, try TOAD Data Modeler.
If you use the open-source diagram app Dia, there are several tools to generate Dia diagrams from SQL databases including MySQL and PostgreSQL.
update: MySQL Workbench 5.2 supports reverse-engineering diagrams from a live database in addition to an SQL script. MySQL Workbench 5.2 just announced their Release Candidate 1 (as of 5/12/2010).
SchemaSpy 是逆向工程的一个非常好的选择。 对于图表位，它使用另一个工具 GraphViz。
为了使所有内容都能协同工作，请确保 GraphViz 已安装，并且 SchemaSpy 可以访问其 bin 的路径。
这是示例输出。
SchemaSpy is a very good option for reverse engineering. For diagramming bit it uses another tool GraphViz.
For everything to work together make sure GraphViz is installed and its path to its bin is accessible to the SchemaSpy.
Here is a sample output.
企业架构师
Enterprise Architect
我推荐DBeaver：多平台，免费，开源，连接最流行的数据库引擎并支持逆向工程。
我尝试过对 MySQL 数据库和 PostgreSQL 数据库进行逆向工程，效果非常好:)
I recommend DBeaver: multi-platform, free, open source, connects to most popular DB engines and supports reverse engineering.
I have tried reverse engineering both a MySQL DB and a PostgreSQL DB and it worked like a charm :)
用于 postgres 的 pgDesigner、用于 mysql 的 mysql 工作台...
pgDesigner for postgres, mysql workbench for mysql...