Using AI Features in SQLWays

SQLWays provides integrated AI tools that can assist with analyzing migration files, identifying potential conversion issues, and generating code improvement suggestions.

The following AI features are available:

• Project Prompt — defines project-specific instructions applied to AI requests.
• AI Chat — allows users to ask questions and analyze migration files.
• AI Suggestion — analyzes the currently opened file and proposes code changes.

AI-generated results should always be reviewed before they are applied to migration files.

To configure AI functionality:

1. Open Global Settings.
2. Locate the AI Features section.
3. Enable AI Features.
4. Enable File Access if the AI model needs to analyze source or converted project files.
5. Select an AI provider.
6. Specify the provider URL.
7. Click Connect.
8. Select the Main model and Sub-agent model.
9. Click Save AI Settings.

Supported providers may include:

• Ollama
• Ollama Cloud
• Gemini
• Vertex AI
• Other OpenAI-compatible providers

After a successful connection, SQLWays displays the number of available models.

The Main model generates the primary AI responses. The Sub-agent model is used for supporting file analysis and code-reading tasks.

An application restart is not required after saving the settings.

Enable File Access when AI tools need to read files from the migration project.

File Access is required for tasks such as:

• Analyzing the currently opened file
• Reviewing source or converted code
• Analyzing multiple project objects
• Generating changes with AI Suggestion

When File Access is disabled, AI Chat can answer general questions but cannot inspect project files.

The Project Prompt defines common instructions for AI requests within the current project.

It can contain:

• Naming conventions
• Coding standards
• Target database requirements
• Project-specific migration rules
• Instructions for presenting recommendations

To configure it:

1. Open the migration project.
2. Click Project Prompt in the project toolbar.
3. Enter the required instructions.
4. Click Save.

For example:

Use uppercase names for all columns.
Check the converted code for target database compatibility.
Preserve the original object logic.
Explain all proposed changes.

The Project Prompt applies to both AI Chat and AI Suggestion within the current project.

AI Chat provides an interactive interface for working with the configured AI model.

It can be used to:

• Analyze migration files
• Review converted SQL code
• Identify compatibility issues
• Investigate conversion results
• Request recommendations
• Ask general migration-related questions

To open AI Chat, click AI Chat in the project toolbar.

Click + New Chat, enter a request, and press Enter or use the send button.

The Chat mode is intended for standard questions and focused analysis.

Example requests:

Analyze the currently opened file and identify unsupported target database syntax.
Review all converted views and list objects that may require manual correction.
Explain the purpose of this procedure and identify possible conversion issues.

The requested analysis scope should be specified in the message. AI Chat can analyze:

• The currently opened file
• Files of a specific object type
• The entire migration project

The File Analysis mode performs a more detailed analysis using the configured Main model and Sub-agent model.

The generated report may include:

• Passing Items — successfully completed checks
• Critical Issues — problems that may prevent the code from working correctly
• Warnings — potential risks requiring review
• Recommendations — suggested corrections or next steps

Use File Analysis for complex objects, multi-file reviews, or project-wide compatibility checks.

Chats are saved within the current project and displayed under Recent chats.

Users can reopen, continue, or delete previous chats. Chat renaming is currently not supported.

AI Suggestion analyzes the currently opened file and generates proposed code changes.

To use it:

1. Open a file in the File editor.
2. Click AI Suggestion in the editor toolbar.
3. Optionally, enter additional instructions.
4. Click Submit.

For example:

Check the file for unsupported target database syntax and correct the identified issues.

The result is displayed as a diff containing:

• CURRENT — the existing file content
• AI SUGGESTION — the proposed changes

The following actions are available:

Review the complete diff before selecting Accept All.

AI Suggestion currently does not support accepting individual changes separately. When only part of a suggestion is required, apply the necessary modifications manually in the File editor.

For more accurate and relevant AI results:

1. Add clear project requirements to the Project Prompt.
2. Specify the analysis scope in each request.
3. Use File Analysis for complex or multi-file reviews.
4. Review all generated changes before accepting them.
5. Verify that the modified code preserves the original logic.
6. Validate saved changes against the target database.
7. Save AI settings after changing the provider or model.

AI functionality supplements the standard SQLWays conversion and validation process. It should not replace manual review and target environment testing.