![\"Data](\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2023\/03\/dab-architecture-overview.png\")
<\/a><\/p>\nData API builder can be used on any new or existing databases, without any special requirement or changes needed on the database.<\/p>\n
Works offline<\/h2>\n
Data API builder works offline to provide a full and rich offline development experience. It can work with local SQL Servers or Azure SQL Emulators so that anything can be done offline for the maximum comfort.<\/p>\n
Like any modern development tools, it has a dedicated CLI, the Data API builder (DAB) CLI, that allows you to run Data API builder on your machine and manage everything needed to have Data API builder up and running locally. In fact, aside the SQL Server or Azure SQL database, a configuration file is all you need:<\/p>\n
dab init --database-type mssql --connection-string \"@env('AZURE_SQL_CONNSTR')\"\r\ndab add Book --source dbo.books --permissions \"anonymous:*\"\r\ndab start<\/code><\/pre>\nData API builder is a .NET core (so it runs on any OS: Windows, Linux and MacOS) application and is distributed via NuGet, so that it can be installed using dotnet tool. Just run:<\/p>\n
dotnet tool install --global Microsoft.DataApiBuilder<\/code><\/pre>\nand you will be good to go.<\/p>\n
Open Source<\/h2>\n
Data API builder is open source. We want everyone to be able to use and take advantage of Data API builder, as we love developers, and we want them able to do more with the time they have at their hands. Let Data API builder take care of exposing SQL Server or Azure SQL database as GraphQL and REST API so that you can focus on building amazing user experiences and architectures.<\/p>\n
We also love the community, as the #sqlfamily hashtag has clearly shown over the years, and we want to make sure Data API builder is built with a strong sense of community, so that we can make Data API builder an excellent product for everyone, together.<\/p>\n
Source code is available here:\u00a0https:\/\/aka.ms\/dab<\/a><\/p>\nRun Data API builder on Azure<\/h2>\n
Being a .NET Core application, deployment on Azure is amazingly simple and can be done by taking advantage of the container image you can find here:<\/p>\n
https:\/\/mcr.microsoft.com\/en-us\/product\/azure-databases\/data-api-builder\/about<\/a><\/p>\nUsing services like Azure Container Instances, Azure Kubernetes Service or even Azure Web App, Data API builder can run on Azure using the container solution you prefer.<\/p>\n
Integrated with Static Web App<\/h2>\n
Azure Data API builder for Azure SQL Databases is integrated with Azure Static Web App<\/a> (SWA), through the new Database Connection<\/a> feature: deploying the entire backend to connect to your favorite database using REST or GraphQL is just a git push<\/em> away.<\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2023\/03\/Picture1.png\")
<\/a><\/p>\nData API builder is fully integrated also with the offline development experience provided by SWA via the SWA CLI, so that you can create a complete fullstack solution completely offline, test it on your local machine and push it into production using well-established DevOps workflows via GitHub actions.<\/p>\n
swa start --data-api-location .\/swa-db-connections<\/code><\/pre>\nGetting started<\/h2>\n
If you want to try it out right away, a full working example is available here: ToDo App with Data API builder, Static Web Apps and Azure SQL<\/a>. It contains anything needed for a jamstack application: frontend using Vue3, backend using Data API builder and the Azure SQL Database projects.<\/p>\nFull documentation with a complete Getting Started guide is available here: https:\/\/aka.ms\/dabdocs<\/a>.<\/p>\nContribute<\/h2>\n
Data API builder is Open Source, and we are thrilled for getting your ideas and feedback on how to improve Data API builder. Use the “Discussion<\/a>” page available in the GitHub repo, to start a discussion, propose an idea or provide some feedback and keep it going.<\/p>\nWhat else?<\/h2>\n
Data API builder supports not only Azure SQL database and SQL Server but also all other Azure Databases like Cosmos DB<\/a>, PostgreSQL<\/a>, and MySQL<\/a>. Look at what Data API builder can do for other databases and with Static Web Apps here:<\/p>\n\n- Azure Data API builder documentation<\/a><\/li>\n
- Azure Data API builder samples<\/a><\/li>\n
- Azure Static Web Apps Database Connections<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
I am extremely happy and excited to announce the public preview of Data API builder for Azure SQL Databases. Data API builder is a new product that we are adding to the developer\u2019s toolset to help every developer to be more efficient and effective, by instantly and securely turning Azure SQL Databases into a modern […]<\/p>\n","protected":false},"author":24720,"featured_media":1786,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[409,510,504,410],"class_list":["post-1783","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","tag-api","tag-azure-sql-database","tag-graphql","tag-rest"],"acf":[],"blog_post_summary":"
I am extremely happy and excited to announce the public preview of Data API builder for Azure SQL Databases. Data API builder is a new product that we are adding to the developer\u2019s toolset to help every developer to be more efficient and effective, by instantly and securely turning Azure SQL Databases into a modern […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/1783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/24720"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=1783"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/1783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/1786"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=1783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=1783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=1783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}