Search code examples
messagearchiveskype

Read skype message archive

I would like to read my skype message archive outside of the Skype app. And be able to export it in some sort (other than copy-paste it from my messages) as far i can figure skype only provides 30 days or archives.

Any one out there using an app for archiving / exporting Skype messages?

Solution

  • You can also look at skype's profile database (%USERDIR%\Application Data\Skype\%your profile name%\main.db) which is basically SQLite database and see what you can get from it. If you are using Windows 8 and above the path is %USERDIR%\AppData\Local\Packages\Microsoft.SkypeApp\Localstate\ %your_skype_profile_name%\main.db

    I'll give you a hit about tables:

    • "Conversations" - a conversation
    • "Messages" linked to "Conversations" via convo_id field
    • "Chats" - a list of saved chats, each chat is composed of conversations
    • "ChatMembers" - members of chat(s)

    The tables are quite wide and usage of some fields is not that obvious, but I think you get the idea.