List Databases

mssql_list_databases.rb

require 'activerecord-sqlserver-adapter'

ActiveRecord::Base.establish_connection(
  :adapter => 'sqlserver',
  :mode => 'ODBC',
  :host => '<server>',
  :username => '<user_name>',
  :password => '<pass>'
  :dsn => '<odbc_dsn_name>'
)

databases = ActiveRecord::Base.connection.select_all('select name from sys.databases')

postgres_list_databases.rb

require "rubygems"
require "active_record"
require 'logger'

ActiveRecord::Base.establish_connection(
                                        :adapter => 'postgresql',
                                        :database => '<db_name>',
                                        :username => '<user>',
                                        :password => '<pass>',
                                        :host => '/var/run/postgresql')

ActiveRecord::Base.logger = Logger.new('logfile.txt')
databases = ActiveRecord::Base.connection.query("select datname from pg_database")
#=> [["template1"], ["template0"], ["postgres"], ["testdb"]]