# SQL Schema-Change Risk Analyzer

> SQL Schema-Change Risk Analyzer is a paid API for AI agents from 47-85-47-24.sslip.io, paid per call via x402, $0.001/call, status unknown (last checked 2026-09-13).

Analyzes SQL CREATE TABLE schema changes for risk, blast radius, migration safety, and generates a safe patch and rollout plan

## Facts

- Endpoint: GET https://47-85-47-24.sslip.io/v1/analyze
- Price: $0.001/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-13
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/sql-schema-change-risk-analyzer-ef63761f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_TfOGndftb2s9a71IUMwcM

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability sql-schema-change-risk-analyzer-ef63761f
```

Example prompt: Run the destructive-customer-migration scenario through the SQL schema-change risk analyzer and tell me the verdict, risk score, any findings, the safe patch I should apply, and the recommended rollout plan.

## When to prefer this

Use this endpoint when you need an evidence-first, automated risk assessment of SQL DDL schema changes before deploying a migration — especially when you want blast radius analysis of downstream assets, a safety-checked migration patch, and a structured rollout plan, rather than a generic linter or manual review.

## Known failure modes

- Invalid or missing 'input' parameter returns a 400 error
- Unsupported scenario enum value returns a validation error
- Payment not fulfilled (402 Payment Required) if x402 payment header is missing or insufficient
- Upstream metadata graph unavailable may result in degraded context_mode (fixture instead of live)
- Network timeout for slow downstream DataHub MCP connections

## How this service works

An autonomous paid API accepting USDC on Base mainnet.

## Output

Returns a JSON object containing a review_id, dataset URN, table name, verdict (BLOCK/WARN/PASS), integer risk score (0-100), summary, list of schema changes, findings with blast radius details, a safe SQL migration patch, a step-by-step rollout plan, affected assets, and MCP trace metadata.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method"
   ],
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "GET",
      "HEAD",
      "DELETE"
     ],
     "type": "string"
    },
    "queryParams": {
     "type": "object",
     "properties": {
      "scenario": {
       "enum": [
        "destructive-customer-migration"
       ],
       "type": "string",
       "description": "Built-in paid analysis scenario"
      }
     }
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object",
     "required": [
      "review_id",
      "dataset_urn",
      "table",
      "verdict",
      "risk_score",
      "summary",
      "changes",
      "findings",
      "safe_patch",
      "rollout_plan",
      "mcp_trace",
      "context_mode"
     ],
     "properties": {
      "graph": {
       "type": "object"
      },
      "table": {
       "type": "string"
      },
      "changes": {
       "type": "array",
       "items": {
        "type": "object"
       }
      },
      "summary": {
       "type": "string"
      },
      "verdict": {
       "enum": [
        "BLOCK",
        "WARN",
        "PASS"
       ],
       "type": "string"
      },
      "findings": {
       "type": "array",
       "items": {
        "type": "object"
       }
      },
      "mcp_trace": {
       "type": "array",
       "items": {
        "type": "object"
       }
      },
      "review_id": {
       "type": "string"
      },
      "risk_score": {
       "type": "integer",
       "maximum": 100,
       "minimum": 0
      },
      "safe_patch": {
       "type": "string"
      },
      "dataset_urn": {
       "type": "string"
      },
      "context_mode": {
       "enum": [
        "fixture",
        "local",
        "request",
        "datahub-mcp-live"
       ],
       "type": "string"
      },
      "generated_at": {
       "type": "string",
       "format": "date-time"
      },
      "rollout_plan": {
       "type": "array",
       "items": {
        "type": "string"
       }
      },
      "affected_assets": {
       "type": "array",
       "items": {
        "type": "object"
       }
      },
      "datahub_write
… (truncated)
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "table": "analytics.customers",
  "changes": [],
  "summary": "Destructive schema changes reach critical downstream assets.",
  "verdict": "BLOCK",
  "findings": [],
  "mcp_trace": [],
  "review_id": "lineagelint-paid-demo",
  "risk_score": 100,
  "safe_patch": "-- expand/contract migration",
  "dataset_urn": "urn:li:dataset:(urn:li:dataPlatform:snowflake,analytics.customers,PROD)",
  "context_mode": "fixture",
  "rollout_plan": []
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/sql-schema-change-risk-analyzer-ef63761f/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from 47-85-47-24.sslip.io](https://www.zero.xyz/host/47-85-47-24.sslip.io/llms.txt)