--- title: What's New in Data API builder (DAB) 2.0 | Data Exposed description: Data API Builder (DAB) 2.0 is an open-source Microsoft project that acts as a drop-in container between your application and database, auto-generating REST,... canonical: https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: What's New in Data API builder (DAB) 2.0 | Data Exposed | daily.dev og:description: Data API Builder (DAB) 2.0 is an open-source Microsoft project that acts as a drop-in container between your application and database, auto-generating REST,... og:url: https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj og:image: https://api.daily.dev/og/posts/C58CEpEFj.png og:image:alt: What's New in Data API builder (DAB) 2.0 | Data Exposed og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # What's New in Data API builder (DAB) 2.0 | Data Exposed **[Microsoft Developer](https://daily.dev/sources/microsoftdeveloper)** · 18 min read · 0 upvotes · 0 comments ## Summary Data API Builder (DAB) 2.0 is an open-source Microsoft project that acts as a drop-in container between your application and database, auto-generating REST, GraphQL, and now MCP endpoints directly from SQL databases. Version 2.0 adds Redis caching, On-Behalf-Of (OBO) authentication, Azure Key Vault integration, compound REST paths, and MCP support for agentic AI applications. Configuration is done via a single JSON file, and a VS Code extension (Omnibus) simplifies setup. DAB supports Azure SQL, PostgreSQL, MySQL, and Cosmos DB simultaneously, includes row-level security policies at the API layer, and is used internally by Microsoft Fabric and other products. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What new features are in Data API Builder (DAB) 2.0? Data API Builder 2.0 adds MCP server capability for agentic apps to query SQL directly, Redis caching support, an on-behalf-of (OBO) authentication method for passing credentials, Azure Key Vault integration, compound paths for REST endpoints, and the ability to add descriptions to table columns that get passed as semantic data to AI models. It can expose REST, GraphQL, and MCP simultaneously from one container. _Developers tracking new ways to expose databases to AI agents can follow Data API Builder updates on daily.dev._ ### Can Data API Builder expose a database as an MCP server for AI agents? Yes, since version 2.0, Data API Builder can enable an MCP endpoint alongside REST and GraphQL from the same deployed container, letting agentic applications wrapped around a model query a SQL database directly. Column descriptions defined in the config are passed along as semantic data to help the model understand the schema. _Anyone building agent-to-database integrations can keep up with MCP tooling changes on daily.dev._ ### What databases does Data API Builder support? Data API Builder connects to Azure SQL, PostgreSQL, MySQL, and Cosmos DB, and it can connect to multiple databases simultaneously, including a mix of on-premises and cloud instances, all configured through a single JSON file that defines connection strings and the tables, views, and stored procedures to expose. _Teams comparing database-to-API tooling options can track this space on daily.dev._ ## Similar posts on daily.dev - [Data API builder 2.1.5: JSON and Vector Support](https://daily.dev/posts/data-api-builder-2-1-5-json-and-vector-support-nhjqjw4dc) · DevBlogs · 1 upvotes · 0 comments - [Get a visual config UI](https://daily.dev/posts/get-a-visual-config-ui-qdmwc7yfk) · The Art of Simplicity · 1 upvotes · 0 comments - [Compose your API surface with Data API builder custom paths](https://daily.dev/posts/compose-your-api-surface-with-data-api-builder-custom-paths-08j1zenat) · DevBlogs · 0 upvotes · 0 comments --- Tags: [#sql](https://daily.dev/tags/sql), [#mcp](https://daily.dev/tags/mcp), [#graphql](https://daily.dev/tags/graphql), [#rest-api](https://daily.dev/tags/rest-api) [View this post on daily.dev](https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"What's New in Data API builder (DAB) 2.0 | Data Exposed","url":"https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj"},"datePublished":"2026-07-16T16:28:00.570Z","dateModified":"2026-09-14T09:09:26.442Z","description":"Data API Builder (DAB) 2.0 is an open-source Microsoft project that acts as a drop-in container between your application and database, auto-generating REST,...","image":"https://i.ytimg.com/vi/8b_4ftQP1IY/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/8b_4ftQP1IY/sddefault.jpg","isAccessibleForFree":true,"articleSection":"Microsoft Developer","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Microsoft Developer","logo":"https://media.daily.dev/image/upload/s--xZzU3zUq--/f_auto/v1746714872/logos/microsoftdeveloper","url":"https://daily.dev/sources/microsoftdeveloper"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"sql,mcp,graphql,rest-api","timeRequired":"PT18M","video":{"@type":"VideoObject","name":"What's New in Data API builder (DAB) 2.0 | Data Exposed","description":"Data API Builder (DAB) 2.0 is an open-source Microsoft project that acts as a drop-in container between your application and database, auto-generating REST,...","thumbnailUrl":"https://i.ytimg.com/vi/8b_4ftQP1IY/sddefault.jpg","uploadDate":"2026-07-16T16:28:00.570Z","duration":"PT18M","url":"https://api.daily.dev/r/C58CEpEFj","embedUrl":"https://www.youtube.com/embed/8b_4ftQP1IY"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Microsoft Developer","item":"https://daily.dev/sources/microsoftdeveloper"},{"@type":"ListItem","position":3,"name":"What's New in Data API builder (DAB) 2.0 | Data Exposed"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/what-s-new-in-data-api-builder-dab-2-0-data-exposed-c58cepefj#faq","mainEntity":[{"@type":"Question","name":"What new features are in Data API Builder (DAB) 2.0?","acceptedAnswer":{"@type":"Answer","text":"Data API Builder 2.0 adds MCP server capability for agentic apps to query SQL directly, Redis caching support, an on-behalf-of (OBO) authentication method for passing credentials, Azure Key Vault integration, compound paths for REST endpoints, and the ability to add descriptions to table columns that get passed as semantic data to AI models. It can expose REST, GraphQL, and MCP simultaneously from one container. Developers tracking new ways to expose databases to AI agents can follow Data API Builder updates on daily.dev."}},{"@type":"Question","name":"Can Data API Builder expose a database as an MCP server for AI agents?","acceptedAnswer":{"@type":"Answer","text":"Yes, since version 2.0, Data API Builder can enable an MCP endpoint alongside REST and GraphQL from the same deployed container, letting agentic applications wrapped around a model query a SQL database directly. Column descriptions defined in the config are passed along as semantic data to help the model understand the schema. Anyone building agent-to-database integrations can keep up with MCP tooling changes on daily.dev."}},{"@type":"Question","name":"What databases does Data API Builder support?","acceptedAnswer":{"@type":"Answer","text":"Data API Builder connects to Azure SQL, PostgreSQL, MySQL, and Cosmos DB, and it can connect to multiple databases simultaneously, including a mix of on-premises and cloud instances, all configured through a single JSON file that defines connection strings and the tables, views, and stored procedures to expose. Teams comparing database-to-API tooling options can track this space on daily.dev."}}]} ```