Skip to main content

AI SQL Diagnosis

When SQL execution fails, you can use AI Diagnosis to let ChatDBA analyze the error and suggest possible next steps.

Common Scenarios​

  • SQL syntax errors
  • Missing or incorrect object references
  • Permission issues
  • Data type incompatibility
  • Version or SQL dialect differences

Prerequisites​

  • Open the SQL Console for the target data source.
  • Execute the target SQL and make sure the console has returned an error message.

Steps​

  1. Execute the target SQL in the SQL Console.
  2. After the error appears in the execution panel, click AI Diagnosis.
  3. The system opens the ChatDBA panel on the right side of the SQL Console and passes the error context into it.
  4. Review the AI analysis and suggested actions.
  5. If you need deeper troubleshooting, continue the conversation in the same session and add more context, such as the data source type, object names, or expected result.

What You Usually Get Back​

  • A plain-language explanation of the error
  • Possible root causes
  • Recommended checks or fixes
  • Follow-up troubleshooting suggestions

Tips​

  • AI Diagnosis does not directly change SQL or database objects. Confirm the suggestions before acting on them.
  • If you want the diagnosis to incorporate internal documentation or standards, configure Knowledge Base Management first.