Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How to search given string at all chat histories?
СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?

share|improve this question
Knowing your operating system would help! – slhck Oct 10 '12 at 12:40
Have you looked here? – Indrek Oct 10 '12 at 12:40
up vote 19 down vote accepted

In the Contact list or Recent list, simply click the contact or group you want to view the conversation history for and your conversation history is displayed.

The main.db database file where all chat history is stored. main.db is a standard SQLite database file and can be opened using any SQLite browser application. However, there is a free application, which is especially designed to read Skype’s chat and call data – SkypeLogView.

The main.db file is saved in one of the following (depending on OS).

On Windows 7 and Vista: C:\Users\[USER NAME]\AppData\Roaming\Skype\[Skype Name]

On Windows XP: C:\Documents and Settings\[USER NAME]\Application Data\Skype\[Skype Name]

On Mac OS X: Library/Application Support/Skype/[Skype Name]

For future, you may want to consider SkyHistory

share|improve this answer
SkypeLogView - helps me, really nice tool. – coms Oct 10 '12 at 15:48
SkyHistory still works with recent Skype. Thanks! – Vadzim May 20 '14 at 13:52
Thanks for the links to 3rd party tools. I find that search in Skype itself is lame - some older time periods in the chat sometimes are collapsed and Skype ignores them when searching. I have to scroll through the chat first and expand all collapsed periods and only then I can find some text which was previously hidden in one of those collapsed periods. – JustAMartin Dec 3 '15 at 13:00

Writing your own SQL queries using e.g. SqliteBrowser to search the Skype database, allows for more flexibility and functionality than using a 3rd party Skype-specific tool.

For example, this query will search for a text string in all your chats, and display the (local) time the message was posted, the message itself, the name of the chat (if it has a name), and who is in the chat.

select DISTINCT datetime(m.timestamp, 'unixepoch', 'localtime'), m.body_xml, c.topic, c.friendlyname
from Messages m
INNER JOIN Chats c ON m.convo_id = c.conv_dbid
where m.body_xml LIKE '%my text%' --case insensitive
order by m.timestamp DESC
share|improve this answer

Skyperious also might be worth checking out. It has a few capabilities over SkypeLogView, such as

  • Import contacts from a CSV file to your Skype contacts
  • View any database table and and export their data
  • Change, add or delete data in any table
  • Execute direct SQL queries
  • Synchronize messages in two Skype databases: keep chat history up-to-date on different computers, or restore missing messages from older files into the current one
  • Chat statistics
share|improve this answer
Thank you. I've edited my answer. – Keegan Jun 8 '15 at 20:36

I recently found a nice online tool for browsing Skype history:

Seems to be the best solution if you're not concerned about privacy issues.

share|improve this answer

SkyHistory did not work for me - seems like it was not designed for 68MB of skype logs : )

One of the most powerful approaches is a also very simple - just use SQLite client. Here I wrote a simple manual:

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .