1 unstable release
0.1.0 | Jul 1, 2024 |
---|
#750 in Command line utilities
9KB
80 lines
Signal Message Counter
Signal Message Counter is a tool for analyzing and visualizing messages from the Signal desktop application stored in an SQLite database.
Getting Started
1. Obtain the SQLite Database
Depending on your operating system, locate the Signal SQLite database:
- Linux:
~/.config/Signal/sql/db.sqlite
- Mac:
~/Library/Application Support/Signal/sql/db.sqlite
- Windows:
C:\Users\<YourName>\AppData\Roaming\Signal\sql\db.sqlite
(exact path may vary)
2. Decrypt and Convert SQLite Database to CSV
The Signal SQLite database is encrypted using SQLCipher. You need to decrypt it and convert it to CSV format using the following steps:
Prerequisites
Ensure you have the following installed:
- sqlcipher: A recent version (e.g., 3.31.0 or later) to decrypt the encrypted SQLite database.
Decrypt Script
Download the decryption script sqlite-to-csv.sh and follow these steps:
- Save the script in a directory of your choice.
- Make it executable:
chmod +x sqlite-to-csv.sh
. - Execute the script:
bash sqlite-to-csv.sh
.
This script decrypts the Signal SQLite database using the encryption key obtained from config.json
, extracts message data in JSON format, and writes it to backup-desktop.csv
.
To use this script on windows, either use WSL or transfer the files to a linux machine.
Analyzing Messages
Once you have backup-desktop.csv
, you can use this tool to parse and analyze the CSV file to extract insights such as message counts, timestamps, and message types (incoming/outgoing). You'll need to get your conversation id for this, which you can find by getting most recent message from your selected chat, doing CTRL-F in the CSV file and on the same line, finding the conversation id. It'll look something like d37673ee-9d18-4294-be46-30e755a1406
Usage: signalmessagecounter <filepath> <conversationId>
License
This project is licensed under the BSD 2-Clause License - see the LICENSE file for details.
Dependencies
~2.6–4MB
~60K SLoC