Use AI Assistant

AI Assistant is a Data Studio capability that answers your questions, guides you to workflow actions, generates SQL from natural language requests, and helps you with data enrichment.

Before You Begin

Before using AI Assistant for database or data workflows, ensure that:

• You selected the target region and compartment.

• You selected or connected to an Autonomous AI Database when the workflow requires a database.

• The database is AI-ready for the task that requires AI services.

• Required credentials and AI Profile are configured for database-specific AI workflows.

• OCI Permissions allow the signed-in user and the connected database to access the required OCI resources.

About AI Assistant

AI Assistant opens in a side panel, so you can continue working in Data Studio while you review its response.

The assistance available to you depends on your access, configured services, and the Data Studio area where you are working. Some tasks require the connected database to be AI-ready and configured with OCI access, database credentials, and an AI Profile.

Some of the AI-enabled workflows and tasks are explained here.

When to Use AI Assistant

Use AI Assistant when you want to:

• Ask questions about Data Studio tasks and database workflows.

• Create an Autonomous AI Database by submitting a provisioning request.

• Prepare for data-loading or data-linking workflows.

• Generate SQL from natural language for selected catalog objects.

• Get help deciding which Data Studio tool to open next.

Note: For workflows that are not supported by AI Assistant, use the corresponding Data Studio pages to inspect and perform the task manually.

How AI Assistant Works

AI Assistant uses the current Data Studio context when it prepares a response. Context can include the selected region, compartment, connected database, selected catalog objects, and available tool state.

For tasks that make changes, AI Assistant prepares a confirmation form or action panel.

Note: Review the generated values before confirming the action. Data Studio does not make changes, such as creating a database or starting a load, until the workflow reaches its confirmation step.

Open AI Assistant

1. Select the AI Assistant card on the home page.

   You can also click the AI Assistant icon or use the Ask AI text box in the header from any page in Data Studio.

2. Enter a question or a request in the AI Assistant chat window.

3. Review the response, action form, generated SQL, or next-step guidance.

   Note: Confirm an action only after you verify the generated values.

Create an Autonomous Database with AI Assistant

You can ask AI Assistant to provision an Autonomous AI Database.

Consider the following example.

1. Open AI Assistant.

2. Enter a request, such as provision a new database named analyst.

3. Review the generated Create an Autonomous Database form.

4. Enter the administrator password.

   You can select Advanced settings if you want to review or change the values.

5. Click Create database to provision the database.

After creation starts, Data Studio displays the new database on the Databases page with its lifecycle state, such as Provisioning or Available.

Generate SQL with AI

Data Studio provides an option in SQL Worksheet for generating AI-assisted SQL queries. You can enter a plain-language prompt, generate the equivalent SQL, review or edit the generated SQL, and run the query to display the results in a Query Result.

To use natural language queries for SQL statements, ensure that your AI Profile is configured and ready. See Configure Database Settings.

On the SQL Worksheet page, do the following:

1. In the SQL Worksheet toolbar, click Generate SQL with AI.

2. Select one or more tables to provide context.

3. Enter your request in natural language in the text box for AI.

   Note: The text box for entering AI prompts is different from the query editor.

4. Click Generate SQL to insert the SQL in the query editor.

5. Review the AI-assisted SQL statement and edit it as needed.

6. Click Run SQL to display the result.

AI Assistant Setup

To use AI Assistant in Data Studio, ensure that the following configurations are complete:

• Databases: Connect to a database or add a Database Actions URL to perform the required setup. See Work with Database Connections and Resources.

• OCI Permissions: Check whether the connected database and signed-in user can access OCI resources required for AI workflows. See Prepare to Use Data Studio.

• Credentials: Open Database Settings and go to the Credentials tab. Create credentials for secure service access if they are not already created. See Configure Database Settings.

• AI Profiles: Open Database Settings and go to AI Profiles. Create an AI profile to use AI-specific services if one is not already created. See Configure Database Settings.

Data Studio indicates that your database is AI-ready in various locations, such as in the header next to the database name and in SQL Worksheet.