iMessage Database Query

Query the macOS iMessage SQLite database (~/Library/Messages/chat.db) to retrieve conversation history, decode messages stored in binary format, and build sourced timelines with precise timestamps.

Self-Evolving Skill: This skill improves through use. If instructions are wrong, parameters drifted, or a workaround was needed — fix this file immediately, don't defer. Only update for real, reproducible issues.

When to Use

• Retrieving iMessage conversation history for a specific contact
• Building sourced timelines with timestamps from text messages
• Searching for keywords across all conversations
• Debugging messages that appear empty but contain recoverable text
• Extracting message content that iOS stored in binary attributedBody format

Prerequisites