Skip to content

Robertjam954/multimodal_rag_application / .claude/skills/azure-prepare

azure-prepare

Flagged

Prepare Azure apps for deployment (infra Bicep/Terraform, azure.yaml, Dockerfiles). Use for create/modernize or create+deploy; not cross-cloud migration (use azure-cloud-migrate). DO NOT USE FOR: copilot-sdk apps (use azure-hosted-copilot-sdk), or Python code-only App Service deploys (use python-appservice-deploy). WHEN: "create app", "build web app", "create API", "modernize application", "host on Azure", "deploy to Azure", "deploy to Azure using Terraform", "deploy to Azure App Service", "deploy to Azure App Service using Terraform", "deploy to Azure Container Apps", "generate Terraform", "generate Bicep", "function app", "timer trigger", "service bus trigger", "event-driven function", "managed identity".

FileKindSize
SKILL.mdskill md13.1 KB
references/analyze.mdmarkdown4.3 KB
references/apim.mdmarkdown5.7 KB
references/architecture.mdmarkdown6.3 KB
references/aspire.mdmarkdown18.2 KB
references/auth-best-practices.mdmarkdown6.1 KB
references/azure-context.mdmarkdown5.7 KB
references/functional-verification.mdmarkdown3.2 KB
references/generate.mdmarkdown5.3 KB
references/global-rules.mdmarkdown2.0 KB
references/plan-template.mdmarkdown10.1 KB
references/recipe-selection.mdmarkdown3.2 KB
references/recipes/azcli/README.mdmarkdown1.8 KB
references/recipes/azcli/commands.mdmarkdown1.6 KB
references/recipes/azcli/scripts.mdmarkdown2.2 KB
references/recipes/azd/README.mdmarkdown3.8 KB
references/recipes/azd/aspire.mdmarkdown8.9 KB
references/recipes/azd/azure-yaml.mdmarkdown6.7 KB
references/recipes/azd/docker.mdmarkdown2.0 KB
references/recipes/azd/iac-rules.mdmarkdown5.8 KB
references/recipes/azd/terraform.mdmarkdown14.0 KB
references/recipes/bicep/README.mdmarkdown1.4 KB
references/recipes/bicep/patterns.mdmarkdown3.0 KB
references/recipes/terraform/README.mdmarkdown2.5 KB
references/recipes/terraform/patterns.mdmarkdown3.5 KB
references/region-availability.mdmarkdown1.7 KB
references/requirements.mdmarkdown2.5 KB
references/research.mdmarkdown8.8 KB
references/resources-limits-quotas.mdmarkdown13.0 KB
references/runtimes/nodejs.mdmarkdown5.9 KB
references/scan.mdmarkdown3.5 KB
references/sdk/azd-deployment.mdmarkdown792 B
references/sdk/azure-appconfiguration-java.mdmarkdown1.5 KB
references/sdk/azure-appconfiguration-py.mdmarkdown1.1 KB
references/sdk/azure-appconfiguration-ts.mdmarkdown1.2 KB
references/sdk/azure-identity-dotnet.mdmarkdown941 B
references/sdk/azure-identity-java.mdmarkdown1.2 KB
references/sdk/azure-identity-py.mdmarkdown1.1 KB
references/sdk/azure-identity-ts.mdmarkdown1.1 KB
references/security.mdmarkdown8.5 KB
references/services/aks/README.mdmarkdown1.0 KB
references/services/aks/addons.mdmarkdown957 B
references/services/aks/bicep.mdmarkdown1.6 KB
references/services/aks/manifests.mdmarkdown1.4 KB
references/services/app-insights/README.mdmarkdown848 B
references/services/app-service/README.mdmarkdown2.3 KB
references/services/app-service/bicep.mdmarkdown4.2 KB
references/services/app-service/custom-domains.mdmarkdown4.8 KB
references/services/app-service/deployment-slots.mdmarkdown4.5 KB
references/services/app-service/networking.mdmarkdown6.6 KB
references/services/app-service/scaling.mdmarkdown1.5 KB
references/services/app-service/sku-selection.mdmarkdown4.7 KB
references/services/app-service/templates/recipes/README.mdmarkdown2.8 KB
references/services/app-service/templates/recipes/auth/README.mdmarkdown3.1 KB
references/services/app-service/templates/recipes/auth/source/dotnet.mdmarkdown1.3 KB
references/services/app-service/templates/recipes/auth/source/nodejs.mdmarkdown2.5 KB
references/services/app-service/templates/recipes/auth/source/python.mdmarkdown2.2 KB
references/services/app-service/templates/recipes/composition.mdmarkdown4.8 KB
references/services/app-service/templates/recipes/cosmos/README.mdmarkdown3.6 KB
references/services/app-service/templates/recipes/cosmos/source/dotnet.mdmarkdown1.3 KB
references/services/app-service/templates/recipes/cosmos/source/nodejs.mdmarkdown1.2 KB
references/services/app-service/templates/recipes/cosmos/source/python.mdmarkdown1.1 KB
references/services/app-service/templates/recipes/redis/README.mdmarkdown3.3 KB
references/services/app-service/templates/recipes/redis/source/dotnet.mdmarkdown1.6 KB
references/services/app-service/templates/recipes/redis/source/nodejs.mdmarkdown2.2 KB
references/services/app-service/templates/recipes/redis/source/python.mdmarkdown2.9 KB
references/services/app-service/templates/recipes/sql/README.mdmarkdown3.5 KB
references/services/app-service/templates/recipes/sql/source/dotnet.mdmarkdown2.9 KB
references/services/app-service/templates/recipes/sql/source/nodejs.mdmarkdown3.0 KB
references/services/app-service/templates/recipes/sql/source/python.mdmarkdown4.4 KB
references/services/app-service/templates/selection.mdmarkdown2.8 KB
references/services/app-service/templates/web-api.mdmarkdown4.9 KB
references/services/app-service/templates/web-app.mdmarkdown4.9 KB
references/services/container-apps/README.mdmarkdown1.3 KB
references/services/container-apps/bicep.mdmarkdown4.8 KB
references/services/container-apps/day2-operations.mdmarkdown5.1 KB
references/services/container-apps/environment.mdmarkdown1.2 KB
references/services/container-apps/health-probes.mdmarkdown1.1 KB
references/services/container-apps/networking.mdmarkdown5.1 KB
references/services/container-apps/revisions.mdmarkdown4.9 KB
references/services/container-apps/scaling.mdmarkdown1.4 KB
references/services/container-apps/terraform.mdmarkdown6.1 KB
references/services/cosmos-db/README.mdmarkdown1.4 KB
references/services/cosmos-db/bicep.mdmarkdown1.8 KB
references/services/cosmos-db/partitioning.mdmarkdown1.1 KB
references/services/cosmos-db/sdk.mdmarkdown1.6 KB
references/services/durable-task-scheduler/README.mdmarkdown4.9 KB
references/services/durable-task-scheduler/bicep.mdmarkdown4.8 KB
references/services/durable-task-scheduler/dotnet.mdmarkdown6.1 KB
references/services/durable-task-scheduler/java.mdmarkdown7.7 KB
references/services/durable-task-scheduler/javascript.mdmarkdown5.6 KB
references/services/durable-task-scheduler/python.mdmarkdown6.4 KB
references/services/event-grid/README.mdmarkdown1.0 KB
references/services/event-grid/bicep.mdmarkdown1.7 KB
references/services/event-grid/subscriptions.mdmarkdown1.6 KB
references/services/foundry/README.mdmarkdown1.3 KB
references/services/foundry/region-availability.mdmarkdown826 B
references/services/functions/README.mdmarkdown3.8 KB
references/services/functions/aspire-containerapps.mdmarkdown3.3 KB
references/services/functions/bicep.mdmarkdown11.9 KB
references/services/functions/durable.mdmarkdown1.8 KB
references/services/functions/templates/README.mdmarkdown6.5 KB
references/services/functions/templates/base/eval/python.mdmarkdown762 B
references/services/functions/templates/base/eval/summary.mdmarkdown1.9 KB
references/services/functions/templates/base/eval/typescript.mdmarkdown1.1 KB
references/services/functions/templates/recipes/README.mdmarkdown1.1 KB
references/services/functions/templates/recipes/blob-eventgrid/README.mdmarkdown1.6 KB
references/services/functions/templates/recipes/blob-eventgrid/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/blob-eventgrid/eval/summary.mdmarkdown2.6 KB
references/services/functions/templates/recipes/common/dotnet-entry-point.mdmarkdown2.0 KB
references/services/functions/templates/recipes/common/error-handling.mdmarkdown2.2 KB
references/services/functions/templates/recipes/common/health-check.mdmarkdown2.7 KB
references/services/functions/templates/recipes/common/nodejs-entry-point.mdmarkdown4.1 KB
references/services/functions/templates/recipes/composition.mdmarkdown11.1 KB
references/services/functions/templates/recipes/cosmosdb/README.mdmarkdown1.5 KB
references/services/functions/templates/recipes/cosmosdb/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/cosmosdb/eval/summary.mdmarkdown1.8 KB
references/services/functions/templates/recipes/cosmosdb/eval/typescript.mdmarkdown1.3 KB
references/services/functions/templates/recipes/durable/README.mdmarkdown1.8 KB
references/services/functions/templates/recipes/durable/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/durable/eval/summary.mdmarkdown1.6 KB
references/services/functions/templates/recipes/eventhubs/README.mdmarkdown1.2 KB
references/services/functions/templates/recipes/eventhubs/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/eventhubs/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/recipes/mcp/README.mdmarkdown1.9 KB
references/services/functions/templates/recipes/mcp/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/mcp/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/recipes/servicebus/README.mdmarkdown1.3 KB
references/services/functions/templates/recipes/servicebus/eval/python.mdmarkdown1.3 KB
references/services/functions/templates/recipes/servicebus/eval/summary.mdmarkdown1.8 KB
references/services/functions/templates/recipes/servicebus/eval/typescript.mdmarkdown1.4 KB
references/services/functions/templates/recipes/sql/README.mdmarkdown1.8 KB
references/services/functions/templates/recipes/sql/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/sql/eval/summary.mdmarkdown2.8 KB
references/services/functions/templates/recipes/timer/README.mdmarkdown1.5 KB
references/services/functions/templates/recipes/timer/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/timer/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/selection.mdmarkdown4.3 KB
references/services/functions/terraform.mdmarkdown13.3 KB
references/services/key-vault/README.mdmarkdown1.3 KB
references/services/key-vault/bicep.mdmarkdown1.7 KB
references/services/key-vault/sdk.mdmarkdown1.9 KB
references/services/logic-apps/README.mdmarkdown1.0 KB
references/services/logic-apps/bicep.mdmarkdown1.8 KB
references/services/logic-apps/triggers.mdmarkdown1.7 KB
references/services/service-bus/README.mdmarkdown1.4 KB
references/services/service-bus/bicep.mdmarkdown3.7 KB
references/services/service-bus/patterns.mdmarkdown4.2 KB
references/services/sql-database/README.mdmarkdown1.9 KB
references/services/sql-database/auth.mdmarkdown4.0 KB
references/services/sql-database/bicep.mdmarkdown7.8 KB
references/services/sql-database/scripts/grant-sql-access.ps1script3.5 KB
references/services/sql-database/scripts/grant-sql-access.shscript3.6 KB
references/services/sql-database/sdk.mdmarkdown1.8 KB
references/services/static-web-apps/README.mdmarkdown1.3 KB
references/services/static-web-apps/bicep.mdmarkdown1.0 KB
references/services/static-web-apps/deployment.mdmarkdown1.8 KB
references/services/static-web-apps/region-availability.mdmarkdown674 B
references/services/static-web-apps/routing.mdmarkdown1.2 KB
references/services/static-web-apps/terraform.mdmarkdown3.5 KB
references/services/storage/README.mdmarkdown1.4 KB
references/services/storage/access.mdmarkdown3.6 KB
references/services/storage/bicep.mdmarkdown1.7 KB
references/specialized-routing.mdmarkdown4.5 KB

references/services/sql-database/bicep.md

View on GitHub
# SQL Database - Bicep Patterns

> ⛔ **CRITICAL — SQL Server Bicep MUST use Entra-only authentication. NEVER include `administratorLogin` or `administratorLoginPassword` anywhere in a Bicep file — not even inside a conditional (`condition ? { ... } : { administratorLoginPassword: ... }`) branch. If either property name appears anywhere in the file, the deployment will be rejected. Always use the pattern below.**

## Basic Setup (Entra-Only Authentication)

**Required approach** — Uses Microsoft Entra ID authentication only. Required for subscriptions with Entra-only policies; SQL admin authentication is disabled by policy in those environments.

```bicep
param principalId string
param principalName string
@allowed(['User', 'Group', 'Application'])
param principalType string = 'User'

resource sqlServer 'Microsoft.Sql/servers@2022-05-01-preview' = {
  name: '${resourcePrefix}-sql-${uniqueHash}'
  location: location
  properties: {
    administrators: {
      administratorType: 'ActiveDirectory'
      principalType: principalType
      login: principalName
      sid: principalId
      tenantId: subscription().tenantId
      azureADOnlyAuthentication: true
    }
    minimalTlsVersion: '1.2'
  }
}

resource sqlDatabase 'Microsoft.Sql/servers/databases@2022-05-01-preview' = {
  parent: sqlServer
  name: 'appdb'
  location: location
  sku: {
    name: 'Basic'
    tier: 'Basic'
  }
  properties: {
    collation: 'SQL_Latin1_General_CP1_CI_AS'
    maxSizeBytes: 2147483648  // 2 GB
  }
}

resource sqlFirewallAzure 'Microsoft.Sql/servers/firewallRules@2022-05-01-preview' = {
  parent: sqlServer
  name: 'AllowAzureServices'
  properties: {
    startIpAddress: '0.0.0.0'
    endIpAddress: '0.0.0.0'
  }
}
```

**Set Entra admin parameters:**

1. Get current user info:
```bash
az ad signed-in-user show --query "{id:id, name:displayName}" -o json
```

> ⚠️ **Warning:** If deploying from CI/CD with a service principal, set `principalType` to `'Application'`. The default `'User'` only works for interactive (human) deployments. Mismatched `principalType` causes `UnmatchedPrincipalType` errors during provisioning.

2. Set as azd environment variables:
```bash
PRINCIPAL_INFO=$(az ad signed-in-user show --query "{id:id, name:displayName}" -o json)
azd env set AZURE_PRINCIPAL_ID $(echo $PRINCIPAL_INFO | jq -r '.id')
azd env set AZURE_PRINCIPAL_NAME $(echo $PRINCIPAL_INFO | jq -r '.name')
```

> 💡 **Tip:** Set these variables immediately after `azd init` to avoid deployment failures. The Bicep `principalId` and `principalName` parameters will automatically use these environment variables.

## ⚠️ MANDATORY: Connection String with Entra Auth Parameter

> **CRITICAL:** When outputting SQL connection strings in Bicep (e.g., in App Service `connectionStrings` or as outputs), ALWAYS include an `Authentication` parameter. Use `Authentication=Active Directory Default` for general scenarios or `Authentication=Active Directory Managed Identity` when a user-assigned managed identity with a specific `User Id` is required. A bare `Server=tcp:...;Database=...;` connection string without this parameter will not authenticate via Entra ID and the app will fail to connect.

**Correct pattern in Bicep (Active Directory Default):**

```bicep
connectionStrings: [
  {
    name: 'DefaultConnection'
    connectionString: 'Server=tcp:${sqlServer.properties.fullyQualifiedDomainName},1433;Database=${sqlDatabase.name};Authentication=Active Directory Default;Encrypt=True;TrustServerCertificate=False;'
    type: 'SQLAzure'
  }
]
```

**With user-assigned managed identity:**

```bicep
connectionStrings: [
  {
    name: 'DefaultConnection'
    connectionString: 'Server=tcp:${sqlServer.properties.fullyQualifiedDomainName},1433;Database=${sqlDatabase.name};Authentication=Active Directory Managed Identity;User Id=${uamiClientId};Encrypt=True;TrustServerCertificate=False;'
    type: 'SQLAzure'
  }
]
```

> ❌ **DO NOT** generate connection strings without an `Authentication=Active Directory Default` or `Authentication=Active Directory Managed Identity` parameter.
> ❌ **DO NOT** use manual `AccessToken` assignment or `DefaultAzureCredential().GetToken()` in application code as an alternative to the connection string parameter.

## Serverless Configuration

```bicep
resource sqlDatabase 'Microsoft.Sql/servers/databases@2022-05-01-preview' = {
  parent: sqlServer
  name: 'appdb'
  location: location
  sku: {
    name: 'GP_S_Gen5'
    tier: 'GeneralPurpose'
    family: 'Gen5'
    capacity: 2
  }
  properties: {
    autoPauseDelay: 60  // minutes
    minCapacity: json('0.5')
  }
}
```

## Private Endpoint

```bicep
resource sqlPrivateEndpoint 'Microsoft.Network/privateEndpoints@2023-05-01' = {
  name: '${sqlServer.name}-pe'
  location: location
  properties: {
    subnet: {
      id: subnet.id
    }
    privateLinkServiceConnections: [
      {
        name: '${sqlServer.name}-connection'
        properties: {
          privateLinkServiceId: sqlServer.id
          groupIds: ['sqlServer']
        }
      }
    ]
  }
}
```

## ⛔ MANDATORY: SQL Data-Plane Access via postprovision Hook

> **CRITICAL:** ARM/Bicep role assignments (`SQL DB Contributor`) only grant **control-plane** access. They do **not** grant the app **data-plane** access to the database. Without the T-SQL grant below, apps using `Authentication=Active Directory Default` will crash on startup with a login failure.
>
> **When you generate SQL + Managed Identity infrastructure you MUST also:**
> 1. Add a `postprovision` hook to `azure.yaml` that runs the SQL grant script
> 2. Copy the pre-built scripts from [scripts/grant-sql-access.sh](scripts/grant-sql-access.sh) and [scripts/grant-sql-access.ps1](scripts/grant-sql-access.ps1) to `scripts/` in the user's project root

**azure.yaml hooks section (add or merge):**

```yaml
hooks:
  postprovision:
    posix:
      shell: sh
      run: ./scripts/grant-sql-access.sh
    windows:
      shell: pwsh
      run: ./scripts/grant-sql-access.ps1
```

**Copy the pre-built scripts** — Read [scripts/grant-sql-access.sh](scripts/grant-sql-access.sh) and [scripts/grant-sql-access.ps1](scripts/grant-sql-access.ps1) and write them verbatim to the project's `scripts/` folder. Do not regenerate them from scratch.

Key behaviours of the scripts:
- Installs the `rdbms-connect` Azure CLI extension if not already present (required for `az sql db query`)
- Loads `azd env get-values` safely (no `eval`)
- Grants `db_datareader` + `db_datawriter` by default (idempotent)
- Set `SQL_GRANT_DDLADMIN=true` in the azd env to also grant `db_ddladmin` (needed for EF Core migrations)
- `SERVICE_WEB_NAME` takes priority over `SERVICE_API_NAME` when resolving the app identity

> 💡 Make executable: `chmod +x scripts/*.sh`

> 💡 If the app also uses EF Core migrations, combine this with the migration hook — see the `azure-deploy` skill's `references/recipes/azd/sql-managed-identity.md`.

## Legacy SQL Authentication (⛔ DO NOT USE - EVER)

> ❌ **PROHIBITED — NEVER generate `administratorLogin` or `administratorLoginPassword` properties.**
> This applies unconditionally: do NOT include them in direct assignments, conditional expressions, ternary branches, parameter defaults, or any other construct. The **text** of these property names must not appear anywhere in a generated `.bicep` file.
> SQL admin authentication is disabled in all subscriptions with Entra-only policies and violates Azure security best practices.
> Always use the Entra-only authentication pattern at the top of this file.
>
> ❌ **DO NOT generate conditional patterns like:**
> ```bicep
> properties: useEntraAuth ? {
>   administrators: {
>     azureADOnlyAuthentication: true
>     // ...
>   }
> } : {
>   administratorLogin: sqlAdminLogin          // ❌ PROHIBITED
>   administratorLoginPassword: sqlAdminPassword  // ❌ PROHIBITED
> }
> ```
> Use only the unconditional Entra-only pattern. No fallback. No toggle. No conditional.
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 321kUpdated Claude CodeCodexVerifiedInstall
xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.Stars: 197kUpdated Claude CodeCodexVerifiedInstall
shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release.Stars: 118kUpdated Claude CodeCodexVerifiedInstall