2.0.0-rc: Data API builder for Azure Databases

Changes:

• 9563a20 Fix JSON schema: fix allow-credentials default, add missing descriptions, and relax required field constraints (#3236) [ #2520, #2519, #2518, #2517, #2516 ]
• 46fa40e Set Unauthenticated as the authentication provider in the default Docker image config (#3248) [ #3074, zure/data-api-builder#3074, zure/data-api-builder#3247 ]
• e14cca5 Fix duplicate entity groups in Swagger UI when entities have descriptions (#3099) [ zure/data-api-builder#2968 ]
• fb4b2af Fix nested filter on self-referencing relationships (#3038) [ zure/data-api-builder#3028 ]
• abcfb58 Fix LogLevel: CLI phase suppression and case-insensitive "Default" config key (#3203) [ #3201 ]
• 041a722 Fix Location header to respect X-Forwarded-Proto and X-Forwarded-Host headers (#3095) [ zure/data-api-builder#3032 ]
• e128eb7 Introduce new authentication provider Unauthenticated as the default (#3075)
• 94c60e2 Make parameter length based on underlying column length except for complex ops (#2627) [ #2626 ]
• 25270b1 CodeQL Suppression for DefaultAzureCredential usage (#3233) [ #3232 ]
• 80a7f7d feat: dab init defaults runtime.rest.request-body-strict to false (#3166) [ zure/data-api-builder#3165 ]

See More

• 3199765 feat: Role inheritance for entity permissions + dab configure --show-effective-permissions (#3164) [ zure/data-api-builder#3163 ]
• 2da7963 Inherit default values for EntityCacheOption.Enabled and EntityCacheOption.Level from RuntimeCacheOptions (#3155)
• 26db37e Add default OTEL telemetry settings to dab init config generation (#3162) [ zure/data-api-builder#3161 ]
• 883f4a1 [MCP] aggregate_records DML tool (#3199) [ #3178, #3179 ]
• c4c5943 Use DotNetCoreCLI@2 for Nuget Restore to avoid 120 second timeout, and add RuntimeIdentifiers="" to avoid needing packages not in our feed (#3211)
• 0bc68fd Add dab auto-config-simulate CLI command (#3189)
• bf18263 Add currentRole to Health Summary Report at /health (#3158) [ zure/data-api-builder#3157 ]
• a7c1be3 Add default dab-config.json to Docker image (#3168) [ zure/data-api-builder#3160 ]
• 1dd0882 Add keyless REST PUT/PATCH support for entities with auto-generated primary keys (#3150)
• b2310d0 Update Validation for Autoentities (#3152) [ #3131 ]
• 77b44a0 Return default value when entity ttl is retrieved with entity cache enabled set to false (#3156)
• b5841fd fix(mcp): allow create_record for views and added tests to verify the same. (#3196) [ #3194 ]
• fd416e2 Swap to MCP packages from our feed until EngThrive-MCP service connection is fixed (#3195) [ #3154 ]
• 3064a87 Microsoft AI guidance- Migrating to Microsoft MCP package (#3154) [ #3021 ]
• 4c26d60 Add CLI command dab auto-config (#3086) [ #2964 ]
• e1e4359 Added per user connection pooling for OBO. (#3153)
• 99e30ba [OBO] Add CLI support for user-delegated authentication configuration (#3128) [ #2898, #3151, zure/data-api-builder#3127 ]
• a4fe457 Create Entities in-memory from Autoentities (#3129) [ #3052 ]
• 105fe18 Fix many-to-many relationship queries with custom schema linking objects (#3106) [ #3071 ]
• 2ec5fb6 Add On-Behalf-Of (OBO) user-delegated authentication for SQL (#3151) [ #3122 ]
• 06e2251 Fix: URL-encoded special characters in $filter and $orderby break OData parsing (#3080) [ zure/data-api-builder#3039 ]
• 29b0e6e Add level property and fix ttl-seconds validation for entity cache schema (#3097) [ zure/data-api-builder#2981 ]
• b3db9a1 Update DAB to version 2.0 (#3120) [ zure/data-api-builder#3118 ]
• 6d2e419 Update CODEOWNERS to include jerrynixon (#3139)
• 8881f37 Add centralized OpenTelemetry tracing for MCP tool execution (#3111)
• d28c38b Filter OpenAPI REST methods and fields based on role permissions (#2998) [ #2787, #2783, #2486, #2896, zure/data-api-builder#2946 ]
• 5be4abd Fix PostgreSQL health check connection string parsing (#3083) [ zure/data-api-builder#2796 ]
• 11da80a Bump dotnet-sdk from 8.0.417 to 8.0.418 (#3117) [ #52433 ]
• 6df62c0 Increase connection timeout in DW/MSSQL test pipelines (#3132)
• a971f79 Remove docker install task to fix pipeline failure (#3130)
• 2713b05 Add CLI parameter for data-source.health.name (#3059) [ zure/data-api-builder#3058 ]
• 5469784 REST Advanced Paths: Allow sub-directories in entity REST paths (#2999) [ zure/data-api-builder#1085, zure/data-api-builder#1566, zure/data-api-builder#2373 ]
• 20df64c MCP: Validate tool name uniqueness across BuiltIn and Custom tools (#3110) [ zure/data-api-builder#3049 ]
• b3efb1a Allow Entra authentication when connecting to Redis (#3047)
• c62092e Add HTTP Response Compression Support (#3003) [ #2711, zure/data-api-builder#2636 ]
• 6f62845 Add Copilot repository instructions (#3090) [ zure/data-api-builder#3089 ]
• 93a088f Create and execute query to return tables and interpolated names for Autoentities (#3082) [ #2966, #2965 ]
• c017efe Fix: Restore EntityName after processing nested filter for CosmosDB (#3072) [ #3070 ]
• b0ecbf6 [MCP] Prevent duplicating entities between custom tools and describe_entities (#3076) [ #3043 ]
• b11ab1a Entity level check if MCP Tool is enabled (#3084) [ #3017 ]
• f1a0170 Add server-level description field to MCP runtime configuration (#3016)
• 6e8ac9f Hot Reload test fix (#3018)
• 64f28dc [MCP]Fixed CLI bug in fields.primary-key updation when using update entity command. (#3077)
• 9025bb3 #3053 Fix by using custom bool parsing that if a string is found then… (#3054)
• 3cf09f9 Implementation of Custom Tool in MCP (#3048) [ #2877 ]
• a62cb9e Bump dotnet-sdk from 8.0.416 to 8.0.417 (#3063) [ #52049 ]
• de8f074 [MCP] Centralize JSON‑RPC error handling, standardize MCP response envelope, and add default anonymous role for stdio mode. (#3035)
• ee2ce9e Bug fix for pagination nested entities resulting key not found error. (#3029) [ #2374, #3026 ]
• 5b43e2b Added architecture diagram to the AI Foundry Integration doc (#3036)
• 090e68e Fix serialization for StoredProcedureDefinition inheritance (#3045)
• 725bf8c Added documentation for DAB MCP and AI Foundry integration setup. (#2971)
• 0e1b3c2 Changed the default auth provider from SWA to AppService (#2943)
• 9bbe252 Add schema and serialization support for autoentities wildcard enhancement (#2973)
• 8d62beb Fix: Exclude stored procedures from health checks (#2997) [ #2977, zure/data-api-builder#2982 ]
• eddd4c6 Bump dotnet-sdk from 8.0.415 to 8.0.416 (#2970) [ dotnet/sdk#51150, dotnet/sdk#50449, dotnet/sdk#50801, dotnet/sdk#50800, dotnet/sdk#50888, dotnet/sdk#51263, dotnet/sdk#51244, dotnet/sdk#51203, dotnet/sdk#51277, #51277, #51203 ]
• 0b43e3b Partial fix for MCP test (#2925) [ #2874 ]
• 9dad3d5 Add entity-level MCP configuration support (#2989) [ #2948 ]
• d98a4ea Suppress SM05137 in deserialization variable replacement settings (#3004)
• e83ccd8 [MCP] Added support for --mcp-stdio flag to dab start (#2983)
• 7d76286 Fix the Serialization/Deserialization issue with $ prefix columns (#2944)
• 555faaa Refactor common code shared amongst built in MCP tools (#2986)
• 499cd24 Support for .akv files to AKV variable replacement. (#2957)
• dd72498 Refactor response for Read and Update MCP tools to use built in utility functions (#2984)
• 08ca05f Added aspire sample (#2977)
• 12e5ccf Skip PR validation for non-code paths (samples, docs, schemas, templates) (#2988) [ #2977, zure/data-api-builder#2987 ]
• 3554118 Update variable replacement during de...

1.7.90: Data API builder for Azure Databases

Changes:

New Features:

• a2f779c Add support for MCP capability (#2868)
• 5ba8682, 505e0c2, a090e37, cbd3b7c, 3df5d9f, d6404b3 Add CRUDE tools that allow the MCP to interact with the database through DAB entities (#2900, #2906, #2902, #2888, #2893, #2889) [ #2833, #2830 ]
• c3515c8 Add new fields property that takes the place of the mappings and key-fields properties (#2917)
• 4c5038f, 2834f70, 51f672f Add new entity description property to allow support for richer metadata for better MCP support (#2904, #2871, #2861)
• 3b48c49 Specify permissions in describe_entities MCP tool to show all explicit operations that are allowed (#2951)
• 7b31e9a Honoring incoming request role to determine allowed permissions for describe-entities MCP tool (#2956)
• 3554118, 499cd24, d98a4ea Add support for AKV capabilities (#2882, #2957, #3004)

Improvements:

• 8a7adf3 Added optional description field to MCP runtime configuration (#3092) [ #3016 ]
• 346db29 Added MCP stdio support, changed default auth provider to AppService, added AI Foundry integration documentation. (#3034) [ #2943, #2971, #3036 ]
• dd72498, 555faaa Refactor MCP code (#2984, 2986)
• 21dde31 Improve MCP tool descriptions for ChatGPT compatibility (#2937)
• 76b4d4f Upgrade MCP Packages to Stable Version 1.0.0 (#3177)

Bug Fixes:

• c9c6eca Throw user error when Stored Procedures with unnamed aggregate columns fails due to column name returning as null (#2857) [ #2856 ]
• e553adf Fix Stored Procedure execution by ensuring JsonDocuments are cleaned up after request (#2865) [ #2858 ]
• 7228e60 Fix default settings of dml tools (#2927)
• 3adf04f Fix dml tools serialization to the config file (#2952)
• 8a7adf3 Enabled boolean properties to be set via environment variables (#3092) [ #3054 ]
• 346db29 Fixed nested entity pagination errors. (#3034) [#3029 ]

1.7.89-rc: Data API builder for Azure Databases

Changes:

Improvements:

• 76b4d4f Upgrade MCP Packages to Stable Version 1.0.0 (#3177)
• 8eeceb3 Revert "Hot Chocolate 16 Upgrade" to Stable Version (#3176)

Included Changes From:

DAB 1.7.86-rc

1.6.87: Data API builder for Azure Databases

Changes:

• Updated stable release in a new Docker image which has been updated with the latest .NET base layers.

Bug Fixes:

• 5725d34 Fix Serialization/Deserialization issue with $ prefix on columns (#3051)

This list of changes was auto generated.

1.7.81-rc: Data API builder for Azure Databases

Changes:

Improvements:

• 21dde31 Improve MCP tool descriptions for ChatGPT compatibility (#2937)
• 3b48c49 Specify permissions in describe_entities MCP tool to show all explicit operations that are allowed (#2951)
• 7b31e9a Honoring incoming request role to determine allowed permissions for describe-entities MCP tool (#2956)

Bug Fixes:

• 7228e60 Fix default settings of dml tools (#2927)
• 3adf04f Fix dml tools serialization to the config file (#2952)

Included Changes From:

DAB 1.7.75-rc

1.7.75-rc: Data API builder for Azure Databases

Changes:

New Features:

• a2f779c Add support for MCP capability (#2868)
• 5ba8682, 505e0c2, a090e37, cbd3b7c, 3df5d9f, d6404b3 Add CRUDE tools that allow the MCP to interact with the database through DAB entities (#2900, #2906, #2902, #2888, #2893, #2889) [ #2833, #2830 ]
• c3515c8 Add new fields property that takes the place of the mappings and key-fields properties (#2917)
• 4c5038f, 2834f70, 51f672f Add new entity description property to allow support for richer metadata for better MCP support (#2904, #2871, #2861)

Improvements:

• 271cbf4 Upgraded to Hot Chocolate 16 (#2822) [ #2789 ]

Bug Fixes:

• c9c6eca Throw user error when Stored Procedures with unnamed aggregate columns fails due to column name returning as null (#2857) [ #2856 ]
• e553adf Fix Stored Procedure execution by ensuring JsonDocuments are cleaned up after request (#2865) [ #2858 ]

1.6.84: Data API builder for Azure Databases

Updated stable release in a new Docker image which has been updated with the latest .NET base layers. No other DAB engine changes have been made.

1.6.77: Data API builder for Azure Databases

Updated stable release in a new Docker image which has been updated with the latest .NET base layers. No other DAB engine changes have been made.

1.6.68: Data API builder for Azure Databases

Updated stable release in a new Docker image which has been updated with the latest .NET base layers. No other DAB engine changes have been made.

1.6.67: Data API builder for Azure Databases

Changes:

New Features:

• 7b6259b, dc8d6ec, 75d9381, 8ea24db Add support for Azure Log Analytics (#2781, #2727, #2787, #2805) [ #2777, #2726, #2778, #2804 ]

• 75d9381, 7b6259b, dc8d6ec Add support for File Sink (#2727, #2781, #2787) [ #2726, #2777, #2778 ]

• a3029b9 Add Level 2 Caching (#2619) [ #2543 ]

• 48d1f8f Include config options and CLI configure command for Azure Key Vault support. (#2745)

Improvements:

• b421212 Configure Dependabot for Automated .NET SDK Updates (#2740)

• d05fecb Enhance JSON Schema: Add Authentication Validation and Provider List (#2646) [ #2643 ]

• bfb7dd4 Optimize Health check response using parallel queries (#2714) [ #2533 ]

• a5f4f8e Upgrade Microsoft.Data.SqlClient to New Version (#2702) [ #2690 ]

• 63b2939 Support for IN operator in FilterInput for SQL DB types (#2700)

• 2885360 Support for relative nextLink using new next-link-relative property for Reverse Proxy Scenarios (#2788) [ #2677 ]

• 8904ef4 Ensure Create policy supported for DWSQL (#2760) [ #2759 ]

Bug Fixes:

• a294b8a CodeQL suppression for DefaultAzureCredential default and SwaggerUI usage (#2747) [ #2746 ]

• 79ffe37 Remove caseInsensitive filter operator added back by incorrect merge (#2780) [ #2280 ]

• 8c974d6 Prevent Generation of Empty Input Nodes in Mutation Builder (#2729)

• 37343c0 Handle unauthorized fields in aggregation (#2790) [ #2776 ]

• 58fefcb Platform agnostic port resolution for Health check endpoint (#2757) [ #2765 ]

• 5e3e5e2 Fix Session Context Key set as Read_Only (#2344) [ #2341 ]

• 5e3e5e2 Fix Row Level Security by maintaining original roles from the JWT token (#2344)

• 353838b Fix Azure Log Analytics 'flush-interval-seconds' property (#2862) [ #2854 ]