Skyperious

Skype SQLite database viewer and merger

Index
Downloads
Installation
Screenshots
FAQ
Help Texts
Search syntax
Command-line help
Changelog
View the Project on GitHub suurjaak/Skyperious

Help Texts

Search Syntax

Skyperious supports a Google-like syntax for searching messages:

Search for exact word or phrase

"do re mi"
Use quotes (") to search for an exact phrase or word. Quoted text is searched exactly as entered, leaving whitespace as-is and ignoring any wildcard characters.
Search for either word

this OR that
To find messages containing at least one of several words, include OR between the words. OR works also for phrases and grouped words (but not keywords).
Group words together

(these two) OR this
-(none of these)

Surround words with round brackets to group them for OR queries or for excluding from results.
Search for partially matching text

bas*ball
Use an asterisk (*) to make a wildcard query: the wildcard will match any text between its front and rear characters (including other words).
Search within specific chats

chat:office
chat:"coffee & cig"

To find messages from specific chats only, use the keyword chat:name.

Search from more than one chat by adding more chat: keywords.
Search from specific authors

from:maria
from:"john smith"

To find messages from specific authors only, use the keyword from:name.

Search from more than one author by adding more from: keywords.
Search from specific time periods

date:2008
date:2009-01
date:2005-12-24..2007

To find messages from specific time periods, use the keyword date:period or date:periodstart..periodend. For the latter, either start or end can be omitted.

A date period can be year, year-month, or year-month-day. Additionally, date:period can use a wildcard in place of any part, so date:*-12-24 would search for all messages from the 24th of December.

Search from a more narrowly defined period by adding more date: keywords.
Exclude words or keywords

-notthisword
-"not this phrase"
-(none of these)
-chat:notthischat
-from:notthisauthor
-date:2013

To exclude certain messages, add a dash (-) in front of words, phrases, grouped words or keywords.
SPECIAL: search specific tables

table:fromthistable
-table:notfromthistable

When performing search on all columns of all database tables (the fourth option on the search toolbar), use the keyword table:name to constrain results to specific tables only.

Search from more than one table by adding more table: keywords, or exclude certain tables by adding a -table: keyword.

Examples

Search is made on raw Skype message body, so there can be results which do not seem to match the query - Skype messages contain more than plain text.
For example, searching for href will match a message with body
<a href="http://lmgtfy.com/">lmgtfy.com</a>, displayed as lmgtfy.com.

This can be used for finding specific type of messages, for example <sms finds SMS messages, <file finds transfers, <quote finds quoted messages, and <ss finds messages with emoticons.

Command-Line Help

Command-line interface does not require having wx installed, if running from source code.
It is likewise available with compiled binaries.

$ skyperious -h

usage: skyperious [-h] [--verbose] {export,search,merge,diff,gui} ...

Skyperious - Skype SQLite database viewer and merger.

positional arguments:
  {export,search,merge,diff,gui}
    export              export Skype databases as HTML, text or spreadsheet
    search              search Skype databases for messages or data
    merge               merge two or more Skype databases into a new database
    diff                compare chat history in two Skype databases
    gui                 launch Skyperious graphical program (default option)

optional arguments:
  -h, --help            show this help message and exit
  --verbose             print detailed progress messages to stderr
$ skyperious -h export

usage: main.py export [-h] [-t {html,xlsx,csv,txt,xlsx_single}]
                      [-c CHAT [CHAT ...]] [-a AUTHOR [AUTHOR ...]]
                      [--verbose]
                      FILE [FILE ...]

Export all message history from a Skype database into files under a new
folder, or a single Excel workbook with chats on separate sheets.

positional arguments:
  FILE                  one or more Skype databases to export

optional arguments:
  -h, --help            show this help message and exit
  -t {html,xlsx,csv,txt,xlsx_single}, --type {html,xlsx,csv,txt,xlsx_single}
                        export type: HTML files (default), Excel workbooks,
                        CSV spreadsheets, text files, or a single Excel
                        workbook with separate sheets
  -c CHAT [CHAT ...], --chat CHAT [CHAT ...]
                        names of specific chats to export
  -a AUTHOR [AUTHOR ...], --author AUTHOR [AUTHOR ...]
                        names of specific authors whose chats to export
  -p, --password        ask for Skype password on HTML export, to download
                        shared images
  --verbose             print detailed progress messages to stderr
$ skyperious -h search

usage: skyperious search [-h] [-t {message,contact,chat,table}] [--verbose]
                      QUERY FILE [FILE ...]

Search Skype databases for messages, chat or contact information, or table
data.

positional arguments:
  QUERY                 search query, with a Google-like syntax, for example:
                        "this OR that chat:links from:john". More on syntax at
                        https://suurjaak.github.io/Skyperious/help.html.
  FILE                  Skype database file(s) to search

optional arguments:
  -h, --help            show this help message and exit
  -t {message,contact,chat,table}, --type {message,contact,chat,table}
                        search in message body (default), in contact
                        information, in chat title and participants, or in any
                        database table
  --verbose             print detailed progress messages to stderr
$ skyperious -h merge

usage: skyperious merge [-h] [--verbose] [-o OUTPUT] FILE1 FILE2 [FILE2 ...]

Merge two or more Skype database files into a new database in current
directory, with a full combined message history. New filename will be chosen
automatically. Last database in the list will be used as base for comparison.

positional arguments:
  FILE1       first Skype database
  FILE2       second Skype database, or more

optional arguments:
  -h, --help            show this help message and exit
  --verbose             print detailed progress messages to stderr
  -o OUTPUT, --output OUTPUT
                        Final database filename, auto-chosen by default
$ skyperious -h diff

usage: skyperious diff [-h] [--verbose] FILE1 FILE2

Compare two Skype databases for differences in chat history.

positional arguments:
  FILE1       first Skype database
  FILE2       second Skype databases

optional arguments:
  -h, --help  show this help message and exit
  --verbose   print detailed progress messages to stderr
$ skyperious -h gui

usage: skyperious gui [-h] [FILE [FILE ...]]

Launch Skyperious graphical program (default option).

positional arguments:
  FILE        Skype database to open on startup, if any

optional arguments:
  -h, --help  show this help message and exit