whatsapp-search

Search WhatsApp message history in local macOS SQLite databases.

3|Updated Dec 30, 2025
One-click install
npx skills add https://github.com/yungweng/dotfiles --skill whatsapp-search
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: whatsapp-search
Source: https://github.com/yungweng/dotfiles/tree/main/claude/.claude/skills/whatsapp-search
Command: npx skills add https://github.com/yungweng/dotfiles --skill whatsapp-search

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you quickly locate specific WhatsApp messages, chats, or conversations when you can't recall the exact details.

Core Features & Use Cases

  • Search Message History: Query your WhatsApp chat database using keywords, dates, or sender information.
  • Identify Media: Find image, video, or document messages within conversations.
  • Contact Lookup: Resolve phone numbers to names and vice versa within your contacts.
  • Use Case: You remember a friend mentioning a restaurant recommendation a few weeks ago. Use this Skill to search your WhatsApp history for messages containing "restaurant" and the friend's name to find the recommendation.

Quick Start

Search your WhatsApp messages for conversations containing the keyword "project update".

Frequently Asked Questions about whatsapp-search

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I search local WhatsApp messages on macOS?

This Skill searches local WhatsApp messages on macOS by querying the ChatStorage.sqlite database to retrieve message history, allowing you to find specific conversations using keywords, dates, or sender information.

Can I find media attachments and contacts in WhatsApp SQLite databases?

Yes, you can find media attachments and contacts in WhatsApp SQLite databases. The Skill queries ChatStorage.sqlite for media and ContactsV2.sqlite to resolve phone numbers to names and vice versa for contact lookup.

Does WhatsApp search work with Core Data timestamps on macOS?

Yes, WhatsApp search works with Core Data timestamps on macOS. The Skill automatically handles Core Data timestamp conversions and JID format resolutions to ensure accurate data retrieval from the local SQLite databases.

What is the best way to locate a specific conversation in WhatsApp history?

The best way to locate a specific conversation in WhatsApp history is querying the local SQLite database. You can search your chat history using message content keywords, sender details, or date ranges to find exact chats.

Do I need any external dependencies to query WhatsApp conversations from a SQLite database?

No external dependencies are required to query WhatsApp conversations from a SQLite database. The Skill operates independently to search and retrieve message history, media attachments, and contact information directly from local macOS database files.