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/source/dotnet.md
View on GitHub# SQL Database — C# (.NET) — REFERENCE ONLY
## Entity Framework Core Setup
Add EF Core with Azure SQL and managed identity support to an ASP.NET Core app.
### NuGet Packages
```xml
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.*" />
<PackageReference Include="Azure.Identity" Version="1.13.*" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.*" />
```
### DbContext
Create `Data/AppDbContext.cs`:
```csharp
using Microsoft.EntityFrameworkCore;
namespace MyApp.Data;
public class AppDbContext : DbContext
{
public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) { }
public DbSet<TodoItem> TodoItems => Set<TodoItem>();
}
public class TodoItem
{
public int Id { get; set; }
public string Title { get; set; } = string.Empty;
public bool IsComplete { get; set; }
}
```
### Program.cs (additions)
Add these lines to `Program.cs` — do NOT replace the file:
```csharp
using Microsoft.EntityFrameworkCore;
using MyApp.Data;
// Add after builder creation
var connectionString = builder.Configuration.GetConnectionString("AZURE_SQL")
?? builder.Configuration["AZURE_SQL_CONNECTION_STRING"];
builder.Services.AddDbContext<AppDbContext>(options =>
options.UseSqlServer(connectionString));
// Add health check for SQL
builder.Services.AddHealthChecks()
.AddDbContextCheck<AppDbContext>();
// After app build — map health checks so App Service probes reflect SQL connectivity
app.MapHealthChecks("/health");
```
### API Endpoints
Add to `Program.cs` after `app` is built:
```csharp
app.MapGet("/api/todos", async (AppDbContext db) =>
await db.TodoItems.ToListAsync());
app.MapGet("/api/todos/{id}", async (int id, AppDbContext db) =>
await db.TodoItems.FindAsync(id) is TodoItem todo
? Results.Ok(todo)
: Results.NotFound());
app.MapPost("/api/todos", async (TodoItem todo, AppDbContext db) =>
{
db.TodoItems.Add(todo);
await db.SaveChangesAsync();
return Results.Created($"/api/todos/{todo.Id}", todo);
});
```
### appsettings.json
```json
{
"ConnectionStrings": {
"AZURE_SQL": "Server=localhost;Database=myapp;Trusted_Connection=true;"
}
}
```
> In production, the `AZURE_SQL_CONNECTION_STRING` app setting from Azure overrides this with the managed identity connection string.
### EF Migrations (postprovision hook)
Create `infra/scripts/setup-db.sh`:
```bash
#!/bin/bash
dotnet ef database update --project src/api
```
## Files to Add
| File | Action |
|------|--------|
| `Data/AppDbContext.cs` | Create — DbContext + entity models |
| `Program.cs` | Modify — add DbContext registration + endpoints |
| `appsettings.json` | Modify — add ConnectionStrings section |
## Common Patterns
- Always use `AddHealthChecks().AddDbContextCheck<>()` for SQL health monitoring
- Use `AsNoTracking()` for read-only queries to improve performance
- Apply migrations via postprovision hook, not at app startup
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 |