MySQL 可视化数据库架构的好工具？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/433071/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Good tool to visualise database schema?
提问by Mat
Are there any good tools for visualising a pre-existing database schema? I'm using MySQL if it matters.
是否有任何用于可视化预先存在的数据库模式的好工具？如果重要的话，我正在使用 MySQL。
I'm currently using MySQL Workbench to process an SQL create script dump, but it's clunky, slow and a manual process to drag all the tables about (which would be okay if it wasn't so slow).
我目前正在使用 MySQL Workbench 来处理 SQL 创建脚本转储，但它笨重、缓慢，并且需要手动拖动所有表（如果它不是那么慢也没关系）。
采纳答案by rkj
I found SchemaSpyquite good - you have to run the script every time schema changes but it is not so big deal.
我发现SchemaSpy非常好 - 每次架构更改时都必须运行脚本，但这没什么大不了的。
As pointed out in the comments there is also a GUIfor it.
正如评论中所指出的，它还有一个GUI。
Another nice tool is SchemaCrawler.
另一个不错的工具是SchemaCrawler。
回答by Hons
回答by Ethan
I like this tool, called simply DbSchema. It's written in Java so it runs on OS X, Windows, or Linux. It's a little clunky, especially when it comes to printing, but from my experience they're all like that. This one is the best of the several I've tried. It makes nice, clear diagrams. Free trial. Costs about $120 depending on how many licenses you buy.
我喜欢这个工具，简称为DbSchema。它是用 Java 编写的，因此可以在 OS X、Windows 或 Linux 上运行。这有点笨拙，尤其是在打印方面，但根据我的经验，它们都是这样。这是我尝试过的几种中最好的。它制作精美、清晰的图表。免费试用。费用约为 120 美元，具体取决于您购买的许可证数量。
回答by Ethan
on Mac OS X you can use Sequel Pro
在 Mac OS X 上你可以使用Sequel Pro
回答by Kb.
I would recommend Toad data modeller
我会推荐Toad 数据建模器
回答by Marc Novakowski
How about the SQuirreL SQL Client? As mentioned in another SO question, this programs has the capability to generate a simple ER diagram.
怎么样了SQuirreL SQL客户端？正如在另一个 SO 问题中提到的，这个程序能够生成一个简单的 ER 图。
回答by Marc Novakowski
DeZign for Databasesmight be interesting for you. You can reverse engineer and modify existing databases. Has got an auto-layout function and diagram layout is not meshed up when synchronizing your data model with the database.
DeZign for Databases可能对您感兴趣。您可以逆向工程和修改现有数据库。具有自动布局功能，并且在将数据模型与数据库同步时不会将图表布局网格化。
回答by Brian Fisher
Have you tried the arrange > auto arrange function in MySQL Workbench. It may save you from manually moving the tables around.
您是否尝试过 MySQL Workbench 中的排列 > 自动排列功能。它可以使您免于手动移动表格。
回答by ConcernedOfTunbridgeWells
Visio professionalhas a database reverse-engineering tool built into it. You should be able to use it with MySQL through an ODBC driver. It works best when you reverse engineer the database and then create the diagrams by dragging them off the tables and views panel. It will drag any foreign key objects and put them on the diagram as well.
Visio Professional内置了一个数据库逆向工程工具。您应该能够通过 ODBC 驱动程序将它与 MySQL 一起使用。当您对数据库进行逆向工程，然后通过将它们拖出表和视图面板来创建图表时，它的效果最佳。它将拖动任何外键对象并将它们也放在图表上。
回答by mj41
I'm start to create own Perl script based on SQL::Translator module (GraphViz). Here are first results.
我开始基于 SQL::Translator 模块（GraphViz）创建自己的 Perl 脚本。这是第一个结果。
