skilld
All skills
microsoft avatar

/azure-prepare

@7995851 official
by microsoftmicrosoft/github-copilot-for-azure253 stars
206

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.

Ask your Agent

Use this Skill: https://skilld.dev/gh/microsoft/github-copilot-for-azure/azure-prepare

This session only. Nothing lands on disk.

referencesservicesapp-servicetemplatesrecipessqlREADME.md

≈889 tokens on demand. Your agent reads this file only when SKILL.md points to it.

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

Source: SKILL.md on GitHub

Third-party checks

1 alert8d4 checks · Risk SAFE
  • Gen Agent Trust Hub8d

    The azure-prepare skill provides a comprehensive environment for preparing Azure applications for deployment. It focuses on generating infrastructure-as-code and deployment configuration while strictly enforcing security best practices like managed identity usage and secret management via Key Vault. No malicious patterns or security risks were identified.

  • Socket8d

    5 alerts: gptAnomaly, gptSecurity

  • Snyk8d

    Risk: LOW · No issues

  • Runlayer6mo

    68/196 files flagged

Provenance

Signed by skilld at 7995851. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 weeks ago

Capability

metadata
{
  "author": "Microsoft",
  "version": "0.0.0-placeholder"
}

Topics

  • Infrastructure
  • azure
  • bicep
  • terraform
  • deployment
  • docker
  • functions
  • app-service

README badge

README badge for microsoft/github-copilot-for-azure/azure-prepare

What it does

Prepares Azure applications for deployment by generating infrastructure templates (Bicep or Terraform), azure.yaml configuration, and Dockerfiles. Covers new app creation, modernization, and hosting on App Service, Container Apps, or Functions—but excludes Python App Service deployments, copilot SDK apps, and cross-cloud migrations which have dedicated skills.

Generated from the current SKILL.md.

Frequently asked

Does this skill handle Python App Service deployments?
No. Use the python-appservice-deploy skill instead for Python code-only App Service deploys.
Can I use this skill for cross-cloud migration?
No. This skill is for Azure-native preparation. Use azure-cloud-migrate for migrations from AWS, GCP, or other clouds.
Does this skill support Copilot SDK apps?
No. Use azure-hosted-copilot-sdk for apps with @github/copilot-sdk or CopilotClient.
What infrastructure templates does this skill support?
Azure Developer CLI (azd), Bicep, Terraform, and Azure CLI. The skill creates infrastructure code, Dockerfiles, and configuration files—actual deployment execution is handled by the azure-deploy skill.
Does this skill delete existing project files?
No. When adding features to existing projects, it modifies files rather than deletes them. It never removes the project or workspace directory itself.

Generated from the current SKILL.md. These answers refresh after source changes.