{"uid":"cap_TfOGndftb2s9a71IUMwcM","slug":"sql-schema-change-risk-analyzer-ef63761f","name":"SQL Schema-Change Risk Analyzer","description":"An autonomous paid API accepting USDC on Base mainnet.","url":"https://47-85-47-24.sslip.io/v1/analyze","method":"GET","headers":{},"bodySchema":{"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_writeback":{"type":"object"}}}}}}},"responseSchema":{"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":[]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_h8xdFnkZSn4p71bkJg5N3","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes SQL CREATE TABLE schema changes for risk, blast radius, migration safety, and generates a safe patch and rollout plan","exampleAgentPrompt":"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.","exampleUseCases":null,"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-13T18:48:35.104Z","isFirstParty":false}