Sunday, April 2, 2017

Skype database analyzer

I was going through my old computer files and found files for my old Skype account. Initially, I used SkypeLogView from Nirsoft (
It was examining main.db file located under C:\Users\USERNAME\AppData\Roaming\Skype\SKYPE_USERNAME\. I looked at the file type and it was sqlite database then I used DB Browser for Sqlite ( to examine the database. I found way more information than what I got from SkypeLogView.

I ended up writing a script to extract some of that information. Initially, I wanted a graph like one displayed here for all the contacts. I never got that far.

What the script currently does:

  • Extract info about the main account. Info such as emails, phone #'s, mood info, and etc.
  • Extract info about contacts. Skype even stores people who you were in group chat with but whom you haven't added to contact list. 
  • Gets info on how many messages each author has sent.
  • Similar to tweets analyzer, it gets info for hour and number of messages for each author. It doesn't do the cool graph though. :(
  • Prints top 10 words used by each author. (This is kinda useless)

Feel free to copy it. I spent a day on writing that so it's not that great. If anyone improves it, leave a comment. 


  1. Hello Everyone !

    USA Fresh & Verified SSN Leads along with Driving License/ ID Number, AVAILABLE with 99.9% connectivity
    All Leads have genuine & valid information.

    First Name | Last Name | SSN | Dob | Driving License Number | Address | City | State | Zip | Phone Number | Account Number | Payday | Bank Name | Employee Details | IP Address

    *Price for SSN lead $2
    *You can ask for sample before any deal
    *If anyone buy in bulk, we can negotiate
    *Sampling is just for serious buyers

    ->$5 PER EACH

    ->Hope for the long term Business
    ->Interested buyers will be welcome

    **Contact 24/7**
    Whatsapp > +923172721122
    Email >
    Telegram > @leadsupplier
    ICQ > 752822040

    1. Hello all
      am looking few years that some guys comes into the market
      they called themselves hacker, carder or spammer they rip the
      peoples with different ways and it’s a badly impact to real hacker
      now situation is that peoples doesn’t believe that real hackers and carder scammer exists.
      Anyone want to make deal with me any type am available but first
      I‘ll show the proof that am real then make a deal like

      Available Services

      ..Wire Bank Transfer all over the world

      ..Western Union Transfer all over the world

      ..Credit Cards (USA, UK, AUS, CAN, NZ)

      ..School Grade upgrade / remove Records

      ..Spamming Tool

      ..keyloggers / rats

      ..Social Media recovery

      .. Teaching Hacking / spamming / carding (1/2 hours course)

      discount for re-seller

      Contact: 24/7

  2. Are you desperately in need of a hacker in any area of your life??? then you can contact; ( services like; -hack into your cheating partner's phone(whatsapp,,icloud,facebook, twitter,snap chat and others) -Sales of Blank ATM cards. -hack into email accounts and trace email location -all social media accounts, -school database to clear or change grades, -Retrieval of lost file/documents -DUIs -company records and systems, -Bank accounts,Paypal accounts -Credit cards hacker -Credit score hack -Monitor any phone and email address -Websites hacking, pentesting. -IP addresses and people tracking. -Hacking courses and classes CONTACT THEM= hackintechnologyatgmaildotcom or whatsapp +12132951376 their services are the best on the market and 100% security and discreet work is guarante