Editing Skype history / messages / database
28 May 2013
Sometimes you just got to edit your Skype messages history. One may want to make a joke or maybe even malicious disinformation. I had to edit Skype history because I was seeing messages from future. No I'm not insane. I had to set local PC time to the future date due to one of my development tasks. And all messages I received when I was "in future" was recorded as from future indeed in Skype. When I turned my local time back to real one, new messages in Skype was appearing above the "future" ones.
Skype forums tell there's no solution but to clear messages history. But that's not an option!
Actually, Skype history is stored in SQLite database, located in
We will need some tool to edit SQLite database, first thing I found was SQLite Database Browser, and it worked well.
Opened Skype database with SQLite Database Browser 2.0 b1
I just had to be sure I have closed my Skype, execute simple SQL query
select * from Messages order by timestamp desc limit 100
to look at the "future" timestamp, and then apply the fix:
update Messages set timestamp = 1369400643 where timestamp > 1369400643
then press Save Database.
Launched Skype and verified that everything is ok. Don't forget to backup your Skype dabatase before opening and editing it, in case something cruel happen!
Here is video instruction I have found on Youtube:
Actually it's possible to make better SQL query, one that would turn future posts date into real one, not just something constant in the past. If it would not be hard for you, please post it in comments.