I'm using Ubuntu 12.04 LTS and Skype 4.3 on my machine. I've taken a file named main.db from the location on my machine ~/.Skype/SKYPEUSERNAME/

Now I want to see the chat history from that file with each of the contact. For it I installed Sqliteman but I'm still not able to see the chatr history. Can someone please provide me the easiest though effective solution for this issue? Thanks in advance.


Messages are stored as XML in messages table. You may use a simple SQL command to extract need dialog:

sqlite3 .Skype/yourusername/main.db "select timestamp,body_xml from messages where dialog_partner=\"partnerusername\";"

As you may use Sqliteman to run same command:

select timestamp,body_xml from messages where dialog_partner="partnerusername";
  • 3
    instead of timestamp use datetime(timestamp, 'unixepoch') as date, otherwise +1 as it fixes the bug in the skype client which shows empty history for all contacts – Gabor Apr 9 '15 at 12:41
  • 1
    Also I'd include the author field to get a log with proper sender per message – Treviño Dec 4 '15 at 16:58
  • What about chat groups? How can you correctly indentify them? – tigerjack89 Dec 7 '15 at 11:01
  • 1
    At least on my main.db, the table is Messages (with a capital), not messages (all lower case). I use: sqlite3 -csv main.db "select datetime(timestamp,'unixepoch'),dialog_partner,body_xml from Messages where dialog_partner != \"\";" > Skype_messages.csv – qwa Mar 26 '17 at 20:48

Not the answer you're looking for? Browse other questions tagged or ask your own question.