Sequel is a fantastic ORM available in Ruby.
It also comes with an
IRB console so it can be run directly from the command line with various options.
For example, to console into an SQLite database
testdb.sqlite in the current directory –
$> sequel sqlite://testdb.sqlite
Or for Postgres –
$> sequel postgres://dbuser:dbpassword@localhost/testdb
However, I use
sequel most frequently to take quick database backups or to restore them.