# Anti Patterns

> Flags migration anti-patterns (performance, architecture/security, behavior) by running `scai assessment anti-patterns`, which buckets SnowConvert's recorded issue codes and writes JSON for the assessment multi-report. Supports SQL Server and Redshift.

- Skill: `snowflake-labs/anti-patterns` (Agent Skill)
- Install (CLI): `npx skillmds@latest add snowflake-labs/anti-patterns`
- Raw SKILL.md: https://api.skillmd.com/api/skills/snowflake-labs/anti-patterns/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- License: Proprietary. See License-Skills for complete terms
- Author: snowflake-labs (https://skillmd.com/u/snowflake-labs)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/snowflake-labs/anti-patterns

---


# 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` — report `skipped`, not an error.

## Run

```bash
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**:

```json
{
  "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_json` `null`, `error` `null`.
- Any other failure: `status` `"error"`, `output_json` `null`, `error` `"<message>"`.