Timeline Cleanup

Delete messages from the web chat timeline that match keyword patterns, then optionally vacuum the database to reclaim space.

How It Works

1. Query the messages DB (from PICLAW_STORE/messages.db) for rows matching the given patterns
2. Resolve the full session scope — for web:* chats, this includes all session trees and branches
3. Exclude messages that have media attachments — unless --include-media is passed
4. Delete matching messages via the /post/{id}?cascade=true HTTP API
5. Optionally vacuum the database (requires a brief piclaw restart)

Usage

Run cleanup by importing the helper or using the CLI.

Defaults include a throttled delete loop (1100ms delay) with retries on HTTP 429 responses to avoid server-side rate limits.

Import

import { cleanupTimeline } from "/workspace/.pi/skills/timeline-cleanup/cleanup.ts";

const result = await cleanupTimeline({
  patterns: ["reload", "compaction"],
  // dryRun: true,           // Preview only
  // includeMedia: false,    // Skip messages with attachments (default)
  // vacuum: false,          // Vacuum DB after (causes restart)
  // beforeRowid: 99999,     // Only match messages before this rowid
  // chatJid: "web:default", // Target chat
  // maxLength: 300,         // Only match messages shorter than this
  // senderFilter: "web-agent", // Only match this sender
  // throttleMs: 1100,       // Delay between deletes (avoid rate limits)
  // retryOn429: true,       // Retry if rate limited
  // maxRetries: 2,          // Max retries for rate limits
});