Azure/data-api-builder
Data Api Builder
Data API builder is a service that automatically generates REST and GraphQL endpoints directly from database schemas and stored procedures. By interpreting database metadata, it provides immediate programmatic access to information without requiring the development of custom backend routes or manual query logic.
The engine distinguishes itself through a metadata-driven translation layer that maps incoming HTTP requests to native database queries while enforcing granular, role-based access control and row-level security policies. It includes a dedicated bridge for AI agents, allowing these systems to interact with database schemas and retrieve records using natural language commands through standardized protocols.
The platform manages application behavior through a declarative configuration engine, supporting modular request pipelines that handle authentication, rate limiting, and query transformation. It incorporates performance-oriented features such as in-memory query caching and resource consumption limits to maintain stability under heavy load. Operational visibility is supported through standardized logging, tracing, and health monitoring endpoints.
Users manage the service lifecycle, configuration, and deployment tasks through a command-line interface. The system supports secure, decoupled settings by dynamically injecting environment variables and sensitive credentials from external management services.
Features
- Database-to-REST Interfaces - Automatically generates REST and GraphQL endpoints from database schemas to provide immediate programmatic data access.
- Database - Provides a gateway that translates HTTP requests into native database queries while enforcing granular role-based access control.
- Metadata-Driven Schema Mappers - Maps database schemas to web-friendly API interfaces using a metadata-driven configuration engine.
- Database Query Translators - Translates incoming HTTP requests into native database queries to simplify data access without custom backend logic.
- GraphQL Schema Generators - Generates GraphQL schemas by introspecting database structures to support complex queries and relationships.
- GraphQL API Generators - Automatically derives REST and GraphQL endpoints directly from database schemas and stored procedures.
- GraphQL Integrations - Exposes database entities through a GraphQL interface to support flexible data retrieval.
- Database REST APIs - Generates RESTful endpoints from database schemas to provide standard data access methods like filtering and pagination.
- Role-Based Access Control - Enforces granular role-based access control and row-level security policies on database entities.
- Role-Based Access Controls - Enforces granular security policies and row-level filters on database queries based on user roles.
- Agent Connectivity Interfaces - Connects intelligent agents to database schemas using standardized protocols for natural language data interaction.
- AI Agent Integrations - Exposes database schemas to AI agents using standardized protocols for natural language interaction.
- Model Context Protocol Servers - Exposes database entities to AI agents using the Model Context Protocol for natural language data interaction.
- Query Result Caching - Implements in-memory query result caching to reduce latency and minimize load on the primary database.
- Declarative Configuration Engines - Manages application behavior and data connectivity through declarative configuration files.
- Middleware-Based Request Pipelines - Processes incoming traffic through modular middleware handlers for authentication, rate limiting, and query transformation.
- Request Authentications - Validates incoming traffic using external identity providers to secure database operations.
