MCP Tools Reference: databasecenter.googleapis.com

object ( IssueCount )

The filtered signal groups and the count of issues associated with the resources that have been filtered in.

string

The full resource name, based on CAIS resource name format https://cloud.google.com/asset-inventory/docs/resource-name-format

Example:

//cloudsql.googleapis.com/projects/project-number/instances/mysql-1 //cloudsql.googleapis.com/projects/project-number/instances/postgres-1 //spanner.googleapis.com/projects/project-number/instances/spanner-instance-1 //alloydb.googleapis.com/projects/project-number/locations/us-central1/clusters/c1 //alloydb.googleapis.com/projects/project-number/locations/us-central1/clusters/c1/instances/i1

string

Specifies where the resource is created. For Google Cloud resources, it is the full name of the project.

object ( Product )

The product this resource represents.

string

The location of the resources. It supports returning only regional locations in Google Cloud. These are of the form: "us-central1", "us-east1", etc. See https://cloud.google.com/about/locations for a list of such regions.

enum ( Engine )

Optional. The specific engine that the underlying database is running.

string

Optional. Version of the underlying database engine. Example values: For MySQL, it could be "8.0", "5.7" etc. For Postgres, it could be "14", "15" etc.

string

Optional. Minor version of the underlying database engine. Example values: For MySQL, it could be "8.0.35", "5.7.25" etc. For PostgreSQL, it could be "14.4", "15.5" etc.

string

The value part of the label.

string

The source of the Label. Source is empty if the label is directly attached to the resource and not inherited.

string

The value part of the tag.

string

The source of the tag. According to https://cloud.google.com/resource-manager/docs/tags/tags-overview#tags_and_labels , tags can be created only at the project or organization level. Tags can be inherited from different project as well not just the current project where the database resource is present. Format: "projects/{PROJECT_ID}", "projects/{PROJECT_NUMBER}", "organizations/{ORGANIZATION_ID}"

boolean

Indicates the inheritance status of a tag value attached to the given resource. If the tag value is inherited from one of the resource's ancestors, inherited will be true. If false, then the tag value is directly attached to the resource.

integer

When applied to a DatabaseResource represents count of issues associated with the resource. A signal is an issue when its SignalStatus field is set to SIGNAL_STATUS_ISSUE.

object ( Signal )

List of signals present in the group and associated with the resource.

Only applies to a DatabaseResource.

enum ( SignalStatus )

Status of the signal.

object ( AdditionalDetail )

Additional information related to the signal. In the case of composite signals, this field encapsulates details associated with granular signals, having a signal status of "ISSUE"; signals with a status of "OK" are not included. For granular signals, it encompasses information relevant to the signal, regardless of the signal status.

enum ( IssueSeverity )

Severity of the issue.

string ( Timestamp format)

Timestamp when the issue was created (when signal status is ISSUE).

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z" , "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30" .

integer

Signed fractions of a second at nanosecond resolution of the span of time. Durations less than one second are represented with a 0 seconds field and a positive or negative nanos field. For durations of one second or more, a non-zero value for the nanos field must be of the same sign as the seconds field. Must be from -999,999,999 to +999,999,999 inclusive.

integer

Non-negative fractions of a second at nanosecond resolution. This field is the nanosecond portion of the duration, not an alternative to seconds. Negative second values with fractions must still have non-negative nanos values that count forward in time. Must be between 0 and 999,999,999 inclusive.

string

Optional. Resource name associated with the sub resource where backup settings are configured. E.g."//spanner.googleapis.com/projects/project1/instances/inst1/databases/db1" for Spanner where backup retention is configured on database within an instance OPTIONAL

object ( Product )

Optional. Product information associated with the sub resource where backup retention settings are configured. e.g.

 product: {
 type   : PRODUCT_TYPE_SPANNER
 engine : ENGINE_CLOUD_SPANNER_WITH_POSTGRES_DIALECT
} 

for Spanner where backup is configured on database within an instance OPTIONAL

string

Specifies where the resource is created. For Google Cloud resources, it is the full name of the project.

string ( Timestamp format)

The time the backup operation completed.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z" , "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30" .

enum ( State )

Output only. The state of this run.

string

Additional information about the error encountered.

enum ( OperationErrorType )

Optional. OperationErrorType to expose specific error when backup operation of database resource failed, that is state is FAILED.

string

Name by which SCC calls this signal.

object ( RegulatoryStandard )

Compliances that are associated with the signal.

string

External URI which points to a SCC page associated with the signal.

string

Version of the standard or benchmark, for example, 1.1.

string

ID of recommender. Examples: "google.cloudsql.instance.PerformanceRecommender"

string

Contains an identifier for a subtype of recommendations produced for the same recommender. Subtype is a function of content and impact, meaning a new subtype might be added when significant changes to content or primary_impact.category are introduced. See the Recommenders section to see a list of subtypes for a given Recommender.

Examples: For recommender = "google.cloudsql.instance.PerformanceRecommender", recommender_subtype can be "MYSQL_HIGH_NUMBER_OF_OPEN_TABLES_BEST_PRACTICE"/"POSTGRES_HIGH_TRANSACTION_ID_UTILIZATION_BEST_PRACTICE"

boolean

Is automated policy enabled.

boolean

Is deletion protection enabled.

enum ( SuspensionReason )

Suspension reason for the resource.

string

Name of the table where index is required

string

SQL statement of the index. Based on the ddl type, this will be either CREATE INDEX or DROP INDEX.

string ( int64 format)

Cost of additional disk usage in bytes

string ( int64 format)

Count of queries to be impacted if index is applied

enum ( google.type.DayOfWeek )

Optional. Preferred day of the week for maintenance, e.g. MONDAY, TUESDAY, etc.

enum ( Phase )

Optional. Phase of the maintenance window. This is to capture order of maintenance. For example, for Cloud SQL resources, this can be used to capture if the maintenance window is in Week1, Week2, Week5, etc. Non production resources are usually part of early phase. For more details, refer to Cloud SQL resources - https://cloud.google.com/sql/docs/mysql/maintenance

integer

Minutes of an hour. Must be greater than or equal to 0 and less than or equal to 59.

integer

Seconds of a minute. Must be greater than or equal to 0 and typically must be less than or equal to 59. An API may allow the value 60 if it allows leap-seconds.

integer

Fractions of seconds, in nanoseconds. Must be greater than or equal to 0 and less than or equal to 999,999,999.

string ( Timestamp format)

The time the metric was observed in the metric source service.

Uses RFC 3339, where generated output will always be Z-normalized and use 0, 3, 6 or 9 fractional digits. Offsets other than "Z" are also accepted. Examples: "2014-10-02T15:01:23Z" , "2014-10-02T15:01:23.045123456Z" or "2014-10-02T15:01:23+05:30" .

object ( ResourceMaintenanceDenySchedule )

Optional. List of Deny maintenance period for the database resource.

string

Output only. Current Maintenance version of the database resource. Example: "MYSQL_8_0_41.R20250531.01_15"

object ( Date )

Optional. Deny period end date.

object ( TimeOfDay )

Optional. Time in UTC when the deny period starts on start_date and ends on end_date.

integer

Month of a year. Must be from 1 to 12, or 0 to specify a year without a month and day.

integer

Day of a month. Must be from 1 to 31 and valid for the year and month, or 0 to specify a year by itself or a year and month where the day isn't significant.

integer

The count of the number of issues associated with those resources that are explicitly filtered in by the filters present in the request. A signal is an issue when its SignalStatus field is set to SIGNAL_STATUS_ISSUE.