Skip to main content

AI SQL Diagnosis

When SQL execution fails, 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

Before you begin​

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

Procedure​

  1. Execute the target SQL in the SQL Console.
  2. After the error appears in the execution panel, click AI Diagnosis.
  3. NineData opens the ChatDBA panel in 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

Result​

ChatDBA opens with the SQL error context and returns an explanation plus suggested checks. Confirm the recommendation before you change SQL, permissions, object definitions, or production data.

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.