{"uid":"cap__v3_Een6v8TIvJw_O4Axe","slug":"postgres-migration-safety-auditor-c5044867","name":"Postgres Migration Safety Auditor","description":"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.","url":"https://i3p3mgbsn54dvlivnk6wbumal40eqtsn.lambda-url.us-east-1.on.aws/v1/migration-safety-auditor?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":null,"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.25","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","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.25/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.25","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.25","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_7E4cKTMOSst0lSPa-ogC5","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.25","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"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.","exampleAgentPrompt":"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?","exampleUseCases":[{"title":"Pre-deploy production migration check","prompt":"I have a migration that drops a column and renames a table — can you audit this SQL for lock risks, data loss, and backwards compatibility issues before I push it to our production Postgres database?"},{"title":"Supabase migration safety review","prompt":"We're using Supabase and I want to make sure this migration file won't cause downtime or data loss — can you analyze it for destructive operations, table locks, and rollback problems?"},{"title":"Prisma schema migration audit","prompt":"I generated this migration SQL from a Prisma schema change that adds a NOT NULL column — can you check it for data-loss risk, lock hazards, and whether it's safe to roll back if something goes wrong?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-10T12:38:23.441Z","isFirstParty":false,"canonicalSlug":"postgres-migration-safety-auditor-c5044867"}