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/functions/templates/recipes/sql/eval/summary.md

View on GitHub
# Eval Summary

## Coverage Status

| Language | Manifest Templates | Eval | Status |
|----------|-------------------|------|--------|
| Python | 1 (Bicep) | ✅ | ✅ Verified |
| TypeScript | 1 (Bicep) | — | 📋 AZD template exists |
| C# (.NET) | 1 (Bicep) | — | 📋 AZD template exists |
| Java | — | — | ⚠️ No AZD template |
| JavaScript | — | — | ⚠️ No AZD template |
| PowerShell | — | — | ⚠️ No AZD template |

> ⚠️ **Eval cost note:** Each language eval requires ~5 min of agent runtime. Python is verified end-to-end; other languages confirmed in [manifest](https://cdn.functions.azure.com/public/templates-manifest/manifest.json). Java, JavaScript, and PowerShell have no SQL AZD template. Multi-language eval expansion tracked as follow-up.

## MCP Tool Validation

| Test | Status | Details |
|------|--------|---------|
| `functions_template_get` | ✅ PASS | 2 calls via `azure-functions` MCP tool |
| Template Discovery | ✅ PASS | Templates found via resource filter |
| IaC Included | ✅ PASS | SQL Server Bicep + RBAC in projectFiles |
| E2E Agent Test | ✅ PASS | 2 `azure-functions` calls, template `sql-trigger-python-azd` retrieved and applied |

## IaC Validation

| IaC Type | File | Syntax | Policy Compliant | Status |
|----------|------|--------|------------------|--------|
| Bicep | sql.bicep | ✅ | ✅ | PASS |
| Terraform | sql.tf | ✅ | ✅ | PASS |

## Deployment Validation

| Test | Status | Details |
|------|--------|---------|
| AZD Template Init | ✅ PASS | `functions-quickstart-python-azd-sql` |
| AZD Provision | ✅ PASS | Resources created in `rg-sql-eval` |
| AZD Deploy | ✅ PASS | Function deployed to `func-api-arkwcvhvbkqwc` |
| HTTP Response | ✅ PASS | HTTP 200 from function endpoint |
| SQL Server | ✅ PASS | `sql-arkwcvhvbkqwc` with Entra-only auth |
| SQL Database | ✅ PASS | `ToDo` database created |

## Results

| Test | Python |
|------|--------|
| Health | ✅ |
| SQL trigger | ✅ |
| SQL output | ✅ |

## Notes

- Templates retrieved via `functions_template_get(language: "<language>", template: "<template-name>")` MCP tool
- Dedicated AZD templates available for Python, TypeScript, .NET
- Requires T-SQL post-deploy for managed identity access

## IaC Features

| Feature | Bicep | Terraform |
|---------|-------|-----------|
| SQL Server (Entra-only) | ✅ | ✅ |
| SQL Database | ✅ | ✅ |
| Firewall Rules | ✅ | ✅ |
| Private Endpoint (VNet) | ✅ | ✅ |
| Azure Policy Compliance | ✅ | ✅ |

## Post-Deploy Note

SQL managed identity access requires T-SQL after deployment:
```sql
CREATE USER [<function-app-name>] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [<function-app-name>];
ALTER ROLE db_datawriter ADD MEMBER [<function-app-name>];
```

## Test Date

2026-04-22
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated 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