Skills
.Work. You
Rest

pa-audit-db

Community

Persist and query WhatsApp messages

Software Engineering#postgresql#embeddings#whatsapp#pgvector#database-schema#openclaw#message-logging
Authornetanel-abergel
Version1.0.0
Installs0

System Documentation

What problem does it solve?

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.

Core Features & Use Cases

  • Production-ready schema with timestamps, sender metadata, tokens and cost fields, and an optional embedding column for semantic search.
  • Search and analytics via full-text indexes, ivfflat embedding index (pgvector), and common query patterns for recent messages, group history, keyword search, daily counts, and cost summaries.
  • Deployment flexibility with local or managed Postgres instructions, environment variable integration (PA_DB_URL), and troubleshooting guidance for common setup issues.
  • Use Case: Run this during agent provisioning to enable message auditing, conversation recall, and token/cost monitoring for WhatsApp-based PAs.

Quick Start

Set PA_DB_URL to your Postgres connection string and restart the OpenClaw gateway to begin persisting WhatsApp messages.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: pa-audit-db
Download link: https://github.com/netanel-abergel/pa-skills/archive/main.zip#pa-audit-db

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.