SRTD - Iterative SQL Template Development

Workflow

Start watch in background immediately:

srtd watch --json

Use runinbackground: true. Monitor with TaskOutput for events: templateApplied (success), templateError (check errorMessage/errorHint).

Templates

Location: supabase/migrations-templates/*.sql. Must be idempotent.

Idempotency patterns:

• Functions/Views: CREATE OR REPLACE (use DROP only when changing signature)
• Policies: DROP POLICY IF EXISTS then CREATE POLICY (not replaceable)
• Triggers: Drop BOTH trigger AND function first

Dependencies: -- @depends-on: other.sql at top

WIP: .wip.sql suffix → applies locally, never builds

Commands

srtd apply [--force] [--json]   # Apply to local DB (use instead of watch for one-off)
srtd build [--bundle]           # Generate migration FILES only (does NOT apply to DB)
srtd clear --reset              # Reset state if confused

State

• .buildlog.json → commit (tracks built migrations)
• .buildlog.local.json → gitignored (local DB state)