Migration Blast Radius

Live 402 challenge

Captured by the enrichment pass, not read just now. Prices can change — always read the 402 the endpoint answers with.

{
  "error": "Payment required",
  "accepts": [
    {
      "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
      "extra": {
        "name": "USD Coin",
        "version": "2"
      },
      "payTo": "0x25e8245f07d5e4873987293dad666afbe56a9608",
      "amount": "300000",
      "scheme": "exact",
      "network": "eip155:8453",
      "maxTimeoutSeconds": 60
    }
  ],
  "resource": {
    "url": "https://api.zfinia.com/x402/v1/sql-migration-blast-radius",
    "tags": [
      "sql",
      "database migration",
      "deployment risk",
      "release gate",
      "developer tooling"
    ],
    "mimeType": "application/json",
    "description": "Read migration statements and report what each one touches and what it costs. Names the statements that rewrite a table, the ones that scan every row while holding a lock, the ones that discard data irreversibly, and the renames that break every client still deployed with the old name the instant they commit. Reports tables and columns touched so a reviewer can see the reach of a migration without reading every statement.",
    "serviceName": "Migration Blast Radius"
  },
  "extensions": {
    "bazaar": {
      "info": {
        "input": {
          "body": {
            "migration": "ALTER TABLE orders ALTER COLUMN id TYPE bigint;\nALTER TABLE orders ALTER COLUMN customer_id TYPE bigint;\nALTER TABLE orders ALTER COLUMN status SET NOT NULL;\nALTER TABLE orders ADD COLUMN currency char(3) NOT NULL;\nALTER TABLE orders DROP COLUMN internal_ref;\nALTER TABLE orders RENAME COLUMN placed_at TO created_at;\nCREATE INDEX orders_status_idx ON orders (status);"
          },
          "type": "http",
          "method": "POST",
          "bodyType": "json"
        },
        "output": {
          "type": "json",
          "example": {
            "limits": {
              "maxTables": 400,
              "maxDdlBytes": 262144,
              "maxFindings": 500,
              "maxStatements": 2000,
              "maxColumnsPerTable": 500
            },
            "passed": false,
            "complete": true,
            "findings": [
              {
                "code": "TABLE_REWRITE",
                "table": "orders",
                "detail": "alter_column_type on orders.id rewrites the table. Changing a column type rewrites the table and every index on it, blocking readers and writers for the duration.",
                "blocking": "full-rewrite",
                "operation": "alter_column_type"
              },
              {
                "code": "TABLE_REWRITE",
                "table": "orders",
                "detail": "alter_column_type on orders.customer_id rewrites the table. Changing a column type rewrites the table and every index on it, blocking readers and writers for the duration.",
                "blocking": "full-rewrite",
                "operation": "alter_column_type"
              },
              {
                "code": "FULL_TABLE_SCAN_LOCK",
                "table": "orders",
                "detail": "set_not_null on orders.status scans every row while holding a lock. Setting NOT NULL scans every row to verify it, holding a lock that blocks writers for the scan.",
                "blocking": "full-scan",
                "operation": "set_not_null"
              }
            ],
            "low_risk": false,
            "request_id": "example-request",
            "service_id": "sql_migration_blast_radius",
            "assumptions": [
              "Lock behaviour is stated for current PostgreSQL and MySQL 8 defaults. An older server rewrites the table for operations listed here as brief, so a stated profile is a floor rather than a promise.",
              "Adding a nullable column with no default is treated as a catalogue change, because both engines have done it that way for several major versions.",
              "An index build is counted as blocking unless concurrent_index_builds says otherwise, since the non-concurrent form is the default spelling."
            ],
            "limitations": [
              "Only the declared schema is read. No database is contacted and no rows are seen, so nothing here reports whether a migration will succeed against the data actually present.",
              "DDL is read as a documented subset: CREATE TABLE, ALTER TABLE, CREATE and DROP INDEX, DROP TABLE, TRUNCATE, GRANT and REVOKE. Anything else — a view, function, trigger or data statement — is listed in...",
              "Statement order is read as given. Whether the migration runs in one transaction, and therefore whether a later failure rolls back an earlier statement, is not declared in the DDL and is not inferred."
            ],
            "observed_at": "2026-10-02T00:00:00.000Z",
            "not_examined": [],
            "finding_count": 7,
            "tables_touched": [
              "orders"
            ],
            "columns_touched": [
              "orders.currency",
              "orders.customer_id",
              "orders.id"
            ],
            "operations_read": 7,
            "service_version": "1.0.0",
            "statement_count": 7,
            "findings_by_code": {
              "TABLE_REWRITE": 2,
              "FULL_TABLE_SCAN_LOCK": 2,
              "DESTRUCTIVE_AND_IRREVERSIBLE": 1,
              "RENAME_BREAKS_IN_FLIGHT_CLIENTS": 1,
              "REQUIRED_COLUMN_ADDED_WITHOUT_DEFAULT": 1
            },
            "destructive_count": 1,
            "irreversible_count": 1,
            "operations_by_kind": {
              "add_column": 1,
              "drop_column": 1,
              "create_index": 1,
              "set_not_null": 1,
              "rename_column": 1,
              "alter_column_type": 2
            },
            "table_rewrite_count": 2
          }
        }
      },
      "schema": {
        "type": "object",
        "$schema": "https://json-schema.org/draft/2020-12/schema",
        "required": [
          "input"
        ],
        "properties": {
          "input": {
            "type": "object",
            "required": [
              "type",
              "method",
              "bodyType",
              "body"
            ],
            "properties": {
              "body": {
                "type": "object",
                "required": [
                  "migration"
                ],
                "properties": {
                  "migration": {
                    "type": "string",
                    "maxLength": 262144
                  },
                  "concurrent_index_builds": {
                    "type": "boolean"
                  }
                },
                "additionalProperties": false
              },
              "type": {
                "type": "string",
                "const": "http"
              },
              "method": {
                "enum": [
                  "POST"
                ],
                "type": "string"
              },
              "bodyType": {
                "enum": [
                  "json",
                  "form-data",
                  "text"
                ],
                "type": "string"
              }
            },
            "additionalProperties": false
          },
          "output": {
            "type": "object",
            "required": [
              "type"
            ],
            "properties": {
              "type": {
                "type": "string"
              },
              "example": {
                "type": "object"
              }
            }
          }
        }
      }
    }
  },
  "x402Version": 2
}

Accepts

The payment requirements as published to the catalog. Read the live 402 before paying — a price here is a claim, not a quote.

[
  {
    "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
    "extra": {
      "name": "USD Coin",
      "version": "2"
    },
    "payTo": "0x25e8245f07d5e4873987293dad666afbe56a9608",
    "amount": "300000",
    "scheme": "exact",
    "network": "eip155:8453",
    "maxTimeoutSeconds": 60
  }
]

Extensions

{
  "bazaar": {
    "info": {
      "input": {
        "body": {
          "migration": "ALTER TABLE orders ALTER COLUMN id TYPE bigint;\nALTER TABLE orders ALTER COLUMN customer_id TYPE bigint;\nALTER TABLE orders ALTER COLUMN status SET NOT NULL;\nALTER TABLE orders ADD COLUMN currency char(3) NOT NULL;\nALTER TABLE orders DROP COLUMN internal_ref;\nALTER TABLE orders RENAME COLUMN placed_at TO created_at;\nCREATE INDEX orders_status_idx ON orders (status);"
        },
        "type": "http",
        "method": "POST",
        "bodyType": "json"
      },
      "output": {
        "type": "json",
        "example": {
          "limits": {
            "maxTables": 400,
            "maxDdlBytes": 262144,
            "maxFindings": 500,
            "maxStatements": 2000,
            "maxColumnsPerTable": 500
          },
          "passed": false,
          "complete": true,
          "findings": [
            {
              "code": "TABLE_REWRITE",
              "table": "orders",
              "detail": "alter_column_type on orders.id rewrites the table. Changing a column type rewrites the table and every index on it, blocking readers and writers for the duration.",
              "blocking": "full-rewrite",
              "operation": "alter_column_type"
            },
            {
              "code": "TABLE_REWRITE",
              "table": "orders",
              "detail": "alter_column_type on orders.customer_id rewrites the table. Changing a column type rewrites the table and every index on it, blocking readers and writers for the duration.",
              "blocking": "full-rewrite",
              "operation": "alter_column_type"
            },
            {
              "code": "FULL_TABLE_SCAN_LOCK",
              "table": "orders",
              "detail": "set_not_null on orders.status scans every row while holding a lock. Setting NOT NULL scans every row to verify it, holding a lock that blocks writers for the scan.",
              "blocking": "full-scan",
              "operation": "set_not_null"
            }
          ],
          "low_risk": false,
          "request_id": "example-request",
          "service_id": "sql_migration_blast_radius",
          "assumptions": [
            "Lock behaviour is stated for current PostgreSQL and MySQL 8 defaults. An older server rewrites the table for operations listed here as brief, so a stated profile is a floor rather than a promise.",
            "Adding a nullable column with no default is treated as a catalogue change, because both engines have done it that way for several major versions.",
            "An index build is counted as blocking unless concurrent_index_builds says otherwise, since the non-concurrent form is the default spelling."
          ],
          "limitations": [
            "Only the declared schema is read. No database is contacted and no rows are seen, so nothing here reports whether a migration will succeed against the data actually present.",
            "DDL is read as a documented subset: CREATE TABLE, ALTER TABLE, CREATE and DROP INDEX, DROP TABLE, TRUNCATE, GRANT and REVOKE. Anything else — a view, function, trigger or data statement — is listed in...",
            "Statement order is read as given. Whether the migration runs in one transaction, and therefore whether a later failure rolls back an earlier statement, is not declared in the DDL and is not inferred."
          ],
          "observed_at": "2026-10-02T00:00:00.000Z",
          "not_examined": [],
          "finding_count": 7,
          "tables_touched": [
            "orders"
          ],
          "columns_touched": [
            "orders.currency",
            "orders.customer_id",
            "orders.id"
          ],
          "operations_read": 7,
          "service_version": "1.0.0",
          "statement_count": 7,
          "findings_by_code": {
            "TABLE_REWRITE": 2,
            "FULL_TABLE_SCAN_LOCK": 2,
            "DESTRUCTIVE_AND_IRREVERSIBLE": 1,
            "RENAME_BREAKS_IN_FLIGHT_CLIENTS": 1,
            "REQUIRED_COLUMN_ADDED_WITHOUT_DEFAULT": 1
          },
          "destructive_count": 1,
          "irreversible_count": 1,
          "operations_by_kind": {
            "add_column": 1,
            "drop_column": 1,
            "create_index": 1,
            "set_not_null": 1,
            "rename_column": 1,
            "alter_column_type": 2
          },
          "table_rewrite_count": 2
        }
      }
    },
    "schema": {
      "type": "object",
      "$schema": "https://json-schema.org/draft/2020-12/schema",
      "required": [
        "input"
      ],
      "properties": {
        "input": {
          "type": "object",
          "required": [
            "type",
            "method",
            "bodyType",
            "body"
          ],
          "properties": {
            "body": {
              "type": "object",
              "required": [
                "migration"
              ],
              "properties": {
                "migration": {
                  "type": "string",
                  "maxLength": 262144
                },
                "concurrent_index_builds": {
                  "type": "boolean"
                }
              },
              "additionalProperties": false
            },
            "type": {
              "type": "string",
              "const": "http"
            },
            "method": {
              "enum": [
                "POST"
              ],
              "type": "string"
            },
            "bodyType": {
              "enum": [
                "json",
                "form-data",
                "text"
              ],
              "type": "string"
            }
          },
          "additionalProperties": false
        },
        "output": {
          "type": "object",
          "required": [
            "type"
          ],
          "properties": {
            "type": {
              "type": "string"
            },
            "example": {
              "type": "object"
            }
          }
        }
      }
    }
  }
}

Provenance

Seen in the source catalog

2026-10-05 02:07Z

Last indexed by Roundhouse

2026-10-09 12:50Z

Last enriched (probe, favicon, geo)

2026-10-05 09:45Z

x402 version

2

Max timeout

60s

Liveness probe

HTTP 402