open Skype DB with history and remove some items (Mac OS)

skype_history.sh

# shutdown Skype
# Skype username - it's a login at Skype
# Mac username - it's a short username of Mac OS X (ex.: dive)
# <...> should be entered without brackets <>

#copy this one, paste to Terminal.app and hit Enter
sqlite3 "$HOME/Library/Application Support/Skype/<your_skype_username>/main.db"

#then copy this one, paste to Terminal.app where sqlite3 running and hit Enter
delete from Messages where dialog_partner = '<delete_history_of_conversation_with_particurarly_username>';

#done
#if you want to remove history with another username, just hit Up arrow and replace username

Ах да, я лох.

This is my script, firstly close Skype, then all message in a conversation. You can adjust the sql query according to your purpose.

1. Create a file and paste below content, save it with .sh extension
2. Edit skype_login_name to yours, adjust the sql query according to your purpose then save the file
3. Execute the script in terminal

SkypePid=$(pgrep Skype)
kill $SkypePid
sqlite3 "$HOME/Library/Application Support/Skype/<skype_login_name>/main.db" <<EOS
delete from main.messages where chatname = '19:83e9be70b7ec4202ae8c158527374401@thread.skype';

commit;

.exit

EOS