![\"\"](\"https:\/\/truelogic.org\/wordpress\/wp-content\/uploads\/2012\/08\/socrates.jpeg\" "\\"socrates\\"")
<\/a>Socrates is a web based application which generates a database schema diagram. It is written in PHP and uses JQuery in the front end.<\/p>\nAll it requires as an input is your Mysql dump sql script. Just paste the sql and it generates a schema diagram. Simple and fast. Please note that this is a work in progress and I am in the process of adding in more features.<\/p>\n
WHY SOCRATES WAS MADE<\/h3>\n
As part of our documentation of projects, we are often needed to create database schema diagrams of our existing MySQL databases. Now the only way to do that is :<\/p>\n
- \n
- Use a commercial application\/tool which automatically creates a schema diagram<\/li>\n
- Create a schema diagram by hand by entering everything manually<\/li>\n<\/ul>\n
I did a lot of searching over the web to look for a free online tool which could immediately show me a schema diagram of my MySQL database, but there is nothing like that available. As a result I decided I would make an online application for this purpose.<\/p>\n
FEATURES IN VERSION 1.0 (Feb 19th, 2015)<\/h3>\n
- \n
- Ability to handle “CREATE IF NOT” table clause<\/li>\n
- Display foreign keys<\/li>\n
- Show relations between tables<\/li>\n<\/ol>\n
1.0 Screenshot:<\/p>\n
![\"2015-02-19](\"https:\/\/truelogic.org\/wordpress\/wp-content\/uploads\/2012\/08\/2015-02-19-15-24-59-620x453.png\")
<\/a><\/p>\n<\/p>\n
<\/p>\n
FEATURES IN VERSION 0.5 (Aug 2nd, 2012)<\/h3>\n
- \n
- Takes in a maximum of 750k characters for the sql dump input.<\/li>\n
- Parses the sql file to generate information about tables,fields and primary keys<\/li>\n
- Ability to extract table name, field info, default values and primary key info.<\/li>\n
- Shows the parsed information as a diagram.<\/li>\n
- The boxes in the diagram are draggable so that you can achieve your desired layout<\/li>\n<\/ol>\n
A sample screenshot of a Joomla CMS database schema is shown below:<\/p>\n
![\"\"](\"https:\/\/truelogic.org\/wordpress\/wp-content\/uploads\/2012\/08\/2012-08-02-23-49-47.png\" "\\"2012-08-02")
<\/a><\/p>\nEXPLANATION OF THE SCHEMA DIAGRAM<\/h3>\n
Each table is shown as a block. Within each table it shows<\/p>\n
- \n
- The table name<\/li>\n
- The field list. For each field it shows the name, field type and default value if any<\/li>\n
- If a field is part of a primary key it is marked as (P)<\/li>\n
- If a field is allowed to have a null value is marked with an N<\/li>\n
- If a field is defined as a foreign key from another table , it is marked with (F)<\/li>\n<\/ul>\n
SAVE THE DIAGRAM AS A SCREENSHOT<\/h3>\n
Since its not possible for any server-side language to save a web page as an image, without using external server hosted applications, I would recommend that you install any of the several free browser-addons which lets you save the current page in the browser as an image. Any of these add-ons would save the entire diagram as an image.<\/p>\n
WHAT NEXT<\/h3>\n
As mentioned before, this is a work in progress, so I will be continually adding more features. I am particularly aiming to automatically show foreign key linkages using connectors between the blocks as thats something which is very useful.<\/p>\n
I would be very interested in your feedback and comments on any bugs or ideas that you want to convey.<\/p>\n
Click Here To Use Socrates<\/a><\/h2>\n","protected":false},"excerpt":{"rendered":"