DAB 2.0 Preview introduces `autoentities`, a pattern-based autoconfiguration feature for Microsoft's Data API Builder that automatically discovers and exposes SQL Server database objects (tables, views, stored procedures) as REST and GraphQL endpoints at startup. Instead of manually defining every entity in `dab-config.json`, you define named definitions with include/exclude patterns using T-SQL LIKE syntax, a naming template, endpoint settings, and role-based permissions. The CLI command `dab auto-config` writes these definitions to config, while `dab auto-config-simulate` dry-runs pattern matching against a live database without persisting changes — useful for CI/CD validation. Multiple definitions can target different schema subsets with different permission levels, and `autoentities` can coexist with explicit `entities` blocks, with explicit definitions taking precedence on name collisions. Currently limited to MSSQL and not recommended for production.

6m read timeFrom bartwullems.blogspot.com
Post cover image
Table of contents
Getting startedHow it worksPatternsUsing the CLIPreview matches before committingMixing autoentities with entitiesFull example: Multiple definitionsWhat to watch forMore information

Sort: