Robertjam954/multimodal_rag_application / .claude/skills/azure-prepare
azure-prepare
FlaggedPrepare 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".
references/services/app-service/templates/recipes/sql/README.md
View on GitHub# SQL Database Recipe — REFERENCE ONLY
Adds Azure SQL Database integration to an App Service base template.
## Overview
This recipe composes with a Web API or Web App base template to add Azure SQL Database connectivity. It provides the IaC delta (SQL Server, database, firewall, RBAC) and per-language source code using EF Core, Prisma, or SQLAlchemy.
## Integration Type
| Aspect | Value |
|--------|-------|
| **Database** | Azure SQL Database (Serverless or Provisioned) |
| **Auth** | Managed identity (passwordless) |
| **ORM** | EF Core (.NET), Prisma (Node.js), SQLAlchemy (Python) |
| **Hosting** | App Service (from base template) |
| **Local Auth** | Disabled in Azure (Entra ID only); local dev may use SQL auth |
## Composition Steps
Apply these steps AFTER `azd init -t <base-template>`:
| # | Step | Details |
|---|------|---------|
| 1 | **Add IaC module** | Add SQL Server + Database Bicep module to `infra/app/` |
| 2 | **Wire into main** | Add module reference in `main.bicep` |
| 3 | **Add app settings** | Add SQL connection string (managed identity) |
| 4 | **Add source code** | Add ORM models, DbContext/client setup from `source/{lang}.md` |
| 5 | **Add packages** | Add ORM and SQL client packages |
| 6 | **Run migrations** | Add postprovision hook for DB schema setup |
## App Settings
| Setting | Value | Purpose |
|---------|-------|---------|
| `AZURE_SQL_CONNECTION_STRING` | `Server=tcp:{server}.database.windows.net;Database={db};Authentication=Active Directory Managed Identity;User Id={clientId};` | Passwordless SQL connection |
### Bicep App Settings Block
```bicep
appSettings: [
{
name: 'AZURE_SQL_CONNECTION_STRING'
value: 'Server=tcp:${sqlServer.properties.fullyQualifiedDomainName},1433;Database=${sqlDatabase.name};Authentication=Active Directory Managed Identity;User Id=${managedIdentity.properties.clientId};Encrypt=True;TrustServerCertificate=False;'
}
]
```
> **Note:** The `Authentication=Active Directory Managed Identity` setting tells the SQL client to use the app's managed identity. No passwords are stored.
## RBAC Roles Required
| Role | GUID | Scope | Purpose |
|------|------|-------|---------|
| **SQL DB Contributor** | `9b7fa17d-e63e-47b0-bb0a-15c516ac86ec` | SQL Server | Manage database |
| **Directory Readers** | `88d8e3e3-8f55-4a1e-953a-9b9898b8876b` | Entra ID | Read directory for MI auth |
> **Important:** Data plane access uses SQL-level roles (`db_datareader`, `db_datawriter`), assigned via a postprovision script that runs `ALTER ROLE` statements.
## Resources Created
| Resource | Type | Purpose |
|----------|------|---------|
| SQL Server | `Microsoft.Sql/servers` | Logical SQL server |
| SQL Database | `Microsoft.Sql/servers/databases` | Application database |
| Firewall Rule | `Microsoft.Sql/servers/firewallRules` | Allow Azure services |
| Entra Admin | `Microsoft.Sql/servers/administrators` | Set MI as admin |
## Files
| Path | Description |
|------|-------------|
| [source/dotnet.md](source/dotnet.md) | C# EF Core integration |
| [source/python.md](source/python.md) | Python SQLAlchemy integration |
| [source/nodejs.md](source/nodejs.md) | Node.js Prisma integration |
## References
- [Azure SQL passwordless connections](https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration)
- [EF Core with Azure SQL](https://learn.microsoft.com/en-us/ef/core/providers/sql-server/)
- [Tutorial: App Service with SQL](https://learn.microsoft.com/en-us/azure/app-service/tutorial-dotnetcore-sqldb-app)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |