Azure/data-api-builder

Data API builder provides modern REST, GraphQL endpoints and MCP tools to your Azure Databases and on-prem stores.

What it solves

Data API builder (DAB) eliminates the need to write manual boilerplate code to create APIs for your database. It provides a no-code way to instantly generate secure, full-featured REST and GraphQL endpoints from your existing database schema, allowing developers to focus on business logic rather than CRUD operations.

How it works

DAB acts as a CRUD data API engine that runs in a container. It reads a JSON configuration file to map database entities (tables, views, or stored procedures) to API endpoints. When a request arrives, DAB authorizes the user and translates the HTTP request into a SQL query, executes it against the supported database, and returns the results as JSON.

Who it’s for

Developers who need to quickly expose database data via APIs without writing backend code, regardless of whether they are deploying to Azure, other clouds, or on-premises environments.

Highlights

  • Multi-database support: Supports Azure SQL, SQL Server, SQLDW, Cosmos DB, PostgreSQL, and MySQL.

  • Cros-platform deployment: Can be run in containers on Azure, AWS, GCP, or on-premises.

  • Multiple endpoint types: Generates REST, GraphQL, and MCP endpoints.

  • Developer productivity: Includes integrated tooling, telemetry, and built-in support for Swagger and Nitro UI for API exploration.

Related

  • Project
    9tigerio/db2rest

    A low-code REST API platform that automatically creates secure endpoints for databases, enabling faster development of AI and data-driven applications.

  • Project
    prest/prest

    A production-ready API that instantly turns a PostgreSQL database into a REST and Model Context Protocol (MCP) API without requiring a custom backend.

  • Project
    baserow/baserow

    An open-source, no-code platform for building databases, automations, and AI agents, providing a secure alternative to Airtable with full data ownership.

  • Project
    polterguy/magic

    An open-source platform for generating secure full-stack apps and AI agents from natural language, featuring a compiled runtime and built-in MCP server for self-hosted deployment.

  • Project
    liyupi/yu-ai-code-mother

    An enterprise-grade zero-code AI application generation platform that transforms text requirements into deployable software using AI agents and workflows.