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?
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:
On Windows XP:
On Mac OS X:
For future, you may want to consider SkyHistory
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, an 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.
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: http://jehy.ru/articles/2014/05/26/searching-through-skype-history/