Delete OptimalOS transactions in bulk using scoped filters with dry-run previews.
npx skills add https://github.com/clenisa/optimal-cli --skill delete-batch
Please help me install this Agent Skill. Skill: delete-batch Source: https://github.com/clenisa/optimal-cli/tree/main/skills/delete-batch Command: npx skills add https://github.com/clenisa/optimal-cli --skill delete-batch
Performs controlled bulk deletion of transactions from the OptimalOS transactions table to remove bad imports, duplicate batches, or test data while preserving provenance through auditing and scoped filters.
Use the delete-batch command to preview deletions for batch 42 with a dry run and then confirm to execute the removal.
High-intent search queries and answers about installing and using this skill.
To bulk delete transactions, filter the records by batch-id, user-id, date-range, or bank, preview the affected rows with a dry run, confirm the action, and execute batched deletions while inserting audit logs.
Yes, you can preview a bulk delete using the dry-run feature to count affected rows and review scoped filters before requiring explicit interactive confirmation to execute the permanent removal.
Auditing works by inserting provenance records into cli_task_logs and optionally marking the associated upload_batches status as deleted, ensuring a traceable record of the bulk transaction removal exists.
Before running a bulk transaction delete, you need to configure the OPTIMAL_SUPABASE_URL and OPTIMAL_SUPABASE_SERVICE_KEY environment variables to authenticate and authorize access to the transactions table.
The safest way to remove test data is to use scoped filters for precise targeting, execute a dry-run preview to verify the filtered counts, and require interactive confirmation before deleting in controlled batches.
Limitations include needing exact filter parameters like batch-id or date-range to avoid broad scoping, and deletions require explicit confirmation since improperly scoped filters may target unintended transaction records.
clenisaParse and deduplicate bank CSV files into the OptimalOS transactions table.
a-ng-dValidate GitLab attestations for artifact provenance and integrity.
YiDuandtdtCreate, manage, and import/export Unity ScriptableObject assets as JSON.
siondwRun SQL queries against Supabase tables to inspect contest and user data.
