Agent Skills
› openclaw/clawhub
› convex-retention
convex-retention
GitHub规范 ClawHub Convex 数据库表的保留策略，涵盖表分类、TTL 字段设置、清理 Cron 作业及过期数据（如 Auth Session）的自动清理流程。
Trigger Scenarios
添加或修改 Convex 数据表结构
配置 TTL 字段或清理定时任务
更新数据保留政策
移除废弃表或清理过期认证会话
Install
npx skills add openclaw/clawhub --skill convex-retention -g -y
SKILL.md
Frontmatter
{
"name": "convex-retention",
"description": "Use when adding or changing ClawHub Convex tables, TTL fields, cleanup crons, retention policy, auth\/session cleanup, metric dedupe cleanup, or deprecated table removal"
}
Convex Retention
Overview
ClawHub retention is code-owned. Every current Convex table must be classified in
convex/lib/retentionPolicy.ts, and ephemeral tables need an indexed, bounded cleanup path unless
their lifecycle is handled by usage-time validation or a documented component.
Checklist
- Use
clawhub-convexand readconvex/_generated/ai/guidelines.mdfirst. - Add every new schema table to
RETENTION_POLICIES; theRecord<TableNames, RetentionPolicy>type is the enforcement gate. - For ephemeral tables, prefer an explicit expiration field plus index, then prune with
.withIndex()and.take(...). - For new generic TTL tables, prefer
expirationTimeto match Convex Auth. Keep existingexpiresAt,dayStart, andprocessedAtfields unless that table already needs a real migration. - Use
RETENTION_STANDARD_BATCH_SIZEfor ordinary retention jobs. Keep incident-tested special cases, such asskillStatEvents, on their documented caps. - Cron jobs should schedule bounded cleanup entrypoints only. Large one-off production migrations or
destructive backfills still start with
convex-migration-helper. - Do not bulk-clear active auth state. Expired
authSessionsandauthRefreshTokensare pruned byconvex/retention.ts.
Verification
- Add or update focused tests for policy classification and cleanup behavior.
- Run the focused Vitest slice for touched cleanup modules.
- Run
bunx convex codegenafter schema/API changes. - Run a real Convex runtime check such as
bunx convex dev --once --typecheck=disable.
Version History
- 5a3b050 Current 2026-07-25 08:43
