sqlmc_list_coverage: Worked exchange

Call 1 — plan.

Last updated 2026-10-21

Call 1 — plan.

Call 1, the plan: scanned is 0 and confirmationRequired is true, with the token to send back.
Call 1, the plan: scanned is 0 and confirmationRequired is true, with the token to send back.
{ "name": "sqlmc_list_coverage",
  "arguments": { "distributionList": "All Prod",
                 "workspace": "C:\\repos\\estate\\Estate.smcworkspace" } }

Returns confirmationRequired: true, confirmationToken: "a41f…", targetCount: 12, and four production targets named. Nothing has been connected to.

Call 2 — scan.

{ "name": "sqlmc_list_coverage",
  "arguments": { "distributionList": "All Prod",
                 "workspace": "C:\\repos\\estate\\Estate.smcworkspace",
                 "confirmationToken": "a41f…" } }
{
  "ok": true, "errors": [],
  "listName": "All Prod",
  "confirmationRequired": false, "confirmationToken": null,
  "targetCount": 12, "alreadyCached": 12,
  "productionTargets": [ … ],
  "scanned": 12, "failed": 0, "cancelled": false,
  "findings": [
    { "schema": "dbo", "name": "CustomerNote", "column": null,
      "drift": { "missingFrom": ["sql-prod-09.Sales"], "scanned": 12, "typeVariants": [] } },
    { "schema": "sales", "name": "OrderHeader", "column": "Total",
      "drift": { "missingFrom": [], "scanned": 12,
                 "typeVariants": [
                   { "dataType": "decimal(18,2)", "targets": ["sql-prod-01.Sales"] },
                   { "dataType": "money", "targets": ["sql-prod-02.Sales"] }
                 ] } }
  ]
}

If the group changed between the two calls, call 2 returns a new plan with confirmationRequired: true and a different token, and nothing was read. Do not retry with the old token; present the new plan.