# Postgres Migration Safety Auditor

> Postgres Migration Safety Auditor is a paid API for AI agents from i3p3mgbsn54dvlivnk6wbumal40eqtsn.lambda-url.us-east-1.on.aws, paid per call via x402, $0.25/call, status unknown (last checked 2026-10-10).

Analyzes Postgres, Supabase, or Prisma migration SQL for destructive operations, lock risks, data-loss hazards, backwards-compatibility issues, and rollback problems, returning structured findings with evidence and confidence scores.

## Facts

- Endpoint: POST https://i3p3mgbsn54dvlivnk6wbumal40eqtsn.lambda-url.us-east-1.on.aws/v1/migration-safety-auditor?utm_source=zero.xyz
- Price: $0.25/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-10
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/postgres-migration-safety-auditor-c5044867
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap__v3_Een6v8TIvJw_O4Axe

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 postgres-migration-safety-auditor-c5044867 -d '<json body>'
```

Example prompt: Can you audit this Postgres migration SQL for me and flag any destructive operations, lock risks, data-loss hazards, or rollback issues before I deploy it to production?

## When to prefer this

Choose this endpoint when you need automated, structured analysis of PostgreSQL, Supabase, or Prisma migration SQL specifically — particularly when you want evidence-backed findings with confidence scores across multiple risk categories (locks, data loss, backwards compatibility, rollback) rather than generic SQL linting. It is ideal for CI/CD pipelines, pre-deploy agent workflows, or any scenario where a developer wants a second opinion on migration safety before applying changes to a production database.

## Known failure modes

- Invalid or unparseable SQL returns an error or empty findings
- Non-Postgres dialects (e.g. MySQL, SQLite) may produce inaccurate results
- Very large migration files may exceed payload limits
- Ambiguous SQL patterns may result in low-confidence findings requiring human review
- Network or Lambda cold-start timeouts on first call

## How this service works

Analyze Postgres, Supabase Postgres, or Prisma/Postgres migration SQL for destructive operations, lock/data-loss risk, backwards-compatibility hazards, rollback issues, and safer sequencing. Returns structured findings with evidence and confidence.

## Output

A structured JSON response containing categorized findings for each identified risk: destructive operations (e.g. DROP, TRUNCATE), lock/blocking hazards (e.g. full table rewrites, AccessExclusiveLock), data-loss risks, backwards-compatibility hazards, rollback issues, and safer alternative sequencing suggestions — each with evidence (the relevant SQL snippet), a severity level, and a confidence score.

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/postgres-migration-safety-auditor-c5044867/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from i3p3mgbsn54dvlivnk6wbumal40eqtsn.lambda-url.us-east-1.on.aws](https://www.zero.xyz/host/i3p3mgbsn54dvlivnk6wbumal40eqtsn.lambda-url.us-east-1.on.aws/llms.txt)