# Visual DB Modelling on Mac **URL:** \ **Category:** Rails\ **Created:** [August 22, 2006, 1:08am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870 "2006-08-22T01:08:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 22, 2006, 1:08am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/1 "2006-08-22T01:08:45Z")
Since most of the rails developers seem to use macs, could someone possibly suggest a good visual db modelling tool to use along with rails and MySQL? So far I’ve already tested the absolutely unsuable Workbench as well as dbSketch, which was not adequate either. The tool needn’t be free, as long as it is stable, works with MySQL and has a trial version. Thanks in advance, ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 22, 2006, 1:24am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/2 "2006-08-22T01:24:46Z")
DBVisualizer, from minq.se Its java, so you’ll need your MySQL jdbc driver, but I use this to visualize all my tables as well as keep a history of my commands etc. On 8/21/06, Molotoff [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Thanks in advance, > > > – - Nic ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 22, 2006, 3:00am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/3 "2006-08-22T03:00:53Z")
YourSQL is great for basic stuff: [http://yoursql.ludit.it](http://yoursql.ludit.it) Navicat is great for advanced stuff (like building complex queries visually): > **[Navicat GUI | DB Admin Tool for MySQL, Redis, PostgreSQL, MongoDB, MariaDB,...](https://www.navicat.com/en/)** > > Powerful database management & design tool for Win, macOS & Linux. With intuitive GUI, user manages MySQL, Redis, PostgreSQL, MongoDB, MariaDB, SQL Server, Oracle & SQLite DB easily. It also helps to know that a lot of “important” folks (including Apple) use Navicat: [http://www.navicat.com/user\_stories.html](http://www.navicat.com/user_stories.html) Cheers, Joannou. We have 17,000 applicants for 1,000 retail positions. It’s harder to get a job at an Apple Store than it is to get admitted to Stanford University. - Ron Johnson, Senior Vice President of Retail, Apple Computer, Inc. ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 22, 2006, 3:46am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/4 "2006-08-22T03:46:55Z")
I think he was looking for an ER diagraming tool. The Macintosh world is distressing lacking in this area right now. ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 22, 2006, 9:35am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/5 "2006-08-22T09:35:24Z")
try [http://visualizemodels.rubyforge.org/](http://visualizemodels.rubyforge.org/) which requires [pixelglow | graphviz](http://www.pixelglow.com/graphviz/) pt. On 8/21/06, Molotoff [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Thanks in advance, > > > – Parker T. > **[ParkErt.com is for sale | HugeDomains](https://www.hugedomains.com/domain_profile.cfm?d=parkert.com)** > > Join thousands of people who own a premium domain. Affordable financing available. 510.541.0125 ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 24, 2006, 3:12am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/6 "2006-08-24T03:12:53Z")
Thank you, guys for your help! XERD is not mentioned anymore on its developer’s site - it seems to have suffered some sort of data loss, the current version at VersionTracker is reported to have some crashing issues. Guess, I will stick with DBVisualizer - it seems pretty adequate. ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 23, 2006, 5:13pm UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/7 "2006-08-23T17:13:46Z")
On 22-aug-2006, at 0:54, Molotoff wrote: > has a trial version. > The only promising tool in this area was called XERD. Don’t know how > far it went though. – Julian ‘Julik’ Tarkhanov please send all personal mail to me at julik.nl ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 24, 2006, 11:35pm UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/8 "2006-08-24T23:35:20Z")
I’ve not used it on a Mac, but DataArchitect is pretty nice: [http://www.thekompany.com/products/dataarchitect](http://www.thekompany.com/products/dataarchitect) On 8/21/06, Molotoff [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Thanks in advance, > > > – Larry W. [http://www.approachingnormal.com](http://www.approachingnormal.com) [http://www.welcometoparenthood.com](http://www.welcometoparenthood.com) ---
**Author:** ![molotoff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@molotoff](https://www.ruby-forum.com/u/molotoff)\ **Post date:** [August 24, 2006, 6:57am UTC](https://www.ruby-forum.com/t/visual-db-modelling-on-mac/65870/9 "2006-08-24T06:57:12Z")
On 23/08/06, Molotoff [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Guess, I will stick with DBVisualizer - it seems pretty adequate. ## You might want to consider OmniGraffle, from the Omni Group. Although it is a general diagramming tool – sort of like Visio, it includes a template for E-R diagrams and there’s a MySQL one available. Cheers, Hasan D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)