data-api-builder-auth-mastery
Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
メニュー
Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Run SQL Commander as a companion container for browser-based SQL access, with optional Azure Container Apps configuration.
Orchestrate SQL Server and Data API Builder with .NET Aspire for local development, health-aware startup, and dashboard-driven diagnostics.
Add MCP Inspector to .NET Aspire AppHost for local SQL MCP Server validation and tool discovery.
Add SQL Commander to .NET Aspire for lightweight SQL browsing and query execution during local DAB development.
Use SQL Database Projects (.sqlproj) with .NET Aspire for declarative schema deployment via dacpac.
Deploy Data API Builder and SQL MCP Server to Azure App Service for Linux, with or without containers.
| name | data-api-builder-auth-mastery |
| description | Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end. |
| license | MIT |
runtime.host.authentication with jwt.audience / jwt.issuer.X-MS-API-ROLE, entity permissions, and claim-backed policies.Unauthenticated — default; DAB validates no identity and every request is Anonymous.StaticWebApps — Azure Static Web Apps platform identity headers.AppService — EasyAuth; trusts X-MS-CLIENT-PRINCIPAL and claims injected by App Service.EntraID / AzureAD — Microsoft Entra JWT bearer; requires jwt.audience and jwt.issuer.Custom — generic OIDC/JWT providers (Okta, Auth0, Keycloak); also requires jwt.audience and jwt.issuer.Simulator — development mode only; defaults to Authenticated and lets X-MS-API-ROLE choose test roles.Unauthenticated; Azure host → StaticWebApps/AppService; Entra → EntraID; third-party JWT → Custom; local role testing → Simulator.runtime.host.authentication.provider; add jwt.audience + jwt.issuer only for JWT providers.permissions as [{ role, actions }]; use valid actions: create, read, update, delete, execute, *.roles claim (or platform role claims) and send X-MS-API-ROLE: <role>.Authenticated, and each custom-role path.Anonymous; valid identity with no X-MS-API-ROLE → Authenticated.X-MS-API-ROLE header; missing membership is 403.Simulator; DAB rejects it outside development mode.Custom is the provider name for generic JWT, not Jwt.Unauthenticated can't drive claim policies, custom roles, or Authenticated permissions.data-api-builder-authdata-api-builder-rls-policiesdata-api-builder-config