wa

WhatsApp Skill

CRITICAL: Sending Rules

NEVER send without explicit confirmation. Wrong-number sends leak confidential info.

• Block unverified sends via a PreToolUse hook (see hooks/).
• NEVER construct phone numbers from memory.
• Discussion/brainstorming is NOT a send instruction. Only "send", "go", "send it" counts.

Only send flow:

1. Run your verified send script (dry run: resolves JID, shows phone, exits without sending)
2. Show the user the resolved phone number
3. Wait for explicit "yes" / "send" / "go"
4. Run with --confirmed flag

Reading Messages

Step 1: Copy the DB

DB_SOURCE="<PATH_TO_WHATSAPP_CHATSTORE_SQLITE>"
cp "$DB_SOURCE" /tmp/wa-chat.sqlite

If the copy fails, the source is unavailable. Do not proceed; tell the user.

Step 2: Find a contact

sqlite3 /tmp/wa-chat.sqlite "
SELECT ZCONTACTJID, ZCONTACTIDENTIFIER, ZPARTNERNAME
FROM ZWACHATSESSION
WHERE ZPARTNERNAME LIKE '%Name%';
"

Step 3: Read DM messages

sqlite3 /tmp/wa-chat.sqlite "
SELECT ZFROMJID, ZTEXT, datetime(ZMESSAGEDATE + 978307200, 'unixepoch') as msg_time
FROM ZWAMESSAGE
WHERE ZFROMJID LIKE '%PHONE_OR_LID%'
ORDER BY ZMESSAGEDATE DESC
LIMIT 20;
"

Replace PHONE_OR_LID with phone digits or LID from step 2 (no +, no spaces).

Step 4: Read group messages

sqlite3 /tmp/wa-chat.sqlite "
SELECT ZMEMBERJID, ZTEXT, datetime(ZMESSAGEDATE + 978307200, 'unixepoch') as msg_time
FROM ZWAMESSAGE
WHERE ZCHATSESSION IN (
  SELECT Z_PK FROM ZWACHATSESSION WHERE ZPARTNERNAME LIKE '%GroupName%'
)
ORDER BY ZMESSAGEDATE DESC
LIMIT 20;
"

Step 5: Read full conversation (both sides)

sqlite3 /tmp/wa-chat.sqlite "
SELECT
  CASE WHEN ZFROMJID IS NULL THEN 'Me' ELSE ZFROMJID END as sender,
  ZTEXT,
  datetime(ZMESSAGEDATE + 978307200, 'unixepoch') as msg_time
FROM ZWAMESSAGE
WHERE ZCHATSESSION IN (
  SELECT Z_PK FROM ZWACHATSESSION WHERE ZCONTACTJID LIKE '%PHONE_OR_LID%'
)
  AND ZTEXT IS NOT NULL
ORDER BY ZMESSAGEDATE DESC
LIMIT 30;
"