Generate database-aware code with the Google Databases Gemini Code Assist tool

The Gemini Code Assist Google Databases tool is available as part of Gemini Code Assist Standard and Enterprise edition.

You can use the Google Databases tool prompt @GoogleDatabases in the Gemini Code Assist chat to generate database-aware application code for Cloud SQL in your integrated development environment (IDE).

Before you begin

The first three steps should be done by an administrator, and the remaining step can be completed by individual developers.

  1. Install Gemini Code Assist.
  2. Enable Data Catalog in Cloud SQL by following the instructions in Manage your Cloud SQL resources using Data Catalog.
  3. Enable the Google Databases tool for users by following the steps in Enable Gemini Code Assist tools.
  4. Install the Google Databases tool in your IDE by following the steps in Configure tools.

Generate a function

  1. In your IDE, navigate to the Gemini Code Assist chat and enter the following prompt:

    @GoogleDatabases generate a function FEATURE

    Replace FEATURE with the feature requirement that you want to generate code for. For example, you could generate a function to get customers by ID by entering the following prompt: @GoogleDatabases generate a function to get customers by ID

    The Gemini Code Assist Google Databases tool returns database-aware code for the feature requirement.

Additional prompts

The following prompts are recommended for the Google Databases tool:

  • @GoogleDatabases generate a function that gets a sales comparison between the last two months
  • @GoogleDatabases generate a function that returns the top 5 selling items over the past week

What's next

  • Learn more about Gemini Code Assist tools by reading the Tools overview.