Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-04-02 UTC."],[[["Database Center utilizes Gemini to analyze your database fleet's health, inventory, and adherence to best practices."],["You can query Gemini about your database resources using specific fields like product type, engine, version, location, labels, and issue signals."],["Gemini can identify issues related to availability, data protection, compliance, security, and logging within your database fleet."],["Before using output, it is recommended to validate any data received from Gemini due to it being an early-stage technology that may produce inaccurate results."],["Data that is used by Gemini to output data is not stored or used for training, and it is only used to serve a response to the request."]]],[]]
