Write SQL with Gemini assistance

This document describes how you can use Gemini, an AI-powered collaborator in Google Cloud, to help you do the following in Cloud SQL Studio:

• Generate SQL queries using natural language prompts
• Explain SQL queries in the query editor

Learn how and when Gemini for Google Cloud uses your data.

This document is intended for database administrators and data engineers who are familiar with SQL, data analysis, and Cloud SQL. If you're new to Cloud SQL, see Cloud SQL overview.

Before you begin

1. To complete the tasks in this document, ensure that you have the necessary Identity and Access Management (IAM) permissions.
2. Confirm access to Cloud SQL Studio. If you don't have access to Cloud SQL Studio, then see Cloud SQL Studio required roles and permissions

3. Optional: To follow along with the examples in this document, create a Singers table using the following schema:

   CREATE TABLE
   Singers (
     SingerId   BIGINT PRIMARY KEY,
     FirstName  VARCHAR(1024),
     LastName   VARCHAR(1024),
     SingerInfo MEDIUMBLOB,
     BirthDate  DATETIME
   );
   

   After you create the Singers table, click refreshRefresh to update your database schema.

Required roles and permissions

To get the permissions that you need to complete the tasks in this document, ask your administrator to grant you the