3

Our application has a fairly large, sprawling DB design, with 175 tables. Most tables are used by one or two primary features, and I'd like to create several little "mini-schemas" to describe the structure of different parts of the system to new hires (without showing them the gigantic total schema which is, frankly, so big as to be useless).

Since these are already-extant tables, I need a tool which will allow me to enter completely custom names for fields and specify connections myself (since some of our foreign keys don't follow the standard naming pattern).

What's the best cheap or free tool for this?

Bonus points if it allows custom colors to be selected for diagram elements (i.e., tables), since this would allow me to create a reassembled version of the schema for discussion of how the major systems interact.

Arkaaito
  • 7,347
  • 3
  • 39
  • 56

7 Answers7

4

Well, it doesn't do custom colors, but MySQL Workbench is a free database modelling tool provided by MySQL.

You can even set it up to reverse engineer a full schema diagram just by having it connect to your database. You could take it from there and partition out what you needed into separate modelling diagrams.

zombat
  • 92,731
  • 24
  • 156
  • 164
3

For any kind of graph drawing I really find it hard to beat the utility of Graphviz; but it'd require you to learn a new (and I use "learn" loosely here) language called "dot". The language is incredibly simple, and there's plenty of templates around for using it to document schemas.

On a side note, there's an excellent schema mapping tool which can infer connections based on column names that may get you pretty close to what you need, it's called SchemaSpy.

Mark Elliot
  • 75,278
  • 22
  • 140
  • 160
3

I enjoy the simplicity of WWW SQL Designer (Demo):

WWW SQL Designer

Glorfindel
  • 21,988
  • 13
  • 81
  • 109
Alix Axel
  • 151,645
  • 95
  • 393
  • 500
  • Sadly I don't find an option to save the diagram as an image (to put it on a word document for example), otherwise I'd give you a thumb up. – Ren Sep 29 '14 at 02:10
0

Try using SQLyog's Schema Designer. It is very simple and intuitive to use. Worth giving a try...

SQLyog's Schema Designer Screenshot

jsist
  • 5,223
  • 3
  • 28
  • 43
0

Check out this Open source Diagramming tool found here.

Here is another called DBDesigner found here.

Hope this helps.

Alexander
  • 23,432
  • 11
  • 63
  • 73
t0mm13b
  • 34,087
  • 8
  • 78
  • 110
0

I use Visio. It has a reverse engineer capability that allows you to point to an ODBC source and it will pull in the tables, views and store procedures as drawing elements. If the contraints are present, it will auto connet the tables via their relationship. want to draw a sub-schema, just select the tables you need during the extraction and viola! it also has multiple pages inside the drawing so you can have a master page with everything and subsequent pages with subschema details embedded.

You can also set line styles, fill styles and font styles too. And If you are on MSDN, you already have it...

MikeJ
  • 14,430
  • 21
  • 71
  • 87
  • Do many people on Windows use MySQL? – Chip Uni Jan 09 '10 at 03:35
  • I think mysql is used in more places than just the LAMP stack than people realize. We hook a lot of windows and java clients to mysql that started out as internal development systems in government. – MikeJ Jan 11 '10 at 12:43
0

1It is a very nice online tools you can use this http://creately.com/diagram-type/database-design .I am using this .It also gives the functionality to color database tables.

enter image description here

Muhammad Ashikuzzaman
  • 3,075
  • 6
  • 29
  • 53