live-task/migration.sql

SQL migration creating tables for review cycles, tool executions, and cycle control.

-- Source: https://github.com/davila7/claude-code-templates | License: MIT | Copyright 2025 Daniel (San) Ávila
-- Provided via justclaw.it.com; keep this notice with the code.
-- Component Improvement Loop - Database Schema
-- Run against the existing Neon database

CREATE TABLE IF NOT EXISTS review_cycles (
  id BIGSERIAL PRIMARY KEY,
  session_id TEXT NOT NULL,
  component_path TEXT NOT NULL,
  component_type TEXT NOT NULL,
  status TEXT NOT NULL DEFAULT 'active',
  phase TEXT NOT NULL DEFAULT 'selection',
  pr_url TEXT,
  pr_number INTEGER,
  branch_name TEXT,
  linear_issue_id TEXT,
  improvements_summary TEXT,
  error_message TEXT,
  started_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW(),
  completed_at TIMESTAMPTZ
);

CREATE TABLE IF NOT EXISTS tool_executions (

... (truncated -- full source via MCP)