# Migration Blast Radius

> Migration Blast Radius is a paid API for AI agents from api.zfinia.com, paid per call via x402, $0.3/call, status unknown (last checked 2026-10-11).

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.

## Facts

- Endpoint: POST https://api.zfinia.com/x402/v1/sql-migration-blast-radius?utm_source=zero.xyz
- Price: $0.3/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-11
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/migration-blast-radius-76088f4e
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_vOI_tWIiqdeoiIfqQNDBA

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 migration-blast-radius-76088f4e -d '<json body>'
```

Example prompt: 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?

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "migration": {
   "type": "string",
   "maxLength": 262144
  },
  "concurrent_index_builds": {
   "type": "boolean"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/migration-blast-radius-76088f4e/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from api.zfinia.com](https://www.zero.xyz/host/api.zfinia.com/llms.txt)