Skip to main content

AI SQL Formatting

AI SQL Formatting restructures selected SQL to improve readability and make review easier. It helps organize long joins, subqueries, and conditional logic without replacing semantic validation.

What It Does​

  • Recognizes SQL structure and reflows it into a clearer layout.
  • Improves line breaks, indentation, and keyword presentation.
  • Works especially well for joins, subqueries, and longer conditional logic.

Before you begin​

  • Open a SQL Console that supports AI formatting.
  • Make sure the editor already contains the SQL you want to format.

Procedure​

  1. Open the SQL Console for the target data source.
  2. Select the SQL statement you want to format.
  3. Trigger AI Format. Depending on the console version, the entry may appear in an AI-related action area or in the right-click menu.
  4. Review the formatted result and continue editing or save it for later use.

Result​

NineData returns a formatted SQL draft with clearer line breaks, indentation, and keyword layout. Review the formatted statement before execution to confirm that comments, placeholders, and statement boundaries still match your intent.