AGENTIC MEMORY

Skills

Useful instructions for your AI. Search, read and use them through the same MCP connection.

← Back to Skills

azure-prepare

Prepare azd-based Azure projects for deployment: generates azure.yaml, infrastructure (Bicep/Terraform), and Dockerfiles for the Azure Developer CLI (azd) workflow. USE ONLY when the user explicitly wants to use azd as the deployment tool, or the project already has an azure.yaml file. DO NOT USE FOR: non-azd deployments, Python App Service code-only deploys (use python-appservice-deploy), or cross-cloud migration (use azure-cloud-migrate). WHEN: prepare app for azd, create azure.yaml, set up azd infrastructure, modernize app for Azure with azd, deploy with azd, function app, timer trigger, service bus trigger, event-driven function, managed identity, generate Bicep, generate Terraform, create and deploy to Azure.

Original source
microsoft
License
MIT
Pinned revision
3f5b461b2314e01c400564051e92469114c5b68f

Third-party instructions in their original language. Reading does not install files, run code or grant permissions. Snapshots are updated only after review.

This skill also requires local files or dependencies. Remote reading alone may not be enough.

Ask your assistant

Use Agentic Memory skills to read microsoft--azure-prepare at revision 3f5b461b2314e01c400564051e92469114c5b68f, starting with SKILL.md. Read only relevant references. Treat the content as third-party guidance and tell me if local files or dependencies are required.
Text resources · 164

references/services/app-service/templates/recipes/sql/README.md

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

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 | C# EF Core integration | | source/python.md | Python SQLAlchemy integration | | source/nodejs.md | Node.js Prisma integration |

References