It correctly organizes them by conversation, and makes sure that group conversations do not get jumbled with one on one chats. This program allows you to view all of your skype chat logs and then easily export them as text files. This link includes a search command to pull up all the records for your conversations with your partner: The 'select timestamp,body_xml' is telling the database what you want to see (in this case, the timestamp of the message and the message body), 'from messages' tells it to search your messages table, and 'where dialog_partner=\'username\'' is telling it what conditions the records should match before it brings them back to you. Download and View Skype History Without Skype. In order to start using it, simply run the executable file - SkypeLogView.exe If Skype is installed on your system, SkypeLogView automatically detect the last used account, and loads the logs from it. Each table contains a bunch of different records that all represent the same thing - in this case, a bunch of records that represent your chat history with your partner. The workbook is the database itself, the pages are the database tables. A SQL database is like an excel workbook with multiple pages. I've never personally used sqlite, so unfortunately I'm no help there, but the gist of accessing SQL databases is that you use a command telling the database what you want to see and where to look. On the Skype menu window, there is a view option, click on that and select. The tab will emerge in the center of Skype window and includes a book icon. There is a history option, click on that. This page looks like it might have some ideas: īasically what you'll need is some way to access the database file. Click again on Skype or you can run Skype as per the version of Skype you use.