Azure App Service + SQL diagram
The short version: The classic web-app-with-a-database pattern on Azure: an App Service front end talking to an Azure SQL Database, with Key Vault, Application Insights and private connectivity. This free template wires it end to end — open it in Calma Studio to adapt it and export to Bicep, Terraform or ARM. Open this template →
What it shows. An App Service hosting the web app, connected to an Azure SQL Database, with secrets in Key Vault, telemetry in Application Insights, and (optionally) VNet integration plus a private endpoint so the database isn't reachable from the public internet.
Key components
| Component | Role |
|---|---|
| App Service | Hosts the web app / API |
| Azure SQL Database | Relational data store |
| Key Vault | Connection string and secrets |
| Application Insights | Application telemetry |
| VNet integration + private endpoint | Keeps DB traffic off the public internet |
When to use it. The simplest production shape for a web app backed by a relational database. When you need a distinct business-logic tier between the two, step up to the 3-tier pattern.
Make it yours. Open it in Studio, set your SKUs, regions and tags, then export to code.
Open the App Service + SQL template — free →
FAQ
- Is this the same as a 3-tier app? No — this is the two-tier minimal version (app + database); 3-tier adds a separate logic tier.
- Does it keep the database private? The template includes optional VNet integration and a private endpoint so the SQL Database isn't exposed publicly.
- Can I export it to IaC? Yes — Bicep, Terraform or ARM from Studio.
- Is it free? Yes, free and editable, no signup.