> Markdown version of [/videos/1194-say-goodbye-to-building-boring-apis-with-azure-data-api-builder?t=682](https://www.wearedevelopers.com/videos/1194-say-goodbye-to-building-boring-apis-with-azure-data-api-builder?t=682). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Say goodbye to building boring APIs with Azure Data API Builder Stop writing repetitive boilerplate for basic CRUD APIs. Azure Data API Builder dynamically generates secure REST and GraphQL endpoints directly from your database. - **Speakers:** [Sander ten Brinke](https://www.wearedevelopers.com/@sander-ten-brinke) - **Event:** World Congress 2024 - **Published:** August 29, 2024 - **Duration:** 30:01 - **URL:** https://www.wearedevelopers.com/videos/1194-say-goodbye-to-building-boring-apis-with-azure-data-api-builder ## Summary Building basic CRUD APIs is often repetitive and over-engineered, requiring significant boilerplate for routing, mapping, and connection handling. Azure Data API Builder completely eliminates this monotony by dynamically generating REST and GraphQL endpoints directly from your database at runtime. Driven by a straightforward configuration file rather than custom code, this open-source tool seamlessly wraps databases like SQL Server, Cosmos DB, Postgres, and MySQL without vendor lock-in.<br><br>Operating as a standalone utility, the builder provides out-of-the-box capabilities that typically require bespoke engineering, including OData-based filtering, built-in memory caching, and automatic OpenAPI documentation. Security remains highly customizable; developers can orchestrate role-based access control, enforce item-level row filtering, and mask specific database columns. Teams can also instantly test endpoints using integrated interfaces like Banana Cake Pop for complex GraphQL schema queries and entity relationship mapping.<br><br>Since the tool is designed exclusively for data mapping and does not execute custom code, advanced scenarios are managed efficiently by routing special requests through an API management layer to serverless solutions like Azure Functions. While it can be hosted anywhere using Docker containers, integrating it directly with Azure Static Web Apps creates a particularly powerful web development experience. This architecture frees engineering teams to focus entirely on frontend functionality and business-critical logic instead of maintaining repetitive and boring data access layers. **Keywords:** azure data api builder, crud api automation, rest and graphql generation, openapi schema documentation, odata filtering syntax, automated database wrapping, role-based access control, item-level row security, database column masking, docker container hosting, azure static web apps, serverless function routing, api management gateways, customizable endpoint caching, cross-platform database support ## Chapters 1. **Repetitive tasks in building simple database APIs** (00:17) — The redundant work involved in creating simple database wrapper APIs from scratch. 1. **Introduction to Data API Builder and core features** (02:59) — How the toolkit generates APIs at runtime to expose database entities without framework vendor lock-in. 1. **Installing and initializing the Data API Builder** (06:09) — The required command-line steps to install the tool locally and initialize a resilient database connection. 1. **Understanding the Data API Builder configuration file** (07:46) — How to manage database connections, runtime caching, and specific entity alignments using JSON schemas. 1. **Consuming the API via REST, OData, and GraphQL** (09:29) — Client-side querying capabilities including server-calculated data filtering and deeply nested entity relationships. 1. **Reviewing the Data API Builder system architecture** (11:22) — The core infrastructure operations that convert schema definitions into accessible REST and GraphQL endpoints dynamically. 1. **Demonstrating Data API Builder with a React front end** (11:58) — A practical browser walk-through validating role-based user access and relationship-centric GraphQL mutations live. 1. **Running custom code and managing API security policies** (17:04) — Patterns for extending operations with serverless functions and enforcing role-specific item control logic dynamically. 1. **Deployment options across cloud providers and on-premise servers** (21:31) — Packaging and hosting the generated API using containerized platforms and managed Kubernetes deployment environments. 1. **Integrating endpoints with Azure Static Web Apps** (22:41) — Connecting stateless front ends to a backend routing system without self-managing API server infrastructure. 1. **Project roadmap, provided resources, and community questions** (24:49) — Upcoming framework updates including hot reloading alongside audience technical questions covering backend configurations. ## Related Moments - [Automating documentation and code generation with OpenAPI standards](https://www.wearedevelopers.com/videos/759-awful-apis-a-history-lesson-in-industry-mistakes-and-mishaps) (from "Awful APIs: A History Lesson in Industry Mistakes and Mishaps") - [Exposing database structures as standard REST APIs](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) (from "Kubernetes and Microservices with Multi-Model Databases") - [Architectural benefits and implementation challenges of databaseless systems](https://www.wearedevelopers.com/videos/1024-databaseless-data-processing-high-performance-for-cloud-native-apps-and-ai) (from "Databaseless Data Processing - High-Performance for Cloud-Native Apps and AI") - [Overcoming challenges with OpenAPI generators for custom SDKs](https://www.wearedevelopers.com/videos/128-building-a-friendly-kotlin-sdk-to-connect-to-jetbrains-space) (from "Building a Friendly Kotlin SDK to Connect to JetBrains Space") - [Generating frontend APIs with GraphQL and OpenAPI](https://www.wearedevelopers.com/videos/1580-end-to-end-typescript-completing-the-modern-development-stack) (from "End-to-End TypeScript: Completing the Modern Development Stack") - [Event welcome and introduction to the Builder ecosystem](https://www.wearedevelopers.com/videos/605-qwik-making-sure-that-easy-is-same-as-performant) (from "Qwik: Making sure that easy is same as performant") ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix) - [Dev Digest 139 - Soft and hard queries](https://www.wearedevelopers.com/magazine/487-dev-digest-139-soft-and-hard-queries) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) ## Related Jobs - [Staff Software Engineer](https://www.wearedevelopers.com/jobs/ext/1425755-staff-software-engineer) at **GitHub** - [Senior Software Engineer, Data](https://www.wearedevelopers.com/jobs/48273-senior-software-engineer-data) at **Sportradar Media Services GmbH** - [Senior Software Engineer,Billing](https://www.wearedevelopers.com/jobs/ext/1991843-senior-software-engineer-billing) at **GitHub** - [AI Software Engineer (Germany)](https://www.wearedevelopers.com/jobs/48317-ai-software-engineer-germany) at **Sunhat** - [AI Full Stack Engineer](https://www.wearedevelopers.com/jobs/ext/1354435-ai-full-stack-engineer) at **Almedia** - [Backend Entwickler C#/.NET iv.)](https://www.wearedevelopers.com/jobs/ext/1262419-backend-entwickler-c-net-iv) at **Bosch-Gruppe Österreich**