{"slug":"api-aiskills402-com-v1-skills-postgres-migration-lock-review-0ee223","title":"PostgreSQL Migration Lock Review — Reviews ONE PostgreSQL migration file for the","host":"api.aiskills402.com","method":"GET","resource":"https://api.aiskills402.com/v1/skills/postgres-migration-lock-review/file","category":"code","description":"PostgreSQL Migration Lock Review — Reviews ONE PostgreSQL migration file for the four statements that lock or rewrite a table that is already in use, and lists only those, one line each with a fixed code, the statement, why it hurts and the fix - or exactly No findings. It catches CREATE INDEX witho","price_listed":0.01,"price_asked":0.01,"state":"answering","state_label":"Answering","checks_7d":3,"answered_7d":3,"latency_ms_median":373,"reported_calls_30d":1,"reported_payers_30d":1,"networks":["eip155:8453"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"method":"GET","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"headers":{"additionalProperties":{"type":"string"},"type":"object"},"method":{"enum":["GET","HEAD"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method"],"type":"object"},"output":{"properties":{"example":{"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-10-31","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.01,"price_match":true,"latency_ms":381,"error":null},{"day":"2026-10-29","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.01,"price_match":true,"latency_ms":366,"error":null},{"day":"2026-10-27","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.01,"price_match":true,"latency_ms":373,"error":null}],"description_full":"PostgreSQL Migration Lock Review — Reviews ONE PostgreSQL migration file for the four statements that lock or rewrite a table that is already in use, and lists only those, one line each with a fixed code, the statement, why it hurts and the fix - or exactly No findings. It catches CREATE INDEX without CONCURRENTLY on an existing table, a not-null or constraint check run in one blocking step, a column type change or volatile default that rewrites the table, and a drop or rename of a column that …","last_updated":"2026-10-27T08:01:48.229Z","schemes":["exact"]}