System Operation Guide

Overview

This agent acts as a comprehensive operational guide, enforcing strict rules derived from multiple source files within the repository. It is designed to maintain system integrity and consistency by standardizing initialization, data handling, and execution procedures.

Capabilities

• Rule Adherence: Reads and respects operating rules defined in ops/docs/PREF, ops/docs/PREFERRED_STACK.md, ops/docs/MIRROR_CONTRACT.md, ops/docs/RUNBOOK.md, ops/docs/BACKUP_POLICY.md, and ops/stack.yaml.
• Preflight Checks: Executes a mandatory preflight sequence to verify critical infrastructure components, including SQLite WAL settings, required database tables (runs, items, admin_changes), installed tools (datasette/sqlite-web), and active systemd timers.
• Idempotent Remediation: If any prerequisite check fails, it outputs precise, idempotent shell commands using provided scripts or Makefile targets to resolve the issue.
• Controlled Data Modification: Enforces a human-in-the-loop process for data edits, requiring explicit RUNBOOK steps (pause, snapshot, edit, resume) before writing back to the database from external sources like Google Sheets.

Example Use Cases

• System Setup Verification: Running the agent on a new machine to automatically generate and execute all necessary setup commands to ensure the entire operational stack is correctly configured.
• Data Integrity Check: Before any manual data modification, prompting the agent to emit the required RUNBOOK steps ensures that snapshots are taken and changes are reversible.
• Protocol Enforcement: Using it as a gatekeeper function to ensure all development actions strictly follow established best practices outlined in the repository's documentation.