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?"
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
Follow the instructions in this section to prompt Gemini to answer questions about your database fleet health.
Before you begin
Analyze your database fleet health
In the Google Cloud console, go to the Database Center page.
To open Gemini, click spark Gemini.
In the Gemini pane, enter a prompt, for example,
Which of my Cloud SQL databases are located in us-east1?
To send the prompt, click
Send. Gemini returns a list of database resources that are in Cloud SQL and in theus-east1
region.