detect_conflicts
Identifies structural conflicts between two SQL migrations, including same-table edits, column changes, lock contention, and drop dependencies. Helps determine safe ordering or concurrent execution.
Instructions
Detect structural conflicts between two SQL migration files — same-table modifications, same-column changes, lock contention, and drop dependencies. Use this when two migrations touch the same schema objects and you need to know if ordering or concurrent execution matters. Note: only structural conflicts are detected (same table/column); semantic conflicts such as two migrations adding different indexes on the same column are not reported.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql_a | Yes | SQL content of the first migration | |
| sql_b | Yes | SQL content of the second migration | |
| filename_a | Yes | First migration filename (e.g., V3__add_email.sql) | |
| filename_b | Yes | Second migration filename (e.g., V4__modify_users.sql) |