---
title: "GET /v1/projects/{projectsId}/locations/{locationsId}/environments/{environmentsId}:fetchDatabaseProperties"
method: GET
path: "/v1/projects/{projectsId}/locations/{locationsId}/environments/{environmentsId}:fetchDatabaseProperties"
tags: ["projects"]
---

# GET /v1/projects/{projectsId}/locations/{locationsId}/environments/{environmentsId}:fetchDatabaseProperties

`GET /v1/projects/{projectsId}/locations/{locationsId}/environments/{environmentsId}:fetchDatabaseProperties`

## Request

- Base URL: `https://composer.googleapis.com`
- URL: `https://composer.googleapis.com/v1/projects/{projectsId}/locations/{locationsId}/environments/{environmentsId}:fetchDatabaseProperties`
- Auth: one of:
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/cloud-platform`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloud-platform`
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/cloudcomposer`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloudcomposer`
  - OAuth 2 and OAuth 2
    - Implicit: `https://accounts.google.com/o/oauth2/auth`
    - Scopes: `https://www.googleapis.com/auth/cloudcomposer.readonly`
    - Authorization code: `https://accounts.google.com/o/oauth2/auth`
    - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloudcomposer.readonly`
- TypeScript: <https://skmtc.dev/google/apis/composer/docs/v1/projects/:projectsId/locations/:locationsId/environments/:environmentsId:fetchDatabaseProperties/get.ts> (a function with typed inputs; its response is checked against the schema)

Fetches database properties.

## Path parameters

- `projectsId` string, required
- `locationsId` string, required
- `environmentsId` string, required

## Response `200`

Successful response

- FetchDatabasePropertiesResponse: Response for FetchDatabasePropertiesRequest.
  - `isFailoverReplicaAvailable` boolean: The availability status of the failover replica. A false status indicates that the failover replica is out of sync. The primary instance can only fail over to the failover replica when the status is true.
  - `primaryGceZone` string: The Compute Engine zone that the instance is currently serving from.
  - `secondaryGceZone` string: The Compute Engine zone that the failover instance is currently serving from for a regional Cloud SQL instance.

## Changes

- **2026-11-07** `9c23b974ddbb`: 4 info
  - the security scope `https://www.googleapis.com/auth/cloud-platform` was added to the endpoint's security scheme `Oauth2`
  - the security scope `https://www.googleapis.com/auth/cloud-platform` was added to the endpoint's security scheme `Oauth2c`
  - the security scope `https://www.googleapis.com/auth/cloudcomposer.readonly` was removed from the endpoint's security scheme `Oauth2`
  - the security scope `https://www.googleapis.com/auth/cloudcomposer.readonly` was removed from the endpoint's security scheme `Oauth2c`

[Operation history](https://skmtc.dev/google/apis/composer/changes/v1/projects/:projectsId/locations/:locationsId/environments/:environmentsId:fetchDatabaseProperties/get.md)

---

[API](https://skmtc.dev/google/apis/composer.md) - [All operations](https://skmtc.dev/google/apis/composer/llms.txt) - [OpenAPI document](https://skmtc.dev/google/apis/composer/revisions/9c23b974ddbb?raw)