Search through your whole skype history for any given term

skype-search

#!/usr/bin/ruby
# searches inside your whole skype history for a specific term
# usage: skype-search term
# don't forget to add inside any /bin directory (like /usr/bin or ~/bin) and do chmod +x skype-search
SKYPE_DB_PATH = "/Users/leandro/Library/Application Support/Skype/leandroico/main.db"
puts `sqlite3 -line '#{SKYPE_DB_PATH}' "SELECT author, from_dispname, datetime(timestamp, 'unixepoch') as date, body_xml FROM Messages where body_xml LIKE '%#{$*.shift}%' ORDER BY timestamp;"`

Search for multiple terms - also all bash:
https://gist.github.com/3909442
😉

I meant multiple terms which are not exactly in order.