Skip to content

Robertjam954/multimodal_rag_application / .claude/skills/azure-prepare

azure-prepare

Flagged

Prepare 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".

FileKindSize
SKILL.mdskill md13.1 KB
references/analyze.mdmarkdown4.3 KB
references/apim.mdmarkdown5.7 KB
references/architecture.mdmarkdown6.3 KB
references/aspire.mdmarkdown18.2 KB
references/auth-best-practices.mdmarkdown6.1 KB
references/azure-context.mdmarkdown5.7 KB
references/functional-verification.mdmarkdown3.2 KB
references/generate.mdmarkdown5.3 KB
references/global-rules.mdmarkdown2.0 KB
references/plan-template.mdmarkdown10.1 KB
references/recipe-selection.mdmarkdown3.2 KB
references/recipes/azcli/README.mdmarkdown1.8 KB
references/recipes/azcli/commands.mdmarkdown1.6 KB
references/recipes/azcli/scripts.mdmarkdown2.2 KB
references/recipes/azd/README.mdmarkdown3.8 KB
references/recipes/azd/aspire.mdmarkdown8.9 KB
references/recipes/azd/azure-yaml.mdmarkdown6.7 KB
references/recipes/azd/docker.mdmarkdown2.0 KB
references/recipes/azd/iac-rules.mdmarkdown5.8 KB
references/recipes/azd/terraform.mdmarkdown14.0 KB
references/recipes/bicep/README.mdmarkdown1.4 KB
references/recipes/bicep/patterns.mdmarkdown3.0 KB
references/recipes/terraform/README.mdmarkdown2.5 KB
references/recipes/terraform/patterns.mdmarkdown3.5 KB
references/region-availability.mdmarkdown1.7 KB
references/requirements.mdmarkdown2.5 KB
references/research.mdmarkdown8.8 KB
references/resources-limits-quotas.mdmarkdown13.0 KB
references/runtimes/nodejs.mdmarkdown5.9 KB
references/scan.mdmarkdown3.5 KB
references/sdk/azd-deployment.mdmarkdown792 B
references/sdk/azure-appconfiguration-java.mdmarkdown1.5 KB
references/sdk/azure-appconfiguration-py.mdmarkdown1.1 KB
references/sdk/azure-appconfiguration-ts.mdmarkdown1.2 KB
references/sdk/azure-identity-dotnet.mdmarkdown941 B
references/sdk/azure-identity-java.mdmarkdown1.2 KB
references/sdk/azure-identity-py.mdmarkdown1.1 KB
references/sdk/azure-identity-ts.mdmarkdown1.1 KB
references/security.mdmarkdown8.5 KB
references/services/aks/README.mdmarkdown1.0 KB
references/services/aks/addons.mdmarkdown957 B
references/services/aks/bicep.mdmarkdown1.6 KB
references/services/aks/manifests.mdmarkdown1.4 KB
references/services/app-insights/README.mdmarkdown848 B
references/services/app-service/README.mdmarkdown2.3 KB
references/services/app-service/bicep.mdmarkdown4.2 KB
references/services/app-service/custom-domains.mdmarkdown4.8 KB
references/services/app-service/deployment-slots.mdmarkdown4.5 KB
references/services/app-service/networking.mdmarkdown6.6 KB
references/services/app-service/scaling.mdmarkdown1.5 KB
references/services/app-service/sku-selection.mdmarkdown4.7 KB
references/services/app-service/templates/recipes/README.mdmarkdown2.8 KB
references/services/app-service/templates/recipes/auth/README.mdmarkdown3.1 KB
references/services/app-service/templates/recipes/auth/source/dotnet.mdmarkdown1.3 KB
references/services/app-service/templates/recipes/auth/source/nodejs.mdmarkdown2.5 KB
references/services/app-service/templates/recipes/auth/source/python.mdmarkdown2.2 KB
references/services/app-service/templates/recipes/composition.mdmarkdown4.8 KB
references/services/app-service/templates/recipes/cosmos/README.mdmarkdown3.6 KB
references/services/app-service/templates/recipes/cosmos/source/dotnet.mdmarkdown1.3 KB
references/services/app-service/templates/recipes/cosmos/source/nodejs.mdmarkdown1.2 KB
references/services/app-service/templates/recipes/cosmos/source/python.mdmarkdown1.1 KB
references/services/app-service/templates/recipes/redis/README.mdmarkdown3.3 KB
references/services/app-service/templates/recipes/redis/source/dotnet.mdmarkdown1.6 KB
references/services/app-service/templates/recipes/redis/source/nodejs.mdmarkdown2.2 KB
references/services/app-service/templates/recipes/redis/source/python.mdmarkdown2.9 KB
references/services/app-service/templates/recipes/sql/README.mdmarkdown3.5 KB
references/services/app-service/templates/recipes/sql/source/dotnet.mdmarkdown2.9 KB
references/services/app-service/templates/recipes/sql/source/nodejs.mdmarkdown3.0 KB
references/services/app-service/templates/recipes/sql/source/python.mdmarkdown4.4 KB
references/services/app-service/templates/selection.mdmarkdown2.8 KB
references/services/app-service/templates/web-api.mdmarkdown4.9 KB
references/services/app-service/templates/web-app.mdmarkdown4.9 KB
references/services/container-apps/README.mdmarkdown1.3 KB
references/services/container-apps/bicep.mdmarkdown4.8 KB
references/services/container-apps/day2-operations.mdmarkdown5.1 KB
references/services/container-apps/environment.mdmarkdown1.2 KB
references/services/container-apps/health-probes.mdmarkdown1.1 KB
references/services/container-apps/networking.mdmarkdown5.1 KB
references/services/container-apps/revisions.mdmarkdown4.9 KB
references/services/container-apps/scaling.mdmarkdown1.4 KB
references/services/container-apps/terraform.mdmarkdown6.1 KB
references/services/cosmos-db/README.mdmarkdown1.4 KB
references/services/cosmos-db/bicep.mdmarkdown1.8 KB
references/services/cosmos-db/partitioning.mdmarkdown1.1 KB
references/services/cosmos-db/sdk.mdmarkdown1.6 KB
references/services/durable-task-scheduler/README.mdmarkdown4.9 KB
references/services/durable-task-scheduler/bicep.mdmarkdown4.8 KB
references/services/durable-task-scheduler/dotnet.mdmarkdown6.1 KB
references/services/durable-task-scheduler/java.mdmarkdown7.7 KB
references/services/durable-task-scheduler/javascript.mdmarkdown5.6 KB
references/services/durable-task-scheduler/python.mdmarkdown6.4 KB
references/services/event-grid/README.mdmarkdown1.0 KB
references/services/event-grid/bicep.mdmarkdown1.7 KB
references/services/event-grid/subscriptions.mdmarkdown1.6 KB
references/services/foundry/README.mdmarkdown1.3 KB
references/services/foundry/region-availability.mdmarkdown826 B
references/services/functions/README.mdmarkdown3.8 KB
references/services/functions/aspire-containerapps.mdmarkdown3.3 KB
references/services/functions/bicep.mdmarkdown11.9 KB
references/services/functions/durable.mdmarkdown1.8 KB
references/services/functions/templates/README.mdmarkdown6.5 KB
references/services/functions/templates/base/eval/python.mdmarkdown762 B
references/services/functions/templates/base/eval/summary.mdmarkdown1.9 KB
references/services/functions/templates/base/eval/typescript.mdmarkdown1.1 KB
references/services/functions/templates/recipes/README.mdmarkdown1.1 KB
references/services/functions/templates/recipes/blob-eventgrid/README.mdmarkdown1.6 KB
references/services/functions/templates/recipes/blob-eventgrid/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/blob-eventgrid/eval/summary.mdmarkdown2.6 KB
references/services/functions/templates/recipes/common/dotnet-entry-point.mdmarkdown2.0 KB
references/services/functions/templates/recipes/common/error-handling.mdmarkdown2.2 KB
references/services/functions/templates/recipes/common/health-check.mdmarkdown2.7 KB
references/services/functions/templates/recipes/common/nodejs-entry-point.mdmarkdown4.1 KB
references/services/functions/templates/recipes/composition.mdmarkdown11.1 KB
references/services/functions/templates/recipes/cosmosdb/README.mdmarkdown1.5 KB
references/services/functions/templates/recipes/cosmosdb/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/cosmosdb/eval/summary.mdmarkdown1.8 KB
references/services/functions/templates/recipes/cosmosdb/eval/typescript.mdmarkdown1.3 KB
references/services/functions/templates/recipes/durable/README.mdmarkdown1.8 KB
references/services/functions/templates/recipes/durable/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/durable/eval/summary.mdmarkdown1.6 KB
references/services/functions/templates/recipes/eventhubs/README.mdmarkdown1.2 KB
references/services/functions/templates/recipes/eventhubs/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/eventhubs/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/recipes/mcp/README.mdmarkdown1.9 KB
references/services/functions/templates/recipes/mcp/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/mcp/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/recipes/servicebus/README.mdmarkdown1.3 KB
references/services/functions/templates/recipes/servicebus/eval/python.mdmarkdown1.3 KB
references/services/functions/templates/recipes/servicebus/eval/summary.mdmarkdown1.8 KB
references/services/functions/templates/recipes/servicebus/eval/typescript.mdmarkdown1.4 KB
references/services/functions/templates/recipes/sql/README.mdmarkdown1.8 KB
references/services/functions/templates/recipes/sql/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/sql/eval/summary.mdmarkdown2.8 KB
references/services/functions/templates/recipes/timer/README.mdmarkdown1.5 KB
references/services/functions/templates/recipes/timer/eval/python.mdmarkdown1.2 KB
references/services/functions/templates/recipes/timer/eval/summary.mdmarkdown1.5 KB
references/services/functions/templates/selection.mdmarkdown4.3 KB
references/services/functions/terraform.mdmarkdown13.3 KB
references/services/key-vault/README.mdmarkdown1.3 KB
references/services/key-vault/bicep.mdmarkdown1.7 KB
references/services/key-vault/sdk.mdmarkdown1.9 KB
references/services/logic-apps/README.mdmarkdown1.0 KB
references/services/logic-apps/bicep.mdmarkdown1.8 KB
references/services/logic-apps/triggers.mdmarkdown1.7 KB
references/services/service-bus/README.mdmarkdown1.4 KB
references/services/service-bus/bicep.mdmarkdown3.7 KB
references/services/service-bus/patterns.mdmarkdown4.2 KB
references/services/sql-database/README.mdmarkdown1.9 KB
references/services/sql-database/auth.mdmarkdown4.0 KB
references/services/sql-database/bicep.mdmarkdown7.8 KB
references/services/sql-database/scripts/grant-sql-access.ps1script3.5 KB
references/services/sql-database/scripts/grant-sql-access.shscript3.6 KB
references/services/sql-database/sdk.mdmarkdown1.8 KB
references/services/static-web-apps/README.mdmarkdown1.3 KB
references/services/static-web-apps/bicep.mdmarkdown1.0 KB
references/services/static-web-apps/deployment.mdmarkdown1.8 KB
references/services/static-web-apps/region-availability.mdmarkdown674 B
references/services/static-web-apps/routing.mdmarkdown1.2 KB
references/services/static-web-apps/terraform.mdmarkdown3.5 KB
references/services/storage/README.mdmarkdown1.4 KB
references/services/storage/access.mdmarkdown3.6 KB
references/services/storage/bicep.mdmarkdown1.7 KB
references/specialized-routing.mdmarkdown4.5 KB

references/services/app-service/templates/recipes/sql/source/python.md

View on GitHub
# SQL Database — Python — REFERENCE ONLY

## SQLAlchemy Setup

Add SQLAlchemy with Azure SQL and managed identity support to a FastAPI app.

### Requirements

Add to `requirements.txt`:

```
sqlalchemy>=2.0
pyodbc
azure-identity
fastapi
uvicorn
```

### Database Configuration

Create `database.py`:

```python
import os
import struct
from sqlalchemy import create_engine, event
from sqlalchemy.orm import sessionmaker, DeclarativeBase
from azure.identity import ManagedIdentityCredential


class Base(DeclarativeBase):
    pass


def create_db_engine():
    """Create SQLAlchemy engine using managed identity or connection string."""
    conn_str = os.environ.get("AZURE_SQL_CONNECTION_STRING")
    if conn_str:
        # Local dev: AZURE_SQL_CONNECTION_STRING is a SQLAlchemy URL
        # e.g. mssql+pyodbc://sa:password@localhost/myapp?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes
        return create_engine(conn_str)

    # Azure: use managed identity token (refreshed per-connection so pool stays valid past 1 hour)
    server = os.environ["AZURE_SQL_SERVER"]
    database = os.environ["AZURE_SQL_DATABASE"]
    client_id = os.environ.get("AZURE_CLIENT_ID")
    credential = ManagedIdentityCredential(client_id=client_id) if client_id else ManagedIdentityCredential()

    odbc_conn = (
        f"DRIVER={{ODBC Driver 18 for SQL Server}};"
        f"SERVER={server};"
        f"DATABASE={database};"
        f"Encrypt=yes;TrustServerCertificate=no;"
    )
    engine = create_engine(
        "mssql+pyodbc://",
        connect_args={"odbc_connect": odbc_conn},
    )

    @event.listens_for(engine, "do_connect")
    def provide_token(dialect, conn_rec, cargs, cparams):
        # Fetch a fresh token for every new physical connection — pool refills won't fail after 1h
        token = credential.get_token("https://database.windows.net/.default")
        token_bytes = token.token.encode("utf-16-le")
        token_struct = struct.pack(f"<I{len(token_bytes)}s", len(token_bytes), token_bytes)
        cparams["attrs_before"] = {1256: token_struct}  # SQL_COPT_SS_ACCESS_TOKEN

    return engine


engine = create_db_engine()
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
```

### Models

Create `models.py`:

```python
from sqlalchemy import Column, Integer, String, Boolean
from database import Base

class TodoItem(Base):
    __tablename__ = "todo_items"

    id = Column(Integer, primary_key=True, index=True)
    title = Column(String(200), nullable=False)
    is_complete = Column(Boolean, default=False)
```

### API Endpoints

Add to `main.py` — do NOT replace existing routes:

```python
from fastapi import Depends, HTTPException
from sqlalchemy.orm import Session
from database import SessionLocal, engine, Base
from models import TodoItem
from pydantic import BaseModel

Base.metadata.create_all(bind=engine)

def get_db():
    db = SessionLocal()
    try:
        yield db
    finally:
        db.close()

class TodoCreate(BaseModel):
    title: str
    is_complete: bool = False

@app.get("/api/todos")
def list_todos(db: Session = Depends(get_db)):
    return db.query(TodoItem).all()

@app.get("/api/todos/{todo_id}")
def get_todo(todo_id: int, db: Session = Depends(get_db)):
    todo = db.query(TodoItem).filter(TodoItem.id == todo_id).first()
    if not todo:
        raise HTTPException(status_code=404, detail="Not found")
    return todo

@app.post("/api/todos", status_code=201)
def create_todo(todo: TodoCreate, db: Session = Depends(get_db)):
    db_todo = TodoItem(**todo.model_dump())
    db.add(db_todo)
    db.commit()
    db.refresh(db_todo)
    return db_todo
```

### Local Development

For local development without managed identity, use SQL authentication:

```python
# .env (local only — never commit)
AZURE_SQL_CONNECTION_STRING=mssql+pyodbc://<username>:<password>@localhost/myapp?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes
```

## Files to Add

| File | Action |
|------|--------|
| `database.py` | Create — engine, session, managed identity token |
| `models.py` | Create — SQLAlchemy ORM models |
| `main.py` | Modify — add CRUD endpoints + DB dependency |
| `requirements.txt` | Modify — add sqlalchemy, pyodbc, azure-identity |

## Common Patterns

- Use `Depends(get_db)` for session lifecycle management
- Use `Base.metadata.create_all()` only for dev; use Alembic migrations in production
- Never store SQL passwords in app settings — use managed identity tokens
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 321kUpdated Claude CodeCodexVerifiedInstall
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: 197kUpdated Claude CodeCodexVerifiedInstall
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall