How to delete chat history of a particular user/contact in Skype [Solved]

Skype, one of the most used VOIP client software for communication inside organizations. One problem with this software is that: by default you can’t remove chat history for a specific contact. To delete chat history of a particular user/contact in your Skype, you have to use a DB browser software( sqlitebrowser ) to read the local DB files and make the changes. Follow the steps below to remove any history for a specific user from your system.

Note:
This removes the history form your local system; not from the other side of the Skype contact. So, he/she can see those from his/her computer.

Caution:
Take backup of main.db file before implementing anything from these steps.

Steps:

  • Download the DB Browser( SQLite Browser ). Its free and open source.
    You can get it from here: http://sourceforge.net/projects/sqlitebrowser/
  • Signout and Quit your Skype.
  • Go to the directory below and take a backup of the file main.db file. Just copy the directory itself or the file and keep it somewhere else for safety.

    Replace ‘skype_username’ with your skype user name in the above path.
  • Extract and run the sqlitebrowser software and open the Skype DB file(main.db) located here:
    C:Users’windows_username’AppDataRoamingSkype’skype_username’main.db
    Replace ‘skype_username’ with your skype user name in the above path.
  • – Click on the browse data tab. Here you can have all the tables that are being used to store history data in Skype.
    – Search the records by the particular user and delete those records. Mainly the chat related records reside inside ‘Chats’, ‘Messages. table.
    – Go to Browse data tab -> select table Messages -> click on find icon ->
    select author -> contains -> skype profile name of user you are searching for ->
    click on one of the last results in the list and you will see the row.
    – Select the records and click on ‘Delete Record’ button.
  • At last don’t forget to click on the save changes icon.

Open Skype and see the changes… Enjoy :)

sqlitebrowser[ Download sqlitebrowser: http://sourceforge.net/projects/sqlitebrowser/ ]

main_db_path

13 Comments

  1. Hi, This is Shravan. I want to delete a group in the contacts as well as its conversations for privacy. Could you please help me out in this scenario. I have gone thrown the above procedure but i am facing the login problem after following above procedure. Could you please update it

    Reply
  2. It works but deleting line by line tacks ages for some one who has been on chat for long..is there a way to delete all chat lines for one particular user .

    Reply
  3. SQLLite is a buggy tool.

    Delete records doesn’t work, executing SQL query to delete rows also doesn’t work.

    SQLLite doesn’t return any input where there was a problem in the execution or success. Simply a blank screen, no idea how to debug it or to find the problem. Point is it doesn’t delete the selected rows.

    Any ideas?

    Reply
  4. It worked suddenly. Now doesn’t work again.
    Constantly crashing also. SQLLite is a total piece of garbage.

    Anyway, you can use this query to delete all messages at once:

    delete from messages
    where dialog_partner = ‘USERNAME_TO_DELETE’

    Reply
  5. i need your help!
    i did everything you said, saved the changes after and history still appears (FULLY!).. what went wrong??

    Reply
  6. I try to your code as well as with SQL lite but no any changes occur in my data base. Please inform me how I delete complete chat history of single contact

    Reply

Leave a Reply