Anti-Patterns
Thin wrapper over scai assessment anti-patterns. SCAI reads the project's Code Unit Registry, matches the already-recorded issue codes against a curated per-dialect catalog, and writes one timestamped JSON the parent assessment multi-report consumes.
- Supported dialects: SQL Server, Redshift. Any other dialect aborts with
ASM0024— reportskipped, not an error.
Run
scai assessment anti-patterns
Writes <project_dir>/artifacts/assessment/anti-patterns-YYYYMMDD_HHMMSS.json. Return that path to the parent; the multi-report auto-discovers it from --project-dir. Never parse or rewrite the file.
Sub-agent contract
On entry, call configure with project_dir from the parent's context block. Take no user prompts. On completion return JSON only:
{
"sub_skill": "anti-patterns",
"status": "ok",
"output_json": "<abs path to anti-patterns-*.json>",
"summary": "<one-line: buckets, distinct flags, code units affected>",
"error": null
}
- Unsupported dialect (
ASM0024):status"skipped",output_jsonnull,errornull. - Any other failure:
status"error",output_jsonnull,error"<message>".