开发者

Show SQL script using graphviz

开发者 https://www.devze.com 2023-01-18 02:01 出处:网络
I am looking for software can show SQL scripts (MySQL in my case) in visual way. Example every script is a circle in the diagra开发者_Go百科m.Similar to doxygen but for SQL scripts. An interesting, si

I am looking for software can show SQL scripts (MySQL in my case) in visual way. Example every script is a circle in the diagra开发者_Go百科m. Similar to doxygen but for SQL scripts.


An interesting, simple and funky visualisation of your db, literally in a circle: https://github.com/westonruter/schemagraph/blob/master/schemagraph.php A single php file which produces svg output.

A more comprehensive metadata query tool: http://schemaspy.sourceforge.net/ this gives you entity relationship diagrams and much more. There is a gui if that is your thing: http://www.joachim-uhl.de/projekte/schemaspygui/

I found but did not use: http://code.google.com/p/mysqlviz/


graphviz allows you to plot graph - if you have entities (Nodes) and connection between entities (Node). What this means is, if you could write a script which will split up sql to different units and relation , then you could create a .dot file use graphviz to create visual.


try http://schemaspy.sourceforge.net/ works well if you have foreigns keys, if not is useless.


it exist a plugin to symfony who make this. http://www.symfony-project.org/plugins/sfDoctrineGraphvizPlugin

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号