Failed to run migrations: syntax error at or near ")" - how to get position of error is diesel migration?

[kairoswater-jason]

Is there any way to get the line number of a migration error in diesel?

The below was produced using the cli tool to run a migration containing an unknown error

Failed to run migrations: Failed to run 2025-08-27-111711_initial with: syntax error at or near ")"

I suspect it is probably not feasible to get more detailed error information from diesel. (I ended up running my migration in an external tool to find the error)

[weiznich]

Due to the missing context it's almost impossible to answer anything here. It's unclear how you run migrations and which database system you are using.

Assuming you use Postgres and diesel-cli there is currently no good way to get better information there. We would welcome contributions to improve that. Practically speaking the relevant error position is emitted by this part of the returned error type. What would need to be done is to convert the migration code in diesel-cli to use something like miette for error handling and construct a good error message based on the provided information there. There is sometimes also additional help in that message that might be useful to emit.

We would be quite happy to see a PR for this.