flow-remediator-publisher
Flow Remediator Publisher
Overview
Use this skill for batch flow remediation on existing flows records when the input scope is a curated UUID list (for example an operator-exported flow_list_100_selected.jsonl, where 100 means state_code=100 rather than "top 100") and the agent must not access the database directly.
This skill provides a staged pipeline to fetch flow JSON via MCP CRUD, delegate flow review to lifecycleinventory-review --profile flow, remediate each finding via structured LLM output, run schema/version gates, and append a new uuid + version record via insert.
Scope Boundary (Avoid Overlap)
process-automated-builderownsprocess_from_flowgeneration and publishing of process/source datasets.lifecycleinventory-reviewowns review logic/reporting (includingflowprofile semantic review).flow-remediator-publisherowns remediation and append-only publish orchestration for existing flow datasets.
This skill's review/validate stages should delegate to lifecycleinventory-review --profile flow and consume its findings.jsonl, rather than duplicating review rules.
Reuse Policy (Do Not Reimplement)
When classification/category or name changes require regenerating a product flow payload, reuse:
More from tiangong-lca/skills
process-hybrid-search
Execute and troubleshoot Supabase edge function `process_hybrid_search`, which rewrites process descriptions and calls `hybrid_search_processes` with optional filters. Use when validating process query/filter behavior, tuning retrieval prompts, or debugging auth, embedding, and RPC failures.
15flow-hybrid-search
Execute and troubleshoot Supabase edge function `flow_hybrid_search`, which rewrites flow descriptions and calls `hybrid_search_flows` with optional filters. Use when validating flow query/filter behavior, tuning retrieval prompts, or debugging auth, embedding, and RPC failures.
14embedding-ft
Execute and troubleshoot Supabase edge function `embedding_ft` that consumes PGMQ embedding jobs, calls AWS SageMaker embeddings, and writes vectors back to Postgres. Use when validating job payload handling, investigating failed embeddings, tuning ack semantics, or adjusting worker auth/environment.
13process-automated-builder
Execute the supported `process_from_flow` CLI workflow. Use `node scripts/run-process-automated-builder.mjs auto-build|resume-build|publish-build|batch-build` when you need the unified `tiangong process ...` surface from a skill wrapper.
13lifecyclemodel-hybrid-search
Execute and troubleshoot Supabase edge function `lifecyclemodel_hybrid_search`, which rewrites lifecycle model descriptions and calls `hybrid_search_lifecyclemodels` with optional filters. Use when validating lifecycle-model query/filter behavior, tuning retrieval prompts, or debugging auth, embedding, and RPC failures.
13lifecycleinventory-review
Review process-level or lifecyclemodel-level lifecycle inventory outputs from local TianGong build runs, plus frozen remote TianGong process snapshots. Use when auditing process_from_flow batches, remote process rows fetched through the canonical snapshot wrapper, or lifecyclemodel build artifacts through the unified CLI with reproducible review inputs and outputs.
10