Analyze database fleet health using Gemini

Preview — Database Center

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. You can process personal data for this feature as outlined in the Cloud Data Processing Addendum, subject to the obligations and restrictions described in the agreement under which you access Google Cloud. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

You can use Database Center to learn more about your database fleet health by prompting Gemini to answer questions about the following:

• Database fleet inventory information
• Database fleet health
• Database configuration best practices

The following are example prompts to help you learn about your database fleet inventory data:

• "How many PostgreSQL instances do I have in Tokyo?"
• "How many of my database resources are not NIST 800-53 compliant?"
• "Why is it an issue that my database is exposed to ownership chaining?"
• "Why is it an issue that my database is not logging only DDL statements?"

Note: Gemini provides query suggestions and health issues based on all instances and databases in your project. Generated queries or displayed health issues might be based on data outside your region or VPC.

Working with Gemini

When you prompt Gemini to answer database fleet analysis questions, you can specify any number of the following fields in your prompt:

Field	Description	Examples
Product type	The Google Cloud database product.	CloudSQL, AlloyDB
Product engine	The database engine that the database product is using.	PostgreSQL, MySQL, SQL Server
Product version	The database version that the database product engine is running.	14 (PG), 5.7 (MySQL)
Location	The region that the database is running in.	us-east1
Label	A key-value pair assigned to the database.	sample:label
Signals	The set of issues that are applicable to a database resource including categories like availability, data protection, industry compliance, security, and logging. To learn about supported health issues for Google Cloud database products, see Supported health issues.	Availability

For example, to identify resources, you can enter the following prompt: Which of my Cloud SQL databases are located in us-east1? Gemini returns a list of database resources for Cloud SQL (product type) and in the us-east1 (location) region.

To determine the number of resources, for example, you can enter the following prompt: How many of my Postgres 13 databases are affected by security issues? Gemini returns the number of database resources that run Postgres (product engine) 13 (product version) and are affected by Security (signals) problems.

Examples of prompts include the following:

• "Are all of my database backups working correctly?"
• "How many databases do I have with data protection issues?"
• "Which of my database resources are located in the US?"
• "Show me the number of database resources I have by product type and engine."
• "Show me key:value labeled databases with performance recommendations." (replace "key:value" with your own label)
• "Show me all Cloud SQL databases running on PostgreSQL version 12."

Use Gemini to help you analyze database fleet health

As an early-stage technology, Gemini for Google Cloud products can generate output that seems plausible but is factually incorrect, especially when issuing the write Data Manipulation Language (DML) or Data Definition Language (DDL) operations. We recommend that you validate all output from Gemini for Google Cloud products before you use it. For more information, see Gemini for Google Cloud and responsible AI.

Follow the instructions in this section to prompt Gemini to answer questions about your database fleet health.

Before you begin

• Ensure that Database Center is set up for your organization.

Analyze your database fleet health

1. In the Google Cloud console, go to the Database Center page.

   Database Center

2. To open Gemini, click spark Gemini.

3. In the Gemini pane, enter a prompt, for example, Which of my Cloud SQL databases are located in us-east1?

4. To send the prompt, click Send. Gemini returns a list of database resources that are in Cloud SQL and in the us-east1 region.

Important: Gemini doesn't store your prompts or generated responses to our models, nor uses this data for training or fine-tuning our underlying models. Any data sent to the Gemini models is used strictly for serving a response to the request, and not stored, in order to mitigate IP or exfiltration risks. For more information, see How Gemini for Google Cloud uses your data and Certifications and security for Gemini.