How can I read Skype log files (chatsync)?

Any SQLite interface can open the XXX.db file. I use SQLiteStudio.

The following query can be used to get all the chat messages you had with a given username. Replace andy in this example with the username you want.

select 
    chatname, 
    strftime('%Y-%m-%d', datetime(timestamp, 'unixepoch')) AS date, 
    from_dispname, 
    body_xml 
from 
    Messages 
where 
    chatname like "%andy%" 
order by 
    timestamp

SkypeLogView should do what you want.

SkypeLogView reads the log files created by Skype application, and displays the details of incoming/outgoing calls, chat messages, and file transfers made by the specified Skype account. You can select one or more items from the logs list, and then copy them to the clipboard, or export them into text/html/csv/xml file.

enter image description here


You can manually browse them using sqlite, the database used for storing the chats ( e.g.: sqlite foo.db ). Sqlitebrowser will make this process less tedious. You will need a complex sql command to sort and list them in chromological order. You can dump your queries from within sqlite directly to files, so I would use sqlite.