Skype main.db

From Just Solve the File Format Problem
Jump to: navigation, search
File Format
Name Skype main.db
Ontology
Extension(s) .db
Released 2008

From 2008[1][2] to 2017[3], the VoIP + chat program Skype stored the most accessible copy of its message and call history in an SQLite database named main.db. After version 12 was released in 2017, message history was instead kept in a slightly different database called skype.db, although main.db remains in the filesystem.[3][4]. Much of the information stored in main.db, and some that wasn't (namely "deleted" messages), was also stored in a directory structure called "chatsync".

Software

  • [1]: Skyperious, an open-source viewer written in Python
    • pip2 name: skyperious
  • [2]: NirSoft SkypeLogViewer, a proprietary freeware viewer
  • [3] Another proprietary freeware viewer
  • [4] Ditto.

Links

References

  1. O'Connor, T.J. Violent Python: A Cookbook For Hackers, Forensic Analysts, Penetration Testers And Security Engineers. Elsevier, 2013. p. 110. IA link
  2. https://web.archive.org/web/20080716022445/http://www.skype.com/intl/en/download/skype/windows/beta/ Note the date.
  3. 3.0 3.1 https://answers.microsoft.com/en-us/skype/forum/all/where-is-the-maindb-file-for-new-skype/b4d3f263-a97e-496e-aa28-e1dbb63e7687
  4. https://answers.microsoft.com/en-us/skype/forum/skype_windesk-skype_messms-skype_sms/sqlite-maindb-file/75258f84-4b2d-4284-82b0-958bed9f3b36
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox