Fix with AI (Available only in Enterprise Edition)

When the editor detects a mistake (for example, a syntax error or an invalid column reference), it immediately underlines the problematic code. You can hover over the marked code to view a detailed error description, allowing you to catch and fix mistakes instantly.

Supported AI Providers

In Navicat Data Modeler, AI Assistant relies on external AI providers to complete tasks. To use the AI Assistant feature, you need an account from an AI provider. Here is the list of AI providers currently supported by Navicat Data Modeler:

• OpenAI ChatGPT

• Google Gemini

• DeepSeek

• Ollama

• xAI Grok

• Anthropic Claude

• Alibaba Qwen

• ByteDance Doubao

• Moonshot Kimi

• LM Studio

• Any AI compatible with OpenAI

Enable & Configure AI Assistant

Navicat Data Modeler provides users with the ability to enable and configure multiple AI Assistants. Here’s a comprehensive guide on how to do this effectively:

• In the menu bar, choose Tools -> Options.

• In the Options window, select AI and enable Enable AI Assistant.

• Click + and choose an AI provider to add an Assistant.

• Enter the AI Assistant information. See Options for details.

• Click OK.

Obtain Fix Suggestion

You can ask AI to debug the query and suggest a possible fix.

• Hover over the error code and click Fix with AI.

• Choose your AI Assistant and click OK.

• The AI will instantly generate a fix suggestion.

  Hint: By default, differences are highlighted. You can control-click on the pane and uncheck Show Diff to turn off the highlighting.

• You can choose one of the following options for applying the code to the editor:

  Option	Description
  Append to Editor	Add the code to the end of the existing content.
  Replace All in Editor	Clear the existing content and replace it entirely with the new code.
  Replace Selection in Editor	Clear the selected content and replace it with the new code.