skills.rest
netanel-abergel
netanel-abergelCOMMUNITY
Explore all skills by this author →
GitHub

chat-history

Retrieve past WhatsApp or chat conversations from PostgreSQL or local files.

5|1|Updated Apr 1, 2026
Search Tags:#postgresql#search#whatsapp#chat#messages#fallback
One-click install
npx skills add https://github.com/netanel-abergel/pa-skills --skill chat-history-netanel-abergel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: chat-history
Source: https://github.com/netanel-abergel/pa-skills/tree/main/skills/chat-history-local
Command: npx skills add https://github.com/netanel-abergel/pa-skills --skill chat-history-netanel-abergel

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Retrieving past WhatsApp or chat conversations from the audit log when users need to recall what was discussed, find specific messages, or reference prior interactions.

Core Features & Use Cases

  • Database Search: Executes full-text, contact, and date-range queries against the PostgreSQL messages table.
  • File Fallback: Greps local markdown context files when the database is unavailable.
  • Unanswered Message Detection: Identifies recent chats that have not received a response.
  • Use Case Example: A user asks, "What did we say about the budget last week?" and the skill returns the relevant messages.

Quick Start

Search the chat history for the term "budget" from the past week.

Frequently Asked Questions about chat-history

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

FAQPage Schema
How do I search WhatsApp chat history by keyword or contact?▼

To search WhatsApp chat history, the skill executes full-text, contact, and date-range queries against the PostgreSQL messages table. It retrieves past conversations matching your specified keywords, contacts, or dates from the audit log database.

How do I find unanswered WhatsApp messages from recent chats?▼

Finding unanswered WhatsApp messages is supported through built-in detection logic. The skill identifies recent chats that have not received a response by querying the audit log database for recent inbound messages lacking subsequent outbound replies.

Do I need a PostgreSQL database to retrieve chat history or can I use local files?▼

You do not strictly need a PostgreSQL database to retrieve chat history. The skill uses the PA_DB_URL PostgreSQL instance primarily but features a file fallback that greps local markdown context files when the database is unavailable.

What format do retrieved WhatsApp messages return when searching the audit log?▼

Retrieved WhatsApp messages return formatted as timestamp, sender, and message text. This structured format applies to results from both the PostgreSQL database queries and the local markdown file fallback searches.

Can I locate previous WhatsApp discussions about a specific topic from last week?▼

You can locate previous WhatsApp discussions about a specific topic from last week by running a keyword search. The skill queries the messages table for the term and date range, returning relevant formatted conversation logs.

Related Skills

Explore More Content & Communication Skills→
netanel-abergelnetanel-abergel
5

pa-audit-db

Persist WhatsApp messages into a PostgreSQL table for auditing.

Community
Advanced
ilamanovilamanov

compile-conversation-into-doc

Compile Markdown chat logs into structured reference documents.

Community
Intermediate
karrtik159karrtik159

postgresql-optimization

Optimize PostgreSQL queries and indexing strategies using EXPLAIN ANALYZE and pg_stat_statements.

Community
Advanced
grahama1970grahama1970
1

episodic-archiver

Embed conversation turns and store them in ArangoDB for search and retrieval.

Community
Advanced