Error Diagnosis Agent
Explains why a query failed and how to fix it.
What you provide
- SQL that failed and the error message (both required).
- Connection, if you choose one: the diagnosis can check column and table names against the real schema. Without one, choose the Engine.
What you get
- A category: Syntax, Permission, Reference (a missing table or column), Data type, Constraint, Connection or Unknown, with the root cause under its own heading.
- The root cause.
- Corrected SQL when it can be written, and the steps to fix the problem.