Persist WhatsApp messages into a PostgreSQL table for auditing.
npx skills add https://github.com/netanel-abergel/pa-skills --skill pa-audit-db
Please help me install this Agent Skill. Skill: pa-audit-db Source: https://github.com/netanel-abergel/pa-skills/tree/main/skills/pa-audit-db Command: npx skills add https://github.com/netanel-abergel/pa-skills --skill pa-audit-db
Centralizes every inbound and outbound WhatsApp message into a queryable PostgreSQL store so agents and operators can audit conversations, trace costs, and recover message history reliably.
Set PA_DB_URL to your Postgres connection string and restart the OpenClaw gateway to begin persisting WhatsApp messages.
High-intent search queries and answers about installing and using this skill.
Storing and auditing WhatsApp messages in PostgreSQL involves persisting inbound and outbound messages into a dedicated messages table. This provides reliable storage, conversation tracing, and token cost monitoring for agent operations.
Yes, you can perform semantic search on WhatsApp message history using pgvector. The database schema includes an optional embedding column and an ivfflat embedding index to support semantic queries alongside standard keyword search and group conversation lookups.
Tracking WhatsApp message tokens and costs requires a production-ready PostgreSQL schema with specific fields for timestamps, sender metadata, tokens, and cost data. This structure enables accurate cost summaries and daily message count analytics.
Yes, this message logging approach works with both local and managed Postgres instances. It uses the PA_DB_URL environment variable for connection configuration and provides troubleshooting guidance for resolving common database setup issues.
You need to configure PA_DB_URL for OpenClaw agents to establish a connection to your PostgreSQL database. Setting this environment variable and restarting the OpenClaw gateway activates message persistence for conversation recall and auditing.
netanel-abergelRetrieve past WhatsApp or chat conversations from PostgreSQL or local files.
discountedcookieStore 384-dimensional embeddings in Postgres and query cosine similarity with pgvector.
badbsallyySend WhatsApp messages and sync chat history via command-line interface.
VictoriakaeyDesign query-first PostgreSQL schemas with pgvector for AI storage.
