Database AI Assistant

The optional assistant can explain database behavior, draft engine-specific queries, interpret errors, and use the discovered schema and current editor SQL as context. Supported providers are OpenAI, Gemini, and Ollama.

Configure a Provider

Configure an AI provider in SSH Bridge, including its model and API key or Ollama endpoint. Return to the database window and click the sparkle button to show the assistant panel.

Ask a Database Question

1. Open the relevant database and query tab.
2. Ask a question such as Explain this query, Write a query for orders created today, or Why did this statement fail?.
3. Review the response and any SQL block.
4. Open generated SQL in a new AI Query tab.
5. Review and run it yourself. The assistant does not silently execute generated SQL.

Context and Sample Data

The request includes the selected database engine, a schema summary, current editor SQL, recent assistant conversation, and a summary of the latest result. The Include 5 sample rows option is off unless you choose it. When enabled, those sample values are sent to the configured provider.

Use AI Safely

• Generated SQL can be incomplete or incorrect; inspect it before execution.
• Prefer a read-only database account when exploring unfamiliar data.
• Do not send sample rows containing secrets, personal information, or regulated data to an external provider.
• Use a local Ollama endpoint when your security policy does not allow database context to leave the device.