There are 3 files used to save Messages on Mac.
What are each of them for?
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
Per this great answer: https://stackoverflow.com/a/12948036/475228
The shm and wal are standard indexing and checkpoint files that accompany the main database file. Nothing special on th messages side other than using the sqlite3 format to store the data to disk.