gcloud alpha sql instances list - lists Cloud SQL instances in a given project

gcloud alpha sql instances list[--show-edition][--show-sql-network-architecture][--show-transactional-log-storage-state][--filter=EXPRESSION][--limit=LIMIT][--page-size=PAGE_SIZE][--sort-by=[FIELD,…]][--uri][GCLOUD_WIDE_FLAG …]

--show-edition

Show the edition field.

--show-sql-network-architecture

Show the instance's current SqlNetworkArchitecture backend in addition to thedefault output list. An instance could use either the old or new networkarchitecture. The new network architecture offers better isolation, reliability,and faster new feature adoption.

--show-transactional-log-storage-state

Show the storage location of the transactional logs used for point-in-timerecovery (PITR) by the instance.

--filter=EXPRESSION

Apply a Boolean filterEXPRESSION to each resource itemto be listed. If the expression evaluatesTrue, then that item islisted. For more details and examples of filter expressions, run $gcloud topic filters. This flaginteracts with other flags that are applied in this order:--flatten,--sort-by,--filter,--limit.

--limit=LIMIT

Maximum number of resources to list. The default isunlimited. Thisflag interacts with other flags that are applied in this order:--flatten,--sort-by,--filter,--limit.

--page-size=PAGE_SIZE

Some services group resource list output into pages. This flag specifies themaximum number of resources per page. The default is determined by the serviceif it supports paging, otherwise it isunlimited (no paging).Paging may be applied before or after--filter and--limit depending on the service.

--sort-by=[FIELD,…]

Comma-separated list of resource field key names to sort by. The default orderis ascending. Prefix a field with ``~´´ for descending order on thatfield. This flag interacts with other flags that are applied in this order:--flatten,--sort-by,--filter,--limit.

--uri

Print a list of resource URIs instead of the default output, and change thecommand output to a list of URIs. If this flag is used with--format, the formatting is applied on this URI list. To displayURIs alongside other keys instead, use theuri() transform.

Run$gcloud help for details.