Using SQL to Look Through All of Your iMessage Text Messages
If you use iMessage on your Mac, you can access the SQLite database where all of your messages are stored. With a little setup, you can use SQL’s raw power to look through your old messages.
In this post Dan Kelch walks through how to access the SQLite database that backs iMessage on a Mac. He also shares a few helpful SQL snippets to demonstrate how powerful using SQL on your text messages can be.