SQLite to JSON converter
This script dumps all* the tables in an sqlite database as json.
sqlite2json sqlitefile.db [–exclude=TABLE]
To dump the sqlite file where iMessages are stored:
Here is a more useful version of the above example:
sqlite2json ~/Library/Messages/chat.db | jq -r .message.text | grep -i loan
*The script doesn’t dump the contents of of the sqlite_master table
John Gerlock <firstname.lastname@example.org>
Jeffrey Paul <email@example.com>
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.