how to create a mysql database schema visualization in ruby on rails.

how to create a mysql database schema vizualization.md

Step 1: Query the metadata

SELECT 
  table_schema
  ,TABLE_NAME
  ,COLUMN_NAME
  ,ordinal_position
  ,is_nullable
  ,data_type
  ,column_type
  ,column_key
  ,column_comment
FROM information_schema.columns
WHERE table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');