CLI command needs DB → getConnection() → is port 19642 listening?
                                              │
                                    ┌─────────┴──────────┐
                                    │ Yes                 │ No
                                    │ Return cached       │ Start pgserve
                                    │ connection          │ Run migrations
                                    │                     │ Return connection
                                    └─────────────────────┘

draft → brainstorm → wish → build → review → qa → ship
         /brainstorm   /wish  /work   /review  /qa

// Create a task
const task = await createTask(sql, repoPath, {
  title: "Implement auth middleware",
  priority: "high",
  wishFile: ".genie/wishes/auth-fix/WISH.md",
  groupName: "1",
});

// Assign an actor
await addActor(sql, task.id, {
  actorType: "local",
  actorId: "engineer-1",
}, "assignee");

// Add dependencies
await addDependency(sql, task.id, otherTask.id, "depends_on");

UPDATE tasks
SET checkout_run_id = $1, execution_locked_at = now()
WHERE id = $2 AND checkout_run_id IS NULL
RETURNING *;

CREATE TABLE _genie_migrations (
  id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  name TEXT UNIQUE NOT NULL,
  applied_at TIMESTAMPTZ NOT NULL DEFAULT now()
);