blocks|key|1439239|text|我发现SchemaSpy非常好-每次模式更改时都必须运行脚本，但这没什么大不了的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439240|正如评论中指出的，它也有一个GUI。|1439241|另一个很好的工具是SchemaCrawler。|1439242|entityMap|0|LINK|mutability|MUTABLE|url|http://schemaspy.sourceforge.net/|1|http://www.joachim-uhl.de/projekte/schemaspygui/|2|https://www.schemacrawler.com/^0|3|9|0|0|E|3|1|0|9|D|2|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|H|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]|R|$5|K|L|M|C|$N|S]]]]

I found <a href="http://schemaspy.sourceforge.net/" rel="nofollow noreferrer">SchemaSpy</a> quite good - you have to run the script every time schema changes but it is not so big deal.
As pointed out in the comments there is also a <a href="http://www.joachim-uhl.de/projekte/schemaspygui/" rel="nofollow noreferrer">GUI</a> for it.
Another nice tool is <a href="https://www.schemacrawler.com/" rel="nofollow noreferrer">SchemaCrawler</a>.

blocks|key|1654610|text|我通常使用SchemaSpy来做这件事，但最近我在sqlfairy上找到了一篇非常简单的文章，它只是使用转储文件来创建结构图|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654611|entityMap|0|LINK|mutability|MUTABLE|url|http://nsaunders.wordpress.com/2009/01/11/easy-visualisation-of-database-schemas-using-sqlfairy/^0|P|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I usually use SchemaSpy to do this, but recently I found a really simple article on <a href="http://nsaunders.wordpress.com/2009/01/11/easy-visualisation-of-database-schemas-using-sqlfairy/" rel="noreferrer">sqlfairy</a> that just uses the dump file to create the structure graph

blocks|key|1654145|text|我喜欢这个简单的叫做DbSchema的工具。它是用Java编写的，所以它可以在OS+X、Windows或Linux上运行。它有点笨拙，特别是在打印方面，但根据我的经验，它们都是这样的。这个是我试过的几个中最好的一个。它可以制作出漂亮、清晰的图表。免费试用。根据您购买的许可证数量，价格约为120美元。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654146|entityMap|0|LINK|mutability|MUTABLE|url|http://www.dbschema.com/index.html^0|A|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I like this tool, called simply <a href="http://www.dbschema.com/index.html" rel="noreferrer">DbSchema</a>. 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.

blocks|key|1654683|text|在Mac上，您可以使用Sequel+Pro|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654684|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sequelpro.com/^0|B|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

on Mac OS X you can use <a href="http://www.sequelpro.com/" rel="noreferrer">Sequel Pro</a>

blocks|key|1653887|text|我推荐Toad+data+modeller|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1653888|entityMap|0|LINK|mutability|MUTABLE|url|http://modeling.inside.quest.com/index.jspa^0|3|I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I would recommend <a href="http://modeling.inside.quest.com/index.jspa" rel="nofollow noreferrer">Toad data modeller</a>

blocks|key|1654004|text|那SQuirreL+SQL+Client呢？正如在another+SO+question中提到的，这个程序能够生成一个简单的ER图。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654005|entityMap|0|LINK|mutability|MUTABLE|url|http://squirrel-sql.sourceforge.net/|1|https://stackoverflow.com/questions/408489/anyone-know-of-a-decent-free-db-schema-reverse-engineering-tool#408495^0|1|J|0|P|J|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

How about the <a href="http://squirrel-sql.sourceforge.net/" rel="nofollow noreferrer">SQuirreL SQL Client</a>? As mentioned in <a href="https://stackoverflow.com/questions/408489/anyone-know-of-a-decent-free-db-schema-reverse-engineering-tool#408495">another SO question</a>, this programs has the capability to generate a simple ER diagram.

blocks|key|1653952|text|您是否尝试过MySQL工作台中的排列>自动排列功能。它可以使您不必手动移动桌子。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1653953|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Have you tried the arrange > auto arrange function in MySQL Workbench. It may save you from manually moving the tables around.

blocks|key|1439402|text|您可能会对DeZign+for+Databases感兴趣。您可以对现有数据库进行反向工程和修改。具有自动布局功能，并且在将数据模型与数据库同步时，图表布局不会网格化。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439403|entityMap|0|LINK|mutability|MUTABLE|url|http://www.datanamic.com/^0|5|K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.datanamic.com" rel="nofollow noreferrer">DeZign for Databases</a> might 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.

blocks|key|1654186|text|我开始创建自己的基于SQL::Translator模块(GraphViz)的Perl脚本。这里是first+results。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654187|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.taptinder.org/schema/^0|1C|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I'm start to create own Perl script based on SQL::Translator module (GraphViz). Here are <a href="http://dev.taptinder.org/schema/" rel="nofollow noreferrer">first results</a>.

blocks|key|1439651|text|一种不同的方法，但如果您使用的是Ruby+on+Rails，请尝试RailRoad：http://railroad.rubyforge.org|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439652|entityMap|0|LINK|mutability|MUTABLE|url|http://railroad.rubyforge.org/^0|16|T|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

A different approach, but if you're using Ruby on Rails try RailRoad: <a href="http://railroad.rubyforge.org" rel="nofollow noreferrer">http://railroad.rubyforge.org</a>

blocks|key|1439816|text|我花了很长时间寻找一个像样的，最好是免费的linux工具，发现这个java应用程序非常好(终于！！)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1439817|http://sqldeveloper.solyp.com/|offset|length|1439818|作为Java，它是跨平台的(我在Linux上运行它没有任何问题)，它可以连接到任何可以获得JDBC驱动程序的数据库。例如：pretty+much+any+database。|1439819|导入数据库并获得数据库模式的可视化(ERM)非常容易。自动布局功能也很好，但请注意，它不是自动完成的，您需要在将对象导入到图表中之后单击"automatic+layout“按钮。|1439820|这个应用程序也是一个非常好的通用数据库管理/浏览工具。作为一个小示例，我使用它而不是pgadmin进行一些基础开发工作，因为它有一些简单的细节，比如SQL查询结果的列宽可以自动调整大小以适应内容(这让我在pgadmin中发疯)。|1439821|entityMap|0|LINK|mutability|MUTABLE|url|1|http://developers.sun.com/product/jdbc/drivers/|2|http://en.wikipedia.org/wiki/Entity-relationship_model^0|0|0|U|0|0|1P|O|1|0|I|3|2|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|J|3|K|5|6|7|19|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|C]]|S|$5|O|P|Q|A|$R|T]]|U|$5|O|P|Q|A|$R|V]]]]

I looked for a long time for a decent, and preferably free, tool for linux and found this java application that is quite good (finally!!):

<a href="http://sqldeveloper.solyp.com/" rel="nofollow">http://sqldeveloper.solyp.com/</a>

Being Java it is cross-platform (I run it on Linux with no issues) and it will connect to any database you can get a JDBC driver for. ie: <a href="http://developers.sun.com/product/jdbc/drivers/" rel="nofollow">pretty much any database</a>.

It is quite easy to import your database and get a visual (<a href="http://en.wikipedia.org/wiki/Entity-relationship_model" rel="nofollow">ERM</a>) of the database schema. The auto-layout feature is good as well, but note that it is not done automatically and you need to click the "automatic layout" button after importing your objects into the diagram.

The application is also a pretty good generic database administration/browsing tool. As one small example, I use it instead of pgadmin for some base development work because of simple niceties like the column width of SQL query results automatically sizing to fit content (which drives me crazy in pgadmin).

blocks|key|1439531|text|我在DBIx::Class中使用SQL::Translator|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439532|我的工具链中无论如何都有DBIx::Class，通过将它与SQL::Translator结合使用，我可以将模式转换为许多不同的格式。主要是为不同的数据库服务器初始化SQL脚本(这使得在SQLite上开发和转移到Postgresql上进行生产变得很容易)，但它也可以输出GraphViz数据，所以生成图表是很容易的。|1439533|entityMap|0|LINK|mutability|MUTABLE|url|http://search.cpan.org/dist/DBIx-Class/|1|http://search.cpan.org/~jrobinson/SQL-Translator-0.09007/lib/SQL/Translator.pm^0|2|B|0|G|F|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

I use <a href="http://search.cpan.org/~jrobinson/SQL-Translator-0.09007/lib/SQL/Translator.pm" rel="nofollow noreferrer">SQL::Translator</a> with <a href="http://search.cpan.org/dist/DBIx-Class/" rel="nofollow noreferrer">DBIx::Class</a>

I have DBIx::Class in my toolchain anyway, and combining it with SQL::Translator allows me to convert the schema into lots of different formats. Mostly initialization SQL scripts for different database servers (making it easy to develop on SQLite and move to Postgresql for production) but it can output GraphViz data too, so diagrams are trivial to generate.

blocks|key|1439605|text|ER/Studio+by+Embarcadero是成本较高的模式之一，但它所呈现的分层模式是迄今为止理解数据库模型的最佳模式。它使得编写查询成为世界上最简单的任务。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1439606|它在规范化、反规范化、仓储、文档等方面也令人难以置信。|1439607|缺点是它是一个非常昂贵的工具，特别是当你进入多平台的时候。|1439608|entityMap|0|LINK|mutability|MUTABLE|url|http://www.embarcadero.com/products/er_studio/^0|0|O|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

<a href="http://www.embarcadero.com/products/er_studio/" rel="nofollow noreferrer">ER/Studio by Embarcadero</a> is one of the costlier ones, but the hierarchical mode it present is by far the best one for understanding database models. It makes query writing the easiest task in the world.

It also is incredible with normalization, denormalization, warehousing, documentation, etc.

The downside is that it is a pretty expensive tool especially when you go multiplatform.

blocks|key|1654469|text|Adminer+(以前的phpMinAdmin)是用于管理MySQL数据库的web应用程序，它可以绘制简单的图表。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654470|该软件本身类似于phpMyAdmin，但有更多的功能，它的轻量级，它是在一个单独的PHP文件。|1654471|​|1654472|📷|atomic|1654473|entityMap|0|LINK|mutability|MUTABLE|url|https://www.adminer.org/en/|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/e22bc0524410c62ea9398154d9f764f0.png|imageAlt^0|0|7|0|0|0|0|0|1|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|K|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|T|O|U|C|$V|W|X|-4]]]]

<a href="https://www.adminer.org/en/" rel="nofollow noreferrer">Adminer</a> (formerly phpMinAdmin), the web application for managing MySQL databases, draws simple diagram. 

The software itself is similiar to phpMyAdmin, but has more features, its lightweight and it comes in single PHP file.

<a href="https://i.stack.imgur.com/hGGfY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hGGfY.png" alt="alt text"></a>

blocks|key|1653864|text|当您说可视化数据库架构时，您是指所有表、sprocs等的文本文档，还是指架构和依赖项的可视化表示？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1653865|我知道你提到了MySQL+(现在很有可能支持它，但我不确定)，但RedGate有很多工具可以让这一切变得非常简单。它的SQL文档程序可以获取您的整个数据库，并为其创建完整的数据库文档。SQL+Dependency+Tracker可以为您提供所有表的可视化表示，并显示它们的链接，或者您可以仅加载某些表或存储过程，以显示它们正在使用的内容或它们本身正在使用的内容。|1653866|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

When you say visualize the database schema, are you referring to a text-document of all your tables, sprocs, etc., or are you referring to a visual representation of your schema and dependencies? 

I know you mentioned MySQL (and it is very possible that it is supported now, but I am not sure), but RedGate has a number of tools that make that pretty simple. It's SQL Doc program can take your entire database and create full-blown database documentation for it. SQL Dependency Tracker can give you a visual representation of all your tables and show their linkings, or you can load in just certain tables or sprocs to show what is using them or what they are using themselves.

blocks|key|1439366|text|几年前，我经常使用数据架构师。我不知道它是否还在那里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1439367|您可以将现有架构反向工程到关系表关系图中。|1439368|或者您可以走得更远，使用附图对实体关系模型进行逆向工程。在与既不是程序员也不是数据库专家的人讨论数据时，ER图对我来说真的很有用。|1439369|有时，在ER模型和ER图成为与利益相关者的有用沟通工具之前，有必要对其进行一些手动修复。|1439370|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Years ago, I used to use Data Architect. I don't know if it's still out there. 

You could reverse engineer an existing schema into a relational table diagram. 

Or you could go even further, and reverse engineer an Entity-Relationship model with an accompanying diagram. ER diagrams were really useful to me when discussing the data with people who were neither programmers nor database experts. 

Sometimes a few manual fixups to the ER model and ER diagram were necessary before it was a useful communication tool with stakeholders.

blocks|key|1654222|text|SchemaBall正在以自己有趣的方式进行可视化。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1654223|entityMap|0|LINK|mutability|MUTABLE|url|http://mkweb.bcgsc.ca/schemaball/^0|0|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://mkweb.bcgsc.ca/schemaball/" rel="nofollow noreferrer">SchemaBall</a> is doing visualisation its own interesting way.

blocks|key|1439898|text|我试过DBSchema了。功能不错，但对于一个有大约75个表的数据库来说，速度太慢了。无法使用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1439899|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I tried DBSchema. Nice features, but wildly slow for a database with about 75 tables. Unusable.

blocks|key|1439942|text|试试PHPMyAdmin，它有一些非常好的可视化和编辑功能。我很确定你甚至可以从它导出到exel。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1439943|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try PHPMyAdmin which has some really nice visualisation and editing feature. I am pretty sure you can even export to exel from it.

Are there any good tools for visualising a pre-existing database schema? I'm using MySQL if it matters.

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).

Good tool to visualise database schema?

数据库管理

数据架构

SQL数据库

服务器

数据库

Windows

SQLite

MySQL

Linux

Java

Perl

有没有什么好的工具来可视化一个已经存在的数据库模式？如果重要的话，我会使用MySQL。我目前正在使用处理MySQL create脚本转储，但它笨重、缓慢，而且需要手动拖动所有的表(如果它不是很慢的话就可以了)。

问可视化数据库模式的好工具？
EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问可视化数据库模式的好工具？EN

回答 19

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问可视化数据库模式的好工具？
EN