{"uid":"cap_vOI_tWIiqdeoiIfqQNDBA","slug":"migration-blast-radius-76088f4e","name":"Migration Blast Radius","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.","url":"https://api.zfinia.com/x402/v1/sql-migration-blast-radius?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"migration":{"type":"string","maxLength":262144},"concurrent_index_builds":{"type":"boolean"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.3","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.3/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.3","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.3","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_FzH3s6cwShSur2f5jFXZe","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.3","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes SQL migration statements to identify which tables/columns are touched, what operations are destructive or lock-holding, and which renames will break live clients.","exampleAgentPrompt":"Can you analyze this migration script and tell me which statements will lock or rewrite tables, which ones drop data irreversibly, and which renames will break clients the moment they run?","exampleUseCases":[{"title":"Pre-deploy migration safety review","prompt":"I've got this big SQL migration I'm about to run in production — can you check it for statements that will lock tables, rewrite them entirely, or drop data permanently, and list every table and column it touches?"},{"title":"Catching client-breaking renames before release","prompt":"We're deploying a migration tonight that has some column and table renames — can you tell me which of those renames will immediately break any client still running the old code once the migration commits?"},{"title":"CI gating for destructive migrations","prompt":"Here's the migration from our PR — flag any statements that scan every row while holding a lock or that discard data irreversibly so our reviewer knows what needs extra sign-off before merge."}],"resultDescription":"Returns a structured report listing each migration statement alongside what it costs (table rewrite, full-scan with lock, irreversible data loss, client-breaking rename), plus an aggregated list of all tables and columns touched by the migration as a whole.","failureModes":["Migration SQL exceeds 262144 character limit — request rejected","Malformed or unparseable SQL — parser error returned","Empty migration body — validation error","Ambiguous dialect-specific syntax may produce incomplete analysis"],"whenToPreferThis":"Use this endpoint when you need a fast, automated pre-deploy review of a SQL migration to surface lock contention, destructive operations, full-table rewrites, and breaking renames without manually reading every statement. Ideal for CI pipelines, pull request review bots, or any agent that needs to gate or annotate migrations before they reach production.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:36:26.412Z","isFirstParty":false,"canonicalSlug":"migration-blast-radius-76088f4e"}