Discovers which stored procedures write to a target table, analyzes each candidate via the procedure analysis reference (call graph resolution, statement classification, persistence), resolves which writer owns the table, and persists the scoping decision to the table catalog file. This skill determines the selected_writer that all downstream skills (profiling, test generation, model generation) depend on.

/scoping-table <schema.table>

Argument is the fully-qualified table name (e.g., silver.DimCustomer, [dbo].[FactSales]). The skill asks if missing.

• manifest.json must exist in the project root. If missing, run Command Setup DDL first.
• catalog/tables/<table>.json must exist. If missing, run /listing-objects list tables to see available tables.

Reads catalog/tables/<table>.json and presents the column list with types and nullability.

uv run --project <shared-path> discover refs --name <table>

Extracts the writers array from the output. If no writers are found, persists no_writer_found to catalog and stops.

For each writer candidate, follows the procedure analysis reference (references/procedure-analysis.md). This runs a 6-step pipeline per candidate:

1. Fetch object data — discover show --name <proc> returns refs, statements, classification, raw_ddl
2. Classify statements — deterministic (AST) or claude_assisted (LLM-based from raw_ddl)
3. Resolve call graph — follow refs to base tables via recursive discover show
4. Logic summary — plain-language explanation of what the procedure does
5. Migration guidance — tag each statement as migrate or skip
6. Persist resolved statements — write to catalog/procedures/<proc>.json

If there are multiple candidates, they are analyzed sequentially.

Displays a summary of each analyzed candidate:

Writer candidates for silver.DimCustomer:

  1. dbo.usp_load_dimcustomer_full (direct writer)
     Reads: bronze.Customer, bronze.Person
     Writes: silver.DimCustomer
     Statements: 1 migrate, 1 skip

  2. dbo.usp_load_dimcustomer_delta (direct writer)
     Reads: bronze.Customer, silver.DimCustomer
     Writes: silver.DimCustomer
     Statements: 1 migrate (MERGE)

The skill waits for explicit user confirmation before proceeding.

Writes scoping JSON via a temp file to avoid shell quoting issues:

mkdir -p .staging
# Write scoping JSON to .staging/scoping.json
uv run --project <shared-path> discover write-scoping \
  --name <table> --scoping-file .staging/scoping.json; rm -rf .staging

Written during procedure analysis (Step 3). Each statement has action (migrate/skip), source (ast/llm), sql, and optionally rationale.

{
  "scoping": {
    "status": "resolved",
    "selected_writer": "silver.usp_load_dimcustomer",
    "selected_writer_rationale": "Only writer found for silver.DimCustomer. Performs TRUNCATE + INSERT from bronze sources.",
    "candidates": [
      {
        "procedure_name": "silver.usp_load_dimcustomer",
        "dependencies": {
          "tables": ["bronze.customer", "bronze.person"],
          "views": [],
          "functions": []
        },
        "rationale": "Direct writer: INSERT INTO silver.DimCustomer"
      }
    ]
  }
}

{
  "scoping": {
    "status": "no_writer_found",
    "selected_writer": null,
    "selected_writer_rationale": "No procedures found that write to this table."
  }
}