About AI Assistant (Available only in Enterprise and Standard Edition)

AI Assistant is a generative artificial intelligence (AI) powered conversational assistant that provides users with real-time suggestions and guidance while writing queries using natural language processing technology. It can chat queries, generate new statements, and perform query upgrades and improvements such as language updates, debugging, and optimization. AI Assistant helps users quickly access support for syntax, expressions, keywords, and more, ultimately improving query efficiency and accuracy.

AI Assistant can be accessed via the AI Chat pane located in the main window. This feature is seamlessly integrated with various components, including queries, views, and functions, enhancing user interaction and productivity.

With AI Assistant in Navicat, you can:

• Interact with your databases using natural language.

• Generate query statements.

• Fix code mistakes.

• Optimize, explain, format, and convert SQL queries.

• Select relevant data from your database.

• Generate table structures and comments.

• Populate table data.

Supported AI Providers

In Navicat, 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:

• 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 provides users with the ability to enable and configure multiple AI Assistants. Here’s a comprehensive guide on how to do this effectively:

• On the AI Chat pane, click -> Options.

• In the Options window, 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.