Stay organized with collectionsSave 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, seeSupported
health issues.
Availability
For example, to identify database 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 database 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-09-04 UTC."],[[["\u003cp\u003eDatabase Center utilizes Gemini to analyze your database fleet's health, inventory, and adherence to best practices.\u003c/p\u003e\n"],["\u003cp\u003eYou can query Gemini about your database resources using specific fields like product type, engine, version, location, labels, and issue signals.\u003c/p\u003e\n"],["\u003cp\u003eGemini can identify issues related to availability, data protection, compliance, security, and logging within your database fleet.\u003c/p\u003e\n"],["\u003cp\u003eBefore 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.\u003c/p\u003e\n"],["\u003cp\u003eData 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.\u003c/p\u003e\n"]]],[],null,["# Analyze database fleet health using Gemini\n\nYou can use Database Center to learn more about your database\nfleet health by prompting Gemini to answer questions about\nthe following:\n\n- Database fleet inventory information\n- Database fleet health\n- Database configuration best practices\n\nThe following are example prompts to help you learn about your database fleet\ninventory data:\n\n- \"How many PostgreSQL instances do I have in Tokyo?\"\n- \"How many of my database resources are not NIST 800-53 compliant?\"\n- \"Why is it an issue that my database is exposed to ownership chaining?\"\n- \"Why is it an issue that my database is not logging only DDL statements?\"\n\n| **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.\n\nWorking with Gemini\n-------------------\n\nWhen you prompt Gemini to answer database fleet analysis\nquestions, you can specify any number of the following fields in your prompt:\n\nFor example, to identify database resources, you can enter the following prompt:\n`Which of my Cloud SQL databases are located in us-east1?` Gemini\nreturns a list of database resources for Cloud SQL (product type) and in the\nus-east1 (location) region.\n\nTo determine the number of database resources, for example, you can enter the\nfollowing prompt: `How many of my Postgres 13 databases are affected by security\nissues?` Gemini returns the number of database resources that run\nPostgres (product engine) 13 (product version) and are affected by Security\n(signals) problems.\n\nExamples of prompts include the following:\n\n- \"Are all of my database backups working correctly?\"\n- \"How many databases do I have with data protection issues?\"\n- \"Which of my database resources are located in the US?\"\n- \"Show me the number of database resources I have by product type and engine.\"\n- \"Show me key:value labeled databases with performance recommendations.\" (replace \"key:value\" with your own label)\n- \"Show me all Cloud SQL databases running on PostgreSQL version 12.\"\n\nUse Gemini to help you analyze database fleet health\n----------------------------------------------------\n\n| As an early-stage technology, Gemini for Google Cloud\n| products can generate output that seems plausible but is factually incorrect. We recommend that you\n| validate all output from Gemini for Google Cloud products before you use it.\n| For more information, see\n| [Gemini for Google Cloud and responsible AI](/gemini/docs/discover/responsible-ai).\n\nFollow the instructions in this section to prompt Gemini to\nanswer questions about your database fleet health.\n\n### Before you begin\n\n- [Ensure that Database Center is set up for your organization](/database-center/docs/set-up-database-center).\n\n### Analyze your database fleet health\n\n1. In the Google Cloud console, go to the **Database Center** page.\n\n\n [Database Center](https://console.cloud.google.com/database-center)\n\n \u003cbr /\u003e\n\n2.\n To open Gemini, click spark **Gemini**.\n\n3. In the Gemini pane, enter a prompt, for example, `Which\n of my Cloud SQL databases are located in us-east1?`\n\n4. To send the prompt, click send**Send** . Gemini returns\n a list of database resources that are in Cloud SQL and in the\n `us-east1` region.\n\n| **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](/gemini/docs/discover/data-governance) and [Certifications and security for Gemini](/gemini/docs/discover/certifications)."]]
