SQL Agent

This Odoo module uses AI to generate SQL queries from natural language input.
It's designed to help users build database queries without needing to know SQL.

Open the LLM Provider Module in the Odoo

Configure llm provider module in the Odoo

• Go to Google Cloud Console and Create the new project
• Navigate to the Google Ai Studio go to the create API keys button and Generate the Key.
• Create an API Key and paste it into the Odoo LLM Provider form view in the Odoo

Go to the Discuss module, open the Vpcs AI Agent and click on setting for more configuration.

Click on channel.

In the channel, Add LLM provider and also adjust channel member.

Success message show in the Odoo vpcs ai agent channel, including Dashboard and Data Table links, using links directly open dashbord view and table view.

The SQL query results menu shows the query and results, with links to view the full table in the Odoo dashboard and website.

Clicking the Dashboard link displays the result in the Odoo Dashboard.

Clicking the View button displays the result on the Odoo Website.