codex-automation-admin

Generated source view for the actual executable productivity/codex-automation-admin skill. The durable routing article is Agent Operations Skills. Source: skills/productivity/codex-automation-admin/SKILL.md

Runtime Source

Bundled Resources

No bundled resource files.

Description

Manage Codex automations (list, create, pause, delete) using the sqlite database. Use when asked to create, pause, list, end, or modify Codex automations, or when referencing the Codex automation schema.

Skill Source

---
name: codex-automation-admin
description: Manage Codex automations (list, create, pause, delete) using the sqlite database. Use when asked to create, pause, list, end, or modify Codex automations, or when referencing the Codex automation schema.
origin: personal
source_slug: codex-automation-admin
---

# Codex Automation Admin

## Storage

Codex stores automations in two places:

- **Primary (sqlite):** `~/.codex/sqlite/codex-dev.db` table `automations`
- **Mirror (TOML):** `~/.codex/automations/<slug>/automation.toml`

The sqlite DB is authoritative. TOML files are read by the scheduler but the DB is what the UI and CLI query.

## Schema

```sql
CREATE TABLE automations (
  id            TEXT PRIMARY KEY,
  name          TEXT NOT NULL,
  status        TEXT NOT NULL,  -- 'ACTIVE' | 'PAUSED'
  cwds          TEXT,           -- JSON array of working directories
  rrule         TEXT,           -- iCal RRULE string (e.g. "FREQ=DAILY;INTERVAL=1")
  model         TEXT,           -- model slug (e.g. "o3")
  reasoning_effort TEXT,        -- 'low' | 'medium' | 'high'
  prompt        TEXT,           -- the automation prompt
  next_run_at   TEXT,           -- ISO 8601 timestamp
  created_at    TEXT            -- ISO 8601 timestamp
);
```

## Common Operations

### List all automations
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "SELECT id, name, status, rrule, next_run_at FROM automations;"
```

### Pause all automations
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "UPDATE automations SET status = 'PAUSED';"
```

### Pause one automation
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "UPDATE automations SET status = 'PAUSED' WHERE name = '<name>';"
```

### Activate one automation
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "UPDATE automations SET status = 'ACTIVE' WHERE name = '<name>';"
```

### Create a new automation
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "INSERT INTO automations (id, name, status, cwds, rrule, model, reasoning_effort, prompt, next_run_at, created_at) VALUES (
  lower(hex(randomblob(16))),
  '<name>',
  'ACTIVE',
  '[\"<working-directory>\"]',
  'FREQ=DAILY;INTERVAL=1',
  'o3',
  'medium',
  '<prompt text>',
  datetime('now'),
  datetime('now')
);"
```

### Delete an automation
```bash
sqlite3 ~/.codex/sqlite/codex-dev.db "DELETE FROM automations WHERE name = '<name>';"
```

## Known Issues

- `$CODEX_HOME` does not resolve in sandboxed shell environments. Always use `~/.codex` explicitly.
- The TOML mirror at `~/.codex/automations/` may be stale. Trust the sqlite DB.
- Valid status values are exactly `ACTIVE` and `PAUSED` (case-sensitive).

---

Timeline

• 2026-07-15 | Generated a browseable source page from the actual executable skill file. Source: skills/productivity/codex-automation-admin/SKILL.md