`az mysql flexible-server list-skus` does not list any SKU's for any region

[MelleNooijen]

Describe the bug

Trying to look for SKU's to use for a MySQL Flexible Server does not return any SKU's, no matter the selected region. Deploying with SKU's from docs (i.e. Standard_B1ms) indicates the SKU is invalid.

❯ az mysql flexible-server list-skus -l westeurope

For prices please refer to https://aka.ms/mysql-pricing
[]
❯ az mysql flexible-server list-skus -l northeurope

For prices please refer to https://aka.ms/mysql-pricing
[]
❯ az mysql flexible-server list-skus -l westus

For prices please refer to https://aka.ms/mysql-pricing
[]

Related command

az mysql flexible-server list-skus -l (region)

Errors

N.A.

Issue script & Debug output

cli.knack.cli: Command arguments: ['mysql', 'flexible-server', 'list-skus', '-l', 'westeurope', '--debug']
cli.knack.cli: __init__ debug log:
Enable color in terminal.
[...]
cli.azure.cli.core.sdk.policies: Request URL: 'https://management.azure.com/subscriptions/***/providers/Microsoft.DBforMySQL/locations/westeurope/capabilities?api-version=2024-10-01-preview'
cli.azure.cli.core.sdk.policies: Request method: 'GET'
cli.azure.cli.core.sdk.policies: Request headers:
cli.azure.cli.core.sdk.policies:     'Accept': 'application/json'
cli.azure.cli.core.sdk.policies:     'x-ms-client-request-id': '***'
cli.azure.cli.core.sdk.policies:     'CommandName': 'mysql flexible-server list-skus'
cli.azure.cli.core.sdk.policies:     'ParameterSetName': '-l --debug'
cli.azure.cli.core.sdk.policies:     'User-Agent': 'AZURECLI/2.73.0 (HOMEBREW) azsdk-python-core/1.31.0 Python/3.12.10 (macOS-15.4.1-arm64-arm-64bit)'
cli.azure.cli.core.sdk.policies:     'Authorization': '*****'
cli.azure.cli.core.sdk.policies: Request body:
cli.azure.cli.core.sdk.policies: This request has no body
urllib3.connectionpool: Starting new HTTPS connection (1): management.azure.com:443
urllib3.connectionpool: https://management.azure.com:443 "GET /subscriptions/***/providers/Microsoft.DBforMySQL/locations/westeurope/capabilities?api-version=2024-10-01-preview HTTP/1.1" 200 12
cli.azure.cli.core.sdk.policies: Response status: 200
cli.azure.cli.core.sdk.policies: Response headers:
cli.azure.cli.core.sdk.policies:     'Cache-Control': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Pragma': 'no-cache'
cli.azure.cli.core.sdk.policies:     'Content-Length': '12'
cli.azure.cli.core.sdk.policies:     'Content-Type': 'application/json; charset=utf-8'
cli.azure.cli.core.sdk.policies:     'Expires': '-1'
cli.azure.cli.core.sdk.policies:     'X-Content-Type-Options': 'nosniff'
cli.azure.cli.core.sdk.policies:     'x-ms-request-id': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-operation-identifier': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-ratelimit-remaining-subscription-reads': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-ratelimit-remaining-subscription-global-reads': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-correlation-request-id': '***'
cli.azure.cli.core.sdk.policies:     'x-ms-routing-request-id': '***'
cli.azure.cli.core.sdk.policies:     'Strict-Transport-Security': 'max-age=31536000; includeSubDomains'
cli.azure.cli.core.sdk.policies:     'X-Cache': 'CONFIG_NOCACHE'
cli.azure.cli.core.sdk.policies:     'X-MSEdge-Ref': '***'
cli.azure.cli.core.sdk.policies:     'Date': 'Wed, 28 May 2025 11:57:59 GMT'
cli.azure.cli.core.sdk.policies: Response content:
cli.azure.cli.core.sdk.policies: {"value":[]}
cli.azure.cli.command_modules.mysql.custom: For prices please refer to https://aka.ms/mysql-pricing
cli.knack.cli: Event: CommandInvoker.OnTransformResult [<function _resource_group_transform at 0x103fdc0e0>, <function _x509_from_base64_to_hex_transform at 0x103fdc180>]
cli.knack.cli: Event: CommandInvoker.OnFilterResult []
[]
cli.knack.cli: Event: Cli.SuccessfulExecute []
cli.knack.cli: Event: Cli.PostExecute [<function AzCliLogging.deinit_cmd_metadata_logging at 0x103f83a60>]
az_command_data_logger: exit code: 0
cli.__main__: Command ran in 0.489 seconds (init: 0.061, invoke: 0.428)
telemetry.main: Begin splitting cli events and extra events, total events: 1
telemetry.client: Accumulated 0 events. Flush the clients.
telemetry.main: Finish splitting cli events and extra events, cli events: 1
telemetry.save: Save telemetry record of length 3996 in cache file under /Users/***/.azure/telemetry/20250528135800980
telemetry.main: Begin creating telemetry upload process.
telemetry.process: Creating upload process: "/opt/homebrew/Cellar/azure-cli/2.73.0/libexec/bin/python /opt/homebrew/Cellar/azure-cli/2.73.0/libexec/lib/python3.12/site-packages/azure/cli/telemetry/__init__.py /Users/***/.azure /Users/***/.azure/telemetry/20250528135800980"
telemetry.process: Return from creating process 25744
telemetry.main: Finish creating telemetry upload process.

Expected behavior

It lists SKU's as usual.

Environment Summary

azure-cli                         2.73.0

core                              2.73.0
telemetry                          1.1.0

Extensions:
account                            0.2.5
rdbms-connect                      1.0.7

Dependencies:
msal                              1.32.3
azure-mgmt-resource               23.3.0

Python location '/opt/homebrew/Cellar/azure-cli/2.73.0/libexec/bin/python'
Config directory '/Users/***/.azure'
Extensions directory '/Users/***/.azure/cliextensions'

Python (Darwin) 3.12.10 (main, Apr  8 2025, 11:35:47) [Clang 17.0.0 (clang-1700.0.13.3)]

Legal docs and information: aka.ms/AzureCliLegal


Your CLI is up-to-date.

Additional context

Tried both on macOS and Windows with different tenants and subscriptions with the same result.

[yonzhan]

Thank you for opening this issue, we will look into it.

[microsoft-github-policy-service]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ambhatna, @savjani.

[honghr]

C:\Users\xxx>az mysql flexible-server list-skus -l westeurope
For prices please refer to https://aka.ms/mysql-pricing
[
  {
    "supportedFlexibleServerEditions": [
      {
        "name": "Burstable",
        "supportedServerVersions": [
          {
            "name": "5.7",
            "supportedSkus": [
              {
                "name": "Standard_B1ms",
                "supportedIops": 640,
                "supportedMemoryPerVCoreMb": 2048,
                "vCores": 1
              },
              {
                "name": "Standard_B1s",
                "supportedIops": 400,
                "supportedMemoryPerVCoreMb": 1024,
                "vCores": 1
              },
              ....

[raphaelpoumarede]

I still don't see any available SKU in any region when running the command....
here is my test script:

#!/usr/bin/env bash

regions=(
australiacentral
australiasoutheast
canadaeast
eastasia
eastus2
germanynorth
germanywestcentral
centralindia
southindia
japanwest
koreasouth
northcentralus
norwayeast
norwaywest
swedencentral
uaenorth
ukwest
westcentralus
westus
westus2
westus3
brazilsouth
brazilsoutheast
francecentral
francesouth
southafricanorth
southafricawest
southeastasia
northeurope
australiaeast
japaneast
koreacentral
uksouth
westeurope
canadacentral
centralus
eastus
switzerlandnorth
switzerlandwest
southcentralus
polandcentral
italynorth
israelcentral
uaecentral
spaincentral
mexicocentral
jioindiawest
jioindiacentral
newzealandnorth
indonesiacentral
malaysiawest
chilecentral
austriaeast
belgiumcentral
australiacentral2
qatarcentral
)

echo "Checking Azure MySQL Flexible Server SKU availability..."
echo "=========================================================="
echo

for region in "${regions[@]}"; do
    echo "Region: $region"
    
    # Fetch SKUs
    skus=$(az mysql flexible-server list-skus -l "$region" --query "value[].name" -o tsv 2>/dev/null)

    if [ -z "$skus" ]; then
        echo "  ❌ No SKUs available (or region not supported / capacity issue)"
    else
        echo "  ✅ SKUs available:"
        echo "$skus" | sed 's/^/    - /'
    fi

    echo
done

and here is the result:

Region: australiacentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: australiasoutheast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: canadaeast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: eastasia
  ❌ No SKUs available (or region not supported / capacity issue)

Region: eastus2
  ❌ No SKUs available (or region not supported / capacity issue)

Region: germanynorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: germanywestcentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: centralindia
  ❌ No SKUs available (or region not supported / capacity issue)

Region: southindia
  ❌ No SKUs available (or region not supported / capacity issue)

Region: japanwest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: koreasouth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: northcentralus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: norwayeast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: norwaywest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: swedencentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: uaenorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: ukwest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: westcentralus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: westus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: westus2
  ❌ No SKUs available (or region not supported / capacity issue)

Region: westus3
  ❌ No SKUs available (or region not supported / capacity issue)

Region: brazilsouth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: brazilsoutheast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: francecentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: francesouth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: southafricanorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: southafricawest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: southeastasia
  ❌ No SKUs available (or region not supported / capacity issue)

Region: northeurope
  ❌ No SKUs available (or region not supported / capacity issue)

Region: australiaeast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: japaneast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: koreacentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: uksouth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: westeurope
  ❌ No SKUs available (or region not supported / capacity issue)

Region: canadacentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: centralus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: eastus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: switzerlandnorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: switzerlandwest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: southcentralus
  ❌ No SKUs available (or region not supported / capacity issue)

Region: polandcentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: italynorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: israelcentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: uaecentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: spaincentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: mexicocentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: jioindiawest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: jioindiacentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: newzealandnorth
  ❌ No SKUs available (or region not supported / capacity issue)

Region: indonesiacentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: malaysiawest
  ❌ No SKUs available (or region not supported / capacity issue)

Region: chilecentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: austriaeast
  ❌ No SKUs available (or region not supported / capacity issue)

Region: belgiumcentral
  ❌ No SKUs available (or region not supported / capacity issue)

Region: australiacentral2
  ❌ No SKUs available (or region not supported / capacity issue)

Region: qatarcentral
  ❌ No SKUs available (or region not supported / capacity issue)

[raphaelpoumarede]

it works with az cli 2.80 and using the --subscription. But in this case the -o table or -o tsv don't work...