Leverage Azure Database with Microsoft's Data API Builder
Hi, I'm Jon. The world of AI and technology is evolving every day, and new tools are emerging that are useful for developers and business people. Today, I'd like to focus on a tool called "Data API Builder" (DAB), provided by Microsoft. This tool easily converts Azure databases into REST and GraphQL APIs. For beginners, REST is a standard way to exchange data on the web, and GraphQL is a new technology that allows for flexible data querying. Based on an article from InfoWorld, I'll provide an overview of DAB and the latest information in an easy-to-understand manner.
Recommended for those who want to start automating with no coding!
With Make.com (formerly Integromat)...
📌 Integrate major tools like email, Slack, Google Sheets, and Notion all at once
📌 Automate complex tasks with just drag and drop
📌 A free plan is also available, so you can try it out for yourself.
If you're interested, here's the details:
What is Make.com (formerly Integromat)? How to Use It, Pricing, Reviews, and Latest Information [2025 Edition]
What kind of tool is Data API Builder?
Data API Builder (DAB) is an open-source tool developed by Microsoft that automatically creates APIs based on databases. It generates REST and GraphQL endpoints for Azure databases, such as Azure SQL Database and Azure Cosmos DB. An endpoint is an access point for an API. Developers can use it to easily integrate database data into their apps and web services.
The appeal of this tool is that it allows you to create APIs without writing code. Database tables and views can be turned into APIs simply by writing a configuration file. According to the official Microsoft Learn documentation, DAB is cross-platform and runs as a Docker container, so it can be used on-premise or on other clouds, not just Azure. For beginners, think of Docker as "a technology that allows you to containerise software and run it anywhere."
Recently, DAB has been announced to be generally available (GA) on May 16, 2024. This means that it has moved from beta to official, proving its reliability. It has been featured in Microsoft's Data Exposed video series, and is said to be a tool packed with best practices that has been developed with thousands of engineering hours invested into it.
Main features of DAB
Here are some of the features of DAB. Based on official information, we'll summarize them in an easy-to-understand way:
- REST and GraphQL support: In addition to traditional REST APIs, you can also generate GraphQL, which efficiently retrieves only the data you need, improving your app's performance.
- Database support: Supports Azure SQL, Azure Cosmos DB, MySQL, and PostgreSQL. An article in InfoWorld on October 2, 2025, pointed out that this allows for flexible use of databases other than Azure.
- Security featuresIt has built-in authentication and authorization, and securely protects your data through integration with Azure Active Directory (AAD). For the uninitiated, AAD is Microsoft's identity management service.
- Cross platform: It is Docker compatible, so it can run on Windows, Linux, and macOS. This means you can use any development environment.
Latest Updates and News for 2025
DAB continues to evolve in 2025. According to the Azure SQL Devs' Corner blog, version 1.6 was recently released and new features were added. Specifically, an article published around September 30, 2025, introduced advanced behavior control using special HTTP headers. HTTP headers are additional information in web communications. This makes it easier to customize API responses.
Additionally, the update from a week ago, around September 27, 2025, emphasized flexible logging capabilities. Integration with Azure Log Analytics has been strengthened, making it easier for developers to analyze logs. Logs are records of system operations and are essential for debugging. These updates have made DAB more practical.
At Microsoft Build 2025 (June 3, 2025), DAB was featured in Azure news and positioned as part of AI Foundry and data platform enhancements. On X (formerly Twitter), an InfoWorld article was shared on October 2, 2025, sparking discussion in the developer community. DAB's versatility was also highlighted in posts from the MySQL community.
Additionally, the .NET Aspire Community Toolkit documentation (published November 20, 2024) for DAB hosting integration explains how to host it as a container, and is still in use as of 2025. This makes it easy to deploy DAB in the cloud or locally.
Practical usage examples
Here's a quick guide on how to use DAB. Here are the steps based on the official guide:
- Installation: Download the CLI tool and set up DAB with commands.
- Creating a configuration file: Define database connections and entities (tables, etc.) in a JSON file.
- API generation: When you run the command, a REST/GraphQL endpoint will be launched.
- Testsｓｓｓ: Try out the API with a tool like Postman.
This makes the database available as an API, which is useful for, for example, querying product data in an e-commerce app using GraphQL.
By the way, we also recommend using an AI tool to create documents in combination with these API tools. Using the AI tool Gamma, you can instantly create documents and slides. For more information,This articlePlease refer to the following.
Benefits and precautions of DAB
The advantage of DAB is that it reduces development time. Traditionally, creating an API yourself required writing code, but with DAB, all you need to do is configure it. It offers seamless integration, especially for Azure users. An InfoWorld article (October 2, 2025) praised its flexibility, allowing it to be used in non-Azure environments thanks to its support for MySQL and Postgres.
However, please note that if you need complex business logic, you will need to add custom code. Also, there is a risk of data leakage if security settings are not properly configured, so please read the official documentation carefully.
Summary: Accelerate data utilization with DAB
DAB is a powerful tool that turns databases into APIs, and the 2025 update makes it even easier to use. Even beginners can start with CLI operations, so it is recommended for Azure users.
If you're interested in AI tools, try out Gamma for document creation.What is Gamma? A new standard for instant creation with AI [Documents, Slides, Websites]
In summary, Jon says tools like DAB lower the barrier to development and help you quickly bring your ideas to life. Take advantage of the advances in technology and find ways to use them that suit you. For the latest information, check the official website.
Reference sources
- InfoWorld: Using Microsoft's Data API builder for Azure databases (2025-10-02)
- Microsoft Learn: Data API builder documentation
- Azure SQL Devs' Corner: Data API builder 1.6 updates (2025-09-30 and 2025-09-27)
- Microsoft Azure Blog: All the Azure news from Microsoft Build 2025 (2025-06-03)
- X (formerly Twitter): Related posts on DAB features and updates (2025 various dates)