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/scripts/grant-sql-access.ps1

View on GitHub
# Grant Azure SQL data-plane access to the App Service / Container App managed identity.
#
# USAGE: Copy this file to scripts/grant-sql-access.ps1 in your project root and add
#        a postprovision hook in azure.yaml:
#
#   hooks:
#     postprovision:
#       posix:
#         shell: sh
#         run: ./scripts/grant-sql-access.sh
#       windows:
#         shell: pwsh
#         run: ./scripts/grant-sql-access.ps1
#
# ENVIRONMENT VARIABLES (sourced from azd env):
#   SQL_SERVER           - SQL server name (without .database.windows.net)
#   SQL_DATABASE         - Database name
#   AZURE_RESOURCE_GROUP - Resource group name
#   SERVICE_WEB_NAME     - App Service name (used when set, takes priority)
#   SERVICE_API_NAME     - API service name (fallback when SERVICE_WEB_NAME is not set)
#   SQL_GRANT_DDLADMIN   - Set to "true" to also grant db_ddladmin (needed for EF migrations)

$ErrorActionPreference = 'Stop'

# Load azd environment variables
azd env get-values | ForEach-Object {
    $name, $value = $_.Split('=', 2)
    Set-Item "env:$name" $value.Trim('"')
}

# Determine app identity name (App Service uses SERVICE_WEB_NAME, APIs use SERVICE_API_NAME)
$AppName = if ($env:SERVICE_WEB_NAME) { $env:SERVICE_WEB_NAME } else { $env:SERVICE_API_NAME }

if (-not $AppName) {
    throw "ERROR: Neither SERVICE_WEB_NAME nor SERVICE_API_NAME is set in azd environment."
}

Write-Host "Granting SQL data-plane access to managed identity: $AppName"

# Build idempotent SQL grant queries (reader + writer, required for all apps)
$SqlQuery = @"
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = '$AppName')
  CREATE USER [$AppName] FROM EXTERNAL PROVIDER;

IF NOT EXISTS (
  SELECT 1 FROM sys.database_role_members drm
  JOIN sys.database_principals r ON drm.role_principal_id = r.principal_id
  JOIN sys.database_principals m ON drm.member_principal_id = m.principal_id
  WHERE r.name = 'db_datareader' AND m.name = '$AppName'
)
  ALTER ROLE db_datareader ADD MEMBER [$AppName];

IF NOT EXISTS (
  SELECT 1 FROM sys.database_role_members drm
  JOIN sys.database_principals r ON drm.role_principal_id = r.principal_id
  JOIN sys.database_principals m ON drm.member_principal_id = m.principal_id
  WHERE r.name = 'db_datawriter' AND m.name = '$AppName'
)
  ALTER ROLE db_datawriter ADD MEMBER [$AppName];
"@

# Optionally grant db_ddladmin (needed when EF Core migrations run at startup or via hook)
$GrantDdlAdmin = $env:SQL_GRANT_DDLADMIN -eq 'true'
if ($GrantDdlAdmin) {
    $SqlQuery += @"

IF NOT EXISTS (
  SELECT 1 FROM sys.database_role_members drm
  JOIN sys.database_principals r ON drm.role_principal_id = r.principal_id
  JOIN sys.database_principals m ON drm.member_principal_id = m.principal_id
  WHERE r.name = 'db_ddladmin' AND m.name = '$AppName'
)
  ALTER ROLE db_ddladmin ADD MEMBER [$AppName];
"@
}

# Ensure the rdbms-connect extension is installed (provides 'az sql db query')
az extension show --name rdbms-connect *> $null
if ($LASTEXITCODE -ne 0) {
    Write-Host "Azure CLI extension 'rdbms-connect' is not installed. Installing..."
    az extension add --name rdbms-connect --yes
    if ($LASTEXITCODE -ne 0) {
        throw "ERROR: Failed to install Azure CLI extension 'rdbms-connect'. Cannot continue because 'az sql db query' requires it."
    }
}

az sql db query `
  --server $env:SQL_SERVER `
  --database $env:SQL_DATABASE `
  --resource-group $env:AZURE_RESOURCE_GROUP `
  --auth-mode ActiveDirectoryDefault `
  --queries $SqlQuery

Write-Host "SQL access granted successfully."
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