Automation Dedup Guard

WorkBuddy 自动化任务去重守护。当用户的自动化任务出现重复时自动检测并清理。触发场景：自动化任务重复、任务列表膨胀、需要清理重复任务。支持 Windows/macOS/Linux，纯 Python 标准库，零依赖。

Security Scan

The skill's code and instructions are consistent with its stated purpose (finding and deleting duplicate automations in a local WorkBuddy SQLite DB); it requests no credentials or external installs, but it performs permanent deletions so users should back up the DB and test with dry-run first.

Purpose & Capability

Name/description describe deduplicating WorkBuddy automation records and the included script only touches a local SQLite database (automations and automation_runs). No unrelated binaries, services, or credentials are requested; the filesystem access is proportional to the task.

Instruction Scope

SKILL.md and the script instruct the agent/user to locate and open the WorkBuddy automations DB, run in dry-run mode or execute deletions, and optionally schedule the script as an automation. The instructions reference an optional WORKBUDDY_DB_PATH environment variable (supported by the script) even though the registry lists no required env vars. The skill also explicitly states there is no backup and deletions are permanent — this is scope-relevant and flagged to the user.

Install Mechanism

No install spec, no downloads, and only a small Python script using stdlib is included. There is no remote code fetch or archive extraction; risk from the install mechanism is low.

Credentials

The skill requires no secrets or credentials. It reads filesystem paths (default platform-specific DB locations) and optionally the WORKBUDDY_DB_PATH env var; these are reasonable for a DB-cleanup tool. Minor inconsistency: the registry lists no required env vars, but the script/README mention WORKBUDDY_DB_PATH as an optional override.

Persistence & Privilege

always is false and the skill does not request permanent platform-wide privileges or modify other skills. It runs ad hoc or on a schedule as the user configures; autonomous invocation is allowed by platform default but is not combined here with broad credential or persistence requirements.

Assessment

This skill appears to do exactly what it says: find duplicate WorkBuddy automation records and delete them from a local SQLite DB. Before using it: 1) Always run with --dry-run first and verify the listed duplicates. 2) Back up the automations.db file manually (the script warns that deletions are permanent and it does not create backups). 3) Make sure you point the script to the correct DB (use --db or set WORKBUDDY_DB_PATH) to avoid affecting the wrong data. 4) Note it deletes related automation_runs rows as well. 5) If you schedule it as a recurring automation, ensure the scheduled context has access to the correct DB path and that you are comfortable allowing regular automatic deletions. 6) If timestamps aren't ISO/consistent in your DB, review results carefully (the script sorts by created_at strings). If you want extra safety, copy the DB and test the script against the copy first.

Overview

WorkBuddy 的自动化任务系统没有防重机制，每次新会话创建同名任务时不会检查是否已存在，导致同名任务不断累积。本 Skill 提供一个一键去重脚本，自动检测并清理重复的自动化任务，每组同名任务只保留最新创建的版本。

When to Use

• 用户反馈自动化任务"重复出现"、"越来越多"、"一堆重复的"
• 需要检查或清理 WorkBuddy 自动化数据库中的冗余任务
• 想要配置定期自动去重守护

Core Script

scripts/automation_dedup_guard.py is the main executable.

Usage

# Safe preview (dry-run, no deletions)
python scripts/automation_dedup_guard.py --dry-run

# Execute cleanup
python scripts/automation_dedup_guard.py

# Specify custom database path
python scripts/automation_dedup_guard.py --db /custom/path/automations.db

# Verbose mode for debugging
python scripts/automation_dedup_guard.py --dry-run -v

Exit Codes

• 0 — No duplicates found, all clean
• 1 — Duplicates detected (after cleanup, still returns 1 if any were found)

Database Auto-Detection

The script automatically locates the WorkBuddy automations database:

Priority	Source	Notes
1	--db CLI argument	Manual override
2	WORKBUDDY_DB_PATH env var	For advanced users
3	OS default path	Auto-detected

Default paths by OS:

• Windows: %APPDATA%\WorkBuddy\automations\automations.db
• macOS: ~/Library/Application Support/WorkBuddy/automations\automations.db
• Linux: ~/.config/WorkBuddy\automations\automations.db

Dedup Strategy

1. Group by name: Tasks with the same name field are considered duplicates
2. Keep newest: Within each group, the task with the latest created_at is preserved
3. Cascade delete: Associated automation_runs records are also cleaned up
4. No backup: Deletions are permanent (back up the DB file manually if needed)

Setup as Recurring Automation

To run automatically, register it as a WorkBuddy automation:

• Name: Automation Dedup Guard
• Schedule: Weekly (e.g., FREQ=WEEKLY;BYDAY=MO;BYHOUR=8;BYMINUTE=55)
• Prompt:

  Run the dedup guard script: python [path-to]/scripts/automation_dedup_guard.py
  If output contains "[OK]" — no action needed.
  If output contains "[!]" — duplicates were auto-cleaned, confirm the count.
  If script errors — log the error, no other action.
  

Requirements

• Python 3.6+
• No third-party dependencies (stdlib only: sqlite3, sys, os, datetime, collections)