ActiveRecord extract database table information

ar_table_information.rb

require 'active_record'

ActiveRecord::Base.establish_connection(
 :host => "localhost",
 :user => "your_user",
 :adapter => "mysql2",
 :database => "your_database"
)

ActiveRecord::Base.connection.tables.each do |table_name|
  model_class = class_eval "class #{table_name.classify} < ActiveRecord::Base; set_table_name '#{table_name}'; end"
  puts table_name
  model_class.columns.each do |col|
    puts "#{col.name}: #{col.sql_type}"
  end
end

Quick and dirty way to extract columns / column type information from a MySQL database using ActiveRecord.