There’s no doubting the fact that Skype is the most amazing VoIP services around. Hundreds of millions of people use it everyday, and it’s supported by almost all mobile and desktop platforms. But just like many top notch tech solutions, Skype isn’t without its shortcomings. If you use Skype on Windows, you’d probably be aware that it doesn’t let you remove the chat history of a single contact only and the only (official) way is to delete it is by clearing the entire chat history from Preferences. You’re not completely out of luck though, as there is a way to delete Skype conversation of one user if you want. And in this guide we will show you how. So without any further ado, let’s get straight to it.
Skype basically stores all the text chats with contacts in the SQL database file called “main.db” which is stored inside the Roaming folder of Windows. This database file in fact also carries other information related to settings and options stored by the user. Fortunately, there’s a way to access this information via an open source tool called SQLite. Using this tool you can access the main database file and remove any non-required data entries.
Warning: Make sure to backup the “main.db” file before implementing the steps mentioned below. This file is located under C:\Users\’Windows_username’\AppData\Roaming\Skype\’skype_username’\
First off download SQLite Database Browser from Sourceforge and extract the contents of the ZIP archive to an easily accessible location. SQLite is a portable tool which means it runs without any installation.
Launch the program and navigate to ‘Open Database’ from ‘File’ menu as demonstrated in the screenshot below.
Now you need to browse to the ‘main.db’ database file that I mentioned earlier. Navigate to the following directory:
Select ‘main’db’ from the available files and click ‘Open’.
Within SQLite program, click ‘Browse Data’ tab, and under Table drop down menu click ‘Conversation’.
This will open the conversation data entries stored within the database pertaining to each user ID in your Skype contacts. This allows you to easily find the conversation you need to remove by identifying the user ID.
To delete an entry, all you need to do is click its related row followed by clicking ‘Delete Record’ at the top right. You can highlight and delete multiple records in a similar way. After deleting non-required entries, click Save on the toolbar and close SQLite.
It may sound like a lot of work but this is the only working way of deleting Skype conversation of a single contact. It should be noted that this method will only delete conversation history from your computer and not from the recipient’s system.