iMessage Retriever Sql

iMessage Retriever.md

execute the below sql on the ~/Library/Messages/chat.db to retrieve the most recent 10 messages (can be changed with the LIMIT keyword.

Adapted from NiftyCode's iMessage Reader

this file will only be present on MacOS

sql.sql

SELECT text, datetime((date / 1000000000) + 978307200, 'unixepoch', 'localtime'), handle.id, handle.service FROM message JOIN handle on message.handle_id=handle.ROWID ORDER BY message.ROWID DESC LIMIT 10;

sql_expanded.sql

SELECT
  text,
  datetime(
    (date / 1000000000) + 978307200,
    'unixepoch',
    'localtime'
  ),
  handle.id,
  handle.service
FROM
  message
  JOIN handle on message.handle_id = handle.ROWID
ORDER BY
  message.ROWID DESC
LIMIT
  10;