1

I Am looking for a open source windows 7 application for visualizing my mysql database.

I have a sql file (more than 250MB) which have query to create database, which i should load in the application and database schema should be displayed in graphical or pictorial representation.
As this file is huge i cannot upload on internet, so i am looking for windows application.

Are there any applications for this?

  • Navicat is the best I used so far – bantandor Mar 19 '16 at 8:34
5

There are plenty of these, and G.I.Y.F. But, what's wrong with the classic MySql workbench?

In addition to allowing you to graphically create a new data base schema (and generate code to create it), it will import from an existing database and allow you to examine it's structure.

This is the standard tool for all MySql manipulation, from the developers of MySql itself. I have tried others, but always come back to this.

enter image description here

  • Thanks for suggestion, i am using Mysql Workbench 6.3.6 and i connected to a database but iam not able to get ER diagram of that database . Could you tell me how to get it. +1 – ގαиDΣΣP Mar 19 '16 at 8:17
  • 1
    I got the answer here. – ގαиDΣΣP Mar 19 '16 at 8:39
1

MysqlWorkbench

Or you could try Toad for Mysql

Both are free and in both you can see either data or schema details, modifying either in a tabular interface. MySqlWorkbench has a modeling interface which may meet the graphical requirement that you are wanting. My preference is MySqlWorkbench. If you are writing queries and not a Sql scripting flyer you might find Toad more friendly but I dont think there are the modeling aspects. Good Luck.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.