sqlmc list coverage: The JSON payload

Last updated 2026-10-21

The versioned JSON envelope from sqlmc list coverage --json, with the finding and the databases it was observed on.

Field
`list`	The target group's name
`confirmationRequired`	True when this is a refused plan and nothing was connected to
`targetCount`	How many databases the scan covers
`alreadyCached`	How many already have a schema on disk. Not a shortcut — a scan re-reads all of them, because an answer assembled from a three-week-old copy is not an observation. It says how much of the work is genuinely new
`productionTargets[]`	`{ connection, database, isProduction }`, named rather than counted
`scanned`	How many were read successfully
`failed`	How many could not be read
`cancelled`	Whether it stopped early
`findings[]`	`{ schema, name, column, drift }` — `column` is null for an object-level finding
`findings[].drift`	`{ missingFrom, scanned, typeVariants[] }` — `missingFrom` is the scanned targets' identities that lacked it, not a count; `typeVariants[]` is `{ dataType, targets[] }`

{
  "schema": 2, "command": "list coverage", "ok": true,
  "data": {
    "list": "All Prod",
    "confirmationRequired": false,
    "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"] }
                   ] } }
    ]
  },
  "errors": []
}